mysql(六、 插入，更新和删除資料)

INSERT INTO t_book VALUES(NULL,'我愛我家',20,'張三',1);



 INSERT INTO t_book(id,bookName,price,author,bookTypeId) VALUES(NULL,'我愛我家',20,'張三',1);



 INSERT INTO t_book(bookName,author) VALUES('我愛我家','張三');
INSERT INTO t_book(id,bookName,price,author,bookTypeId) VALUES (NULL,'我愛我家2',20,'張三',1),(NULL,'我愛我家3',20,'張三',1);

UPDATE t_book SET bookName='Java程式設計思想',price=120 WHERE id=1;


 UPDATE t_book SET bookName='我' WHERE bookName LIKE '%我愛我家%';
DELETE FROM t_book WHERE id=5;


 DELETE FROM t_book WHERE bookName='我';