mysql的笔记

创建表：

CREATE TABLE IF NOT EXISTS 'student'（
 ‘id’ INT UNSIGNED AUTO_INCREMENT,
 'title' VARCHAR(100) NOT NULL,
 'author' VARCHAR(40) NOT NULL,
 'date'  DATE,
  PRIMARY KEY('id')

）ENGINE = InnoDB DEFAULT CHARSET = utf8;

删除数据库

DROP TABLE  tableName

插入数据

INSERT INTO tableName(field1, field2.....fieldN)
VALUES

(value1, value2, ....valueN);

查询

SELECT column_name,column_name
FROM table_name
[WHERE Clause]

[LIMIT N][ OFFSET M]

WHERE 子句

SELECT field1, field2,...fieldN FROM table_name1, table_name2...

[WHERE condition1 [AND [OR]] condition2.....

UPDATE 查询
UPDATE table_name SET field1=new-value1, field2=new-value2
[WHERE Clause]

LIKE 类似的可以用=
SELECT field1, field2,...fieldN 
FROM table_name

WHERE field1 LIKE condition1 [AND [OR]] filed2 = 'somevalue'