【MySQL】使用概要

INSERT INTO "tableName( 1, 2,...)" VALUES( 1, 2,...)
/* 1,         。
   2，     ，                   。
*/

DELETE FROM "tableName" WHERE "condition1" AND "condition2" ...
/*                where     。 */

UPDATE "tableName" SET "key = value" WHERE "condition1" AND "condition2" ... 
/*   where     ，             。*/

SELECT "fields" FROM "tableName" WHERE "condition" 
/*     ，                。where  (fields)    。 */

SELECT "fields" FROM "table1, table2,..." WHERE "condition1" AND "condition2" ... 
/*     ，                    。*/

CREATE DATABASE "databaseName" /*       */

DROP DATABASE "databaseName" /*       */

CREATE TABLE table_name (columnName columnType) /*      ，column_type        */

DROP TABLE "tableName" /*       */

ALTER TABLE "tableName" RENAME TO "newTableName"  /*      */

ALTER TABLE "tableName" DROP "columnName" /*          */

ALTER TABLE "tableName" ADD "columnName columnType" FIRST/[AFTER "columnName"] 
/*                        */

ALTER TABLE "tableName" MODIFY "columnName" "newColumnType" /*               */

ALTER TABLE "tableName" CHANGE "columnName" "columnName newColumnType" 
/*                       ，           */

ALTER TABLE "tableName" RENAME TO "newTableName"  /*      */

GRANT "power" ON "databaseName" TO "user" /*    user     databaseName     power*/
REVOKE "power" ON "databaseName" FROM "user" /*     user    databaseName    power */
FLUSH PRIVILEGES /*     MySQL               */

GROUP BY "columnName" /*                */
ORDER BY "columnName"  ASC/DESC /*               ，  ASC，  DESC */
SUM("columnName") /*           */
COUNT("columnName") /*           */
AVG("columnName") /*               */
.......................