mysql_10_插入_更新和删除数据

use db_book;
#第六章 插入，更新和删除数据
#第一节:插入数据
#1.给表的所有字段插入数据
#格式:INSERT INTO 表名 VALUES(值1,值2,值3,...,值n);
SELECT * FROM t_book;
INSERT INTO t_book VALUES(NULL,"第一行代码",79,"郭霖",1);
SELECT * FROM t_book;

#2.给表的指定字段插入数据
#格式:INSERT INTO 表名(属性1,属性2,属性3,...,属性n) VALUES(值1,值2,值3,...,值n);
INSERT INTO t_book(bookName) VALUES("第二行代码");

#3.同时插入多条记录
#格式:
#INSERT INTO 表名 [(属性列表)]
#    VALUES (取值列表1)，(取值列表2)
#    ...,
#    (取值列表n);
INSERT INTO t_book(id,bookName,price,author,bookTypeId) VALUES
(NULL,"高质量编程",45,"哈哈",1),
(NULL,"数学",79,"嘿嘿",1),
(NULL,"语文",79,"呵呵",1),
(NULL,"Android",79,"吼吼",1);

SELECT * FROM t_book;

#第二节:更新数据
#格式:
#UPDATE 表名 
#    SET 属性名1=取值1，属性名2=取值2，
#    ...,
#    属性名n=取值n，
#    WHERE 条件表达式；
UPDATE t_book SET price=120 WHERE bookName="Java编程思想";

SELECT * FROM t_book;

#第三节:删除数据
#格式:
#DELETE FROM 表名 [WHERE 条件表达式]
DELETE FROM t_book WHERE id=6;
SELECT * FROM t_book;

DELETE FROM t_book WHERE id > 5;
SELECT * FROM t_book;