SQL Joins Diagram
For those who love SQL :-)Source: Data Visualisation
$
grep -r "#db" ./posts
Tag
#db
// 8 matches
MySQL innodb_buffer_pool_size optimal value
innodb_buffer_pool_size is a quite important MySQL configuration parameter which can dramatically increase your DB productivity. The larger you set this value, the less disk I/O is needed to access...
Find duplicate records in MySQL
So, the task is to get duplicate records from a MySQL database. The easy way: SELECT COUNT(*), column1, column2 FROM tablename GROUP BY column1, column2 HAVING COUNT(*)>1; More complex case: shows...
Mac OS, MySQL: No such file or directory (trying to connect via unix:///
Error on attempt to connect locally to MySQL server DB with PHP on MacOS X Lion 10.7: No such file or directory (trying to connect via unix:///var/mysql/mysql.sock) Solution 1: instead of localhost...
MySQL: ERROR 2006 (HY000) at line: ### MySQL server has gone away
In case of MySQL error 2006 (HY000) at line: ### MySQL server has gone away which may occur while restoring a big DB dump just add (or increase, if exists) max_allowed_packet parameter of MySQL...
Mac OS X - MySQL Workbench - Error Opening Configuration File my.cnf
By default, the OS X installation does not use a my.cnf, and MySQL just uses the default values. To set up your own my.cnf, you could just create a file straight in /etc, or do the following (excuse...
How to get the Next Auto Increment number in MySQL
In order to get the next Auto Increment number in MySQL just run: SHOW TABLE STATUS LIKE '$tablename'; The result would be in `Auto_Increment`. Voila !
MySQL Frequently Used Commands
Selecting a database: mysql> USE database; Listing databases: mysql> SHOW DATABASES; Listing tables in a db: mysql> SHOW TABLES; Describing the format of a table: mysql> DESCRIBE table; Creating a...