转载自 https://blog.csdn.net/gaoweizang/article/details/52859484
插入操作
插入一条记录:insert into t_book values(null,'我爱我家',20,'张三',1);
插入指定字段:insert into t_book(bookName,author) values('我爱我家','张三');
插入多个值:insert into t_book(bookName,author) values('我爱我家','张三'),('我家','李四');
更新操作
更新一条数据:update t_book set bookName='java编程思想',price=120 where id=1;
更新几条数据: update t_book set bookName where bookName like '%我爱我家%';
删除操作
删除一条数据:delete t_book where id=5;
删除多条数据:delete t_book where bookName='我';