sql基础

sql

1、查询
SELECT
dbo.OrderMoney.Num AS [单号],
dbo.OrderMoney.Money AS [金额]
FROM
dbo.OrderMoney

2、更新
update OrderMoney set
Money =Money+5 //Money全部+5

3、删除
delete +表名 （表内数据没了，但表主键依旧存在）

truncate table +表名（表内数据清除，主键重新开始）

4、in、and、 between and 、or
delete goods.name from gooods where g_id in (3,13)