uncleflo
Registered since September 28th, 2017
Has a total of 4246 bookmarks.
Showing top Tags within 33 bookmarks
howto information development guide reference administration design website software solution service product online business uk tool company linux code server system application web list video marine create data experience description tutorial explanation technology build blog article learn world project boat download windows security lookup free performance javascript technical network control beautiful support london tools course file research purchase library programming image youtube example php construction html opensource quality install community computer profile feature power browser music platform mobile work user process database share manage hardware professional buy industry internet dance advice installation developer 3d search camera material access customer travel test standard review documentation css money engineering webdesign engine develop device photography digital api speed source program management phone discussion question event client story simple water marketing yacht app content setup package fast idea interface account communication cheap compare script study market easy live google resource operation startup monitor training
Tag selected: sql.
Looking up sql tag. Showing 33 results. Clear
Download Query Express
Saved by uncleflo on April 18th, 2019.
Query Express is a simple Query Analyzer look-alike, but being small and free, it can be run where the SQL Server client tools are not installed or licensed. This makes it especially useful as a query tool for MSDE and SQL Express. It also connects, to Oracle and other OLE-DB compliant databases. Query Express requires no installation and is packaged as a single 100KB executable. This is more than 300 times smaller than SQL Server Management Studio! Query Express is ideal for those not yet ready for LINQPad.
query permissive analyzer compliant package program setup playground oracle browser definitive server compatible express file client ideal framework tool useful ready windows object visual maintain contact source reference simple look sql sqlclient connection ole portable manage management data
How to use MySQL to search in php serialized fields
Saved by uncleflo on June 22nd, 2018.
Well, first rule – you should not do this. But if there is good reason, consider using such query for searching in index-based arrays: SELECT * FROM table WHERE your_field_here REGEXP '.*;s:[0-9]+:"your_value_here".*' In case you have assoc array serialized you can use: SELECT * FROM table WHERE your_field_here REGEXP '.*"array_key_here";s:[0-9]+:"your_value_here".*' Of course it won’t be very fast but in small tables should be enough
rule index mysql search query array regex fast table associate serialized reason field php database stored solution development code sql
How to find out who is locking a table in MySQL
Saved by uncleflo on April 18th, 2018.
MySQL is adding more tools to monitor its internals with every new release, but one thing it still lacks is a way to find out who is locking what, and therefore which transactions block which other ones. This is such a vital feature that I’m considering writing my own patch to the source! Still, it is possible, to a limited extent, to find out who’s locking resources. In this article I’ll explain how you can do that. This article is the second in a series on how to use the innotop MySQL and InnoDB monitor.
mysql sql lock mechanism deadlock error development administration howto article description innodb innotop release monitor tool feature transaction explain blog
VividCortex - Application performance starts with your database
Saved by uncleflo on April 18th, 2018.
Most app performance issues originate in the database, but engineering teams lack visibility into the data tier. VividCortex provides unique insights into database workload and query performance, enabling faster issue resolution. The result is better application performance, reliability, and uptime. This ebook will help you understand key questions that you should pose about your database—and it will show you exactly how you can answer them, quickly and safely, with VividCortex.
performance development engineering team database db test optimization overview analysis question code query sql
MySQL LOCK TABLES and UNLOCK TABLES Syntax
Saved by uncleflo on April 18th, 2018.
MySQL enables client sessions to acquire table locks explicitly for the purpose of cooperating with other sessions for access to tables, or to prevent other sessions from modifying tables during periods when a session requires exclusive access to them. A session can acquire or release locks only for itself. One session cannot acquire locks for another session or release locks held by another session. Locks may be used to emulate transactions or to get more speed when updating tables. This is explained in more detail later in this section. LOCK TABLES explicitly acquires table locks for the current client session. Table locks can be acquired for base tables or views. You must have the LOCK TABLES privilege, and the SELECT privilege for each object to be locked.
lock unlock lock mechanism sql mysql database db development administration howto release data table code deadlock solution description reference documentation
MySQL EXPLAIN Output Format
Saved by uncleflo on April 18th, 2018.
The EXPLAIN statement provides information about how MySQL executes statements. EXPLAIN works with SELECT, DELETE, INSERT, REPLACE, and UPDATE statements. EXPLAIN returns a row of information for each table used in the SELECT statement. It lists the tables in the output in the order that MySQL would read them while processing the statement. MySQL resolves all joins using a nested-loop join method. This means that MySQL reads a row from the first table, and then finds a matching row in the second table, the third table, and so on. When all tables are processed, MySQL outputs the selected columns and backtracks through the table list until a table is found for which there are more matching rows. The next row is read from this table and the process continues with the next table.
explain explanation analysis mysql development administration query sql statement howto analyse optimize table method loop process row column output reference execution dbms innodb
Temporary tables in SQL query optimization
Saved by uncleflo on April 18th, 2018.
SQL queries can get complex in a big hurry. If you are querying multiple tables, and in particular if your query involves operations like UNION and INTERSECT, then you can find yourself in a big, messy pile of SQL. Worse, that big pile will often run slowly, sometimes to the point where a web application times out! I won’t inflict a real-world example on you; that would be cruel. So let’s look at a “toy” problem, keeping in mind that this won’t illustrate any time-savings, just the technique involved.
query complex temporary table operation union intersect problem description solution development database db howto sql optimize blog article
select without from
Saved by uncleflo on March 27th, 2018.
Let's get that straight from the beginning: select without from is not standard conforming SQL. Full stop. Nevertheless it works in many databases—also in standard conforming ones. That's no contradiction: the standard explicitly allows conforming databases to “provide user options to process non-conforming SQL statements”0. The behavior of such statements is completely up to the vendor, of course. So what alternative does the standard offer to select without from? A surprisingly simple and yet powerful one: values without insert.
sql database db conform option explicit values howto discussion blog development code data select modern
Using SQL WITH clause to create temporary static tables at query time
Saved by uncleflo on March 27th, 2018.
A few days ago, I came across the following problem: I currently work on a project where I am the responsible of an application which generates entries to a log table every time a job is executed. This table contains a lot of information on statuses of jobs, possible problems, exceptions, duration, aso. I was working on some analytics on this data and needed to enrich the data by the version of the software which generated the log entry (since we were not capturing this in the log table). From our configuration management tool, I was able to extract the dates when which versions of the software was deployed in production
data analysis project application analytics static db work development sql clause production howto code
phpMiniAdmin for MySQL
Saved by uncleflo on March 8th, 2018.
phpminiadmin - extremely lightweight alternative to heavy phpMyAdmin for quick and easy access MySQL databases. Instead of installing huge phpMyAdmin (~11Mb) and trying to figure out how to use all it's features, just upload one ~30Kb file and it's ready to use! Then access it via the browser (ex. http://yoursite.com/phpminiadmin.php). Script will ask you for DB login/pwd. After successfull db login you will see area where you able to enter any SQL commands (select, update, insert, etc.). Even if you don't know SQL it's still easy to: browse tables and see all the data, click to un/highlight rows
manage tables in DB, export and import data to .sql and CSV using 'quick links' on the top bar (see screenshots), see what databases you have permission with, check server status and statistics, ability to do CRUD (i.e. insert, select, update, delete), and launch any SQL supported by any version of MySQL. And due to it's simplicity script really fast and need just a little server resources! (your hosting provider will be glad ;)
installation mysql script page fast mini admin administration web website data database db sql browser permission table server developer work
PHP Mini SQL Admin
Saved by uncleflo on February 15th, 2018.
PHP Mini SQL Admin - Lightweight alternative to heavy phpMyAdmin. Extremely small (~30Kb) standalone php script. Easy to Install, simple to use. No SQL knowledge required for basic operations. Features: full MySQL support, extremely small (~30Kb), just in one php file.
php tool mysql interface connect light lightweight alternative small simple operation feature database file easy useful db dbms frontent mini query sql
Comparison of different SQL implementations
Saved by uncleflo on June 7th, 2017.
The goal of this page — which is a work in progress — is to gather information relevant for people who are porting SQL from one product to another and/or are interested in possibilities and limits of 'cross-product' SQL. The following tables compare how different DBMS products handle various SQL (and related) features. If possible, the tables also state how the implementations should do things, according to the SQL standard. I will only write about subjects that I've worked with personally, or subjects which I anticipate to find use for in the near future. Subjects on which there are no significant implementation variances are not covered. Beta-versions of software are not examined. I'm sorry about the colors. They are a result of wanting to mark each DBMS differently and at the same time wanting to be relatively nice to printers.
compare reference list implement sql differ legend dbms read study technical develop administer examine question howto
How to avoid many-to-one problems in SQL
Saved by uncleflo on May 15th, 2017.
It’s been a while since I’ve posted an abstract, theoretical article on a fine point of SQL. Today I want to bring your attention to two ways in which an RDBMS can allow you to do something that has no well-defined result. These involve queries where several values are eligible, but only one is chosen – and chosen in an undefined manner. I’ll show you the two blunders, tell you when they might occur, and explain how to avoid them.
sql blog article problem query database description relation involve eligible many-to-one one-to-many explanation mysql
Managing Hierarchical Data in MySQL
Saved by uncleflo on May 15th, 2017.
Most users at one time or another have dealt with hierarchical data in a SQL database and no doubt learned that the management of hierarchical data is not what a relational database is intended for. The tables of a relational database are not hierarchical (like XML), but are simply a flat list. Hierarchical data has a parent-child relationship that is not naturally represented in a relational database table. For our purposes, hierarchical data is a collection of data where each item has a single parent and zero or more children (with the exception of the root item, which has no parent). Hierarchical data can be found in a variety of database applications, including forum and mailing list threads, business organization charts, content management categories, and product categories.
mysql databases dbms hierarchical tree database blog article question solution category relation purpose parent child sql collection item table lookup technical howto theory explanation list
Start your Fortify on Demand Trial
Saved by uncleflo on December 9th, 2016.
What's included: 15 days to try the Fortify on Demand service at no cost; 2 Assessment units to spend on 2 express scans; 3 types of scans: express mobile, dynamic or static. (sign up using a business email address; dynamic scans won't work with public email domains like Gmail, Yahoo! Mail, etc.); Full scan reports; No contract or credit card required; No downloads or installation;
fortify trial software saas service business scan security helpful administration sql penetration test testing development code check safety hacking prevention tool evidence signup
Centreon Development - How to write a module
Saved by uncleflo on December 9th, 2016.
You want to create a new module for Centreon 2 or to adapt an existing one? You’re at the right place! You should know Centreon contains a page dedicated to the installation and the uninstallation of modules (Administration > Modules). To make the module appears on this page, its directory must be placed inside Cetreon’s modules/ directory.
documentation development nagios module extend howto example structure php db mysql install uninstall functionality feature sql
Crate for Docker
Saved by uncleflo on October 12th, 2016.
Crate is an open source, highly scalable, shared-nothing distributed SQL database. Crate offers the scalability and performance of a modern No-SQL database with the power of Standard SQL. Crate’s distributed SQL query engine lets you use the same syntax that already exists in your applications or integrations, and have queries seamlessly executed across the crate cluster, including any aggregations, if needed. Crate is masterless and simple to install, operate and use. It handles transactional and analytical needs in one single database. Crate has been designed from the ground up to support the huge scale of Web, mobile and IoT applications. Love containers? Crate runs perfectly as stateful container.
crate distributed rdbms high-availability partition data dbms rdbms availability performance upscale scalability sql transaction storage engine website administration server software solution product opensource
How to Use Unique Indexes in MySQL and Other Databases - SitePoint
Saved by uncleflo on April 4th, 2015.
If you’ve been using databases for a while, you’ve probably set a primary key in most of your tables. A primary key is a unique identifier for each record. In this example, the ‘id’ column is our primary key. When we INSERT telephone numbers, if we don’t specify an id, an AUTO_INCREMENT number will be generated by adding one to the highest existing id.
mysql database development sql tutorial programming unique guide howto blog article description index search filter reference lookup
mysql - Find highest level of a hierarchical field: with vs without CTEs - Database Administrators
Saved by uncleflo on March 26th, 2015.
I have a self-referencing table with a primary key, id and a foreign key parent_id. Given a name, how can I query the top-level parent? Given a name, how can I query all of the id's associated with a record of name = 'foo'?
mysql hierarchical reference table record parent tree sql primary key database development howto solution question
Hierarchical data in MySQL: easy and fast
Saved by uncleflo on March 26th, 2015.
Storing hierarchical data in a relational database is a classic problem. Relational databases are not really designed for this purpose, because they store data in flat rows. Storage is actually the least of our problems. Imagine a commenting system with an unlimited level of nesting in replies.
hierarchical data mysql fast easy sql purpose system problem tree build construct development database howto
MySQL :: MySQL 5.5 Reference Manual :: 11.9 Full-Text Search Functions
Saved by uncleflo on February 22nd, 2015.
MySQL has support for full-text indexing and searching. Full-text searching is performed using MATCH() ... AGAINST syntax. MATCH() takes a comma-separated list that names the columns to be searched. AGAINST takes a string to search for, and an optional modifier that indicates what type of search to perform. The search string must be a string value that is constant during query evaluation. This rules out, for example, a table column because that can differ for each row.
mysql search index fulltext database engine howto administration development function reference manual type collation performed query expand sql
Alexander Stetsenko » MySQL: how to ignore checking of foreign key constraints for InnoDB tables
Saved by uncleflo on February 16th, 2015.
There is a session variable FOREIGN_KEY_CHECKS which allows to ignore checking of foreign key constraints for InnoDB tables. If set to 1 (the default), foreign constraints are checked. If set to 0, they are ignored. Setting FOREIGN_KEY_CHECKS to 0 also affects data definition statements like DROP TABLE which drops tables that have foreign keys that are referred to by other tables. Disabling foreign key checking can be useful for reloading InnoDB tables in an order different from that required by their parent/child relationships.
mysql insert foreign ignore key constraint check sql dump import database solution problem drop flag
Regex Tutorial - Unicode Characters and Properties
Saved by uncleflo on January 20th, 2015.
Unicode is a character set that aims to define all characters and glyphs from all human languages, living and dead. With more and more software being required to support multiple languages, or even just any language, Unicode has been strongly gaining popularity in recent years. Using different character sets for different languages is simply too cumbersome for programmers and users.
unicode regex regexp characters php mysql sql database encoding encode character language software require pitfall escape property engine flavor requirement tutorial create information
Import CSV file directly into MySQL | a Tech-Recipes Tutorial
Saved by uncleflo on January 24th, 2014.
Instead of writing a script to pull in information from a CSV file, you can link MYSQL directly to it and upload the information using the following SQL syntax. To import an Excel file into MySQL, first export it as a CSV file. Remove the CSV headers from the generated CSV file along with empty data that Excel may have put at the end of the CSV file.
sql mysql insert csv local file development administration import command run table populate guide howto solution
php - How to 'insert if not exists' in MySQL? - Stack Overflow
Saved by uncleflo on January 24th, 2014.
I started by googling, and found this article which talks about mutex tables. I have a table with ~14 million records. If I want to add more data in the same format, is there a way to ensure the record I want to insert does not already exist without using a pair of queries (ie, one query to check and one to insert is the result set is empty)? Does a unique constraint on a field guarantee the insert will fail if it's already there? It seems that with merely a constraint, when I issue the insert via php, the script croaks.
exist insert mysql php sql script javascript ignore development solution question query duplicate
