1. Insert into
i. Insert all
Insert into t_book value(null, '王者归来', '95','李四','2');
Insert into t_book(id, bookName, price, author, bookTypeId) value(null, '王者归来', '95','李四','2');
ii. Not insert all
Insert into t_book(id, bookName, author) value(null, '王者归来', '李四');
iii. Multi insert
Insert into t_book(id, bookName, price, author, bookTypeId) values (null, '王者归来', '95','李四','2'), (null, '王者归来2', '95','李四','2'), (null, '王者归来3', '95','李四','2');
2. Update
i.
update t_book set bookName='Java编程思想2', price=120 where id=1;
ii.
update t_book set bookName='王者' where bookName like '%王者归来%';
3. Delete
Delete from t_book where id=10;
Delete from t_book where bookName='王者';