Mysql cheat sheet

MySQL cheatsheets

MySQL cheatsheet, in pdf format :)
 -> https://buggyprogrammer.com/mysql-cheatsheet-pdf/

Source: buggyprogrammer.com

Mysql cheat sheet

SELECT * FROM table;
SELECT * FROM table1, table2;
SELECT field1, field2 FROM table1, table2;
SELECT ... FROM ... WHERE condition
SELECT ... FROM ... WHERE condition GROUPBY field;
SELECT ... FROM ... WHERE condition GROUPBY field HAVING condition2;
SELECT ... FROM ... WHERE condition ORDER BY field1, field2;
SELECT ... FROM ... WHERE condition ORDER BY field1, field2 DESC;
SELECT ... FROM ... WHERE condition LIMIT 10;
SELECT DISTINCT field1 FROM ...
SELECT DISTINCT field1, field2 FROM ...

Source: devhints.io

Cheat seet traversy

INSERT INTO users (first_name, last_name, email, password, location, dept,  is_admin, register_date) values ('Fred', 'Smith', 'fred@gmail.com', '123456', 'New York', 'design', 0, now()), ('Sara', 'Watson', 'sara@gmail.com', '123456', 'New York', 'design', 0, now()),('Will', 'Jackson', 'will@yahoo.com', '123456', 'Rhode Island', 'development', 1, now()),('Paula', 'Johnson', 'paula@yahoo.com', '123456', 'Massachusetts', 'sales', 0, now()),('Tom', 'Spears', 'tom@yahoo.com', '123456', 'Massachusetts', 'sales', 0, now());

Source: gist.github.com

Similar codes

0 vote322 views1 answer
Mysqli_real_connect(): (28000/1045): Access denied for user 'u0738423'@'www8.aname.net' (using password: YES)
SQL
0 vote331 views1 answer
I wanted to select among the rows the highest value in mysql
SQL
0 vote343 views1 answer
Top frequency in sql server
SQL
0 vote367 views1 answer
Disable database droping sql
SQL
18 votes303 views6 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
SQL
0 vote356 views1 answer
Convert LDAP Epoch to Date
SQL
4 votes314 views1 answer
Oracle change nls_date_format permanently
SQL
6 votes370 views3 answers
Create database mysql utf8
SQL
0 vote346 views1 answer
Excel vba import data to sql server
SQL
1 vote298 views1 answer
Mysql get last insert id
SQL