《MySQL必知必会》读书笔记

1. 新建数据库

CREATE DATABASE dbname;

2. 新建表

CREATE TABLE t_table
(
 id INT NOT NULL AUTO_INCREMENT,
 name CHAR(20) NOT NULL,
 password CHAR(20) NOT NULL,
 PRIMARY KEY (id)
) ENGINE=InnoDB

3. 插入数据

INSERT INTO t_table(name, password)
VALUES ("hello", "123456");

4. 更新数据

UPDATE t_table
SET password="1008611"
WHERE id = 0;

5. 删除数据

DELETE FROM t_table
WHERE id > 10;

6. 查找数据

SELECT * FROM t_table WHERE id = 0;