MySql的CRUD(增、删、改、查)操作和SQL Server的差不多。
----------------------------------------------------------------------------------------------------------------
需要的注意的是delete的语法:
delete tbCategory where categoryName='QQ' //错误的写法,少了一个from
delete from tbCategory where categoryName='QQ' //正确的写法,from不能少
------------------------------------------------------------------------------------------------------------------
插入语句如下:
insert into tbCategory (categoryName) values ('Test') //categoryName是列名
----------------------------------------------------------------------------------------------------------------
select更简单了:
select * from tbUser
-----------------------------------------------------------------------------------------------------------------
更新语句:
update tbCategory set categoryName='QQ' where categoryId=2
-------------------------------------------------------------------------------------------------------------------
您的十分满意是我追求的宗旨。
您的一点建议是我后续的动力。