1.update tablename set name='吴海波' where name'吴波'。
2.delete 会员信息 where year='1988'
3.use WebShop
select c_ID,c_Name,c_TrueName,c_Password from Customers
4.select c_ID,c_Name,c_TrueName，c_Age,c_Password from Customers
5.select * from table_VIP where VIP. 用户级别=VIP
6.select * from 会员表 where meil like '%@163.com'
7.select c_ID,c_Name,c_Gender，c_Birth,c_Address from Customers c where c_Name like '刘%'
8.select * from Customers order by c_Type asc, age desc
内容全部来源于网络收集，如有侵权，请联系网站删除！