SQL Joins Diagram
For those who love SQL :-)Source: Data Visualisation
$
grep -r "#sql" ./posts
Tag
#sql
// 4 matches
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...
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...