SELECT field1, field2 FROM table1, table2;

SELECT ... FROM ... WHERE condition GROUP BY field;

SELECT ... FROM ... WHERE condition GROUP BY 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 ... FROM t1 JOIN t2 ON t1.id1 = t2.id2 WHERE condition;

SELECT ... FROM t1 LEFT JOIN t2 ON t1.id1 = t2.id2 WHERE condition;

SELECT ... FROM t1 JOIN (t2 JOIN t3 ON ...) ON ...

CREATE DATABASE DatabaseName CHARACTER SET utf8;

ALTER DATABASE DatabaseName CHARACTER SET utf8;

mysqldump -u Username -p dbNameYouWant > databasename_backup.sql

mysql - u Username -p dbNameYouWant < databasename_backup.sql;

INSERT INTO table1 (field1, field2) VALUES (value1, value2);

DELETE FROM table1, table2 FROM table1, table2 WHERE table1.id1 =

UPDATE table1 SET field1=new_value1 WHERE condition;

UPDATE table1, table2 SET field1=new_value1, field2=new_value2, ... WHERE

CREATE TABLE table (field1 type1, field2 type2);

CREATE TABLE table (field1 type1, field2 type2, INDEX (field));

CREATE TABLE table (field1 type1, field2 type2, PRIMARY KEY (field1));

CREATE TABLE table (field1 type1, field2 type2, PRIMARY KEY (field1,field2));

CREATE TABLE table1 (fk_field1 type1, field2 type2, ...,

  FOREIGN KEY (fk_field1) REFERENCES table2 (t2_fieldA))

    [ON UPDATE|ON DELETE] [CASCADE|SET NULL]

CREATE TABLE table1 (fk_field1 type1, fk_field2 type2, ...,

 FOREIGN KEY (fk_field1, fk_field2) REFERENCES table2 (t2_fieldA, t2_fieldB))

ALTER TABLE table MODIFY field1 type1 NOT NULL ...

ALTER TABLE table CHANGE old_name_field1 new_name_field1 type1

ALTER TABLE table CHANGE old_name_field1 new_name_field1 type1 NOT NULL ...

ALTER TABLE table ALTER field1 SET DEFAULT ...

ALTER TABLE table ALTER field1 DROP DEFAULT

ALTER TABLE table ADD new_name_field1 type1

ALTER TABLE table ADD new_name_field1 type1 FIRST

ALTER TABLE table ADD new_name_field1 type1 AFTER another_field

ALTER TABLE table MODIFY field1 type1 FIRST

ALTER TABLE table MODIFY field1 type1 AFTER another_field

ALTER TABLE table CHANGE old_name_field1 new_name_field1 type1 FIRST

ALTER TABLE table CHANGE old_name_field1 new_name_field1 type1 AFTER

CREATE TABLE table (..., PRIMARY KEY (field1, field2))

CREATE TABLE table (..., FOREIGN KEY (field1, field2) REFERENCES table2

GRANT ALL PRIVILEGES ON base.* TO 'user'@'localhost' IDENTIFIED BY 'password';

GRANT SELECT, INSERT, DELETE ON base.* TO 'user'@'localhost' IDENTIFIED BY 'password';

In this blog, we know about MySQL Cheat Sheets.

mysqlcheatsheet

Trending Blogposts on mysqlcheatsheet

MySQL Cheat Sheet

Popular Discussions on mysqlcheatsheet

PRODUCTS

QUICK LINKS

LEGAL

mysqlcheatsheet

Trending Blogposts on mysqlcheatsheet

MySQL Cheat Sheet

Popular Discussions on mysqlcheatsheet