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...