sql基础语句
时间:2014-11-18 08:26来源:www.sqlserver.net.cn 作者:admin 点击:
次
INSERT，SELECT，UPDATE和DELETE 插入 INSERT INTO table1 VALUES (abc,cd,1980-06-10, beijing,16,10000); 查找 SELECT columns FROM tables; 修改 UPDATE table2 SET dizhi = shanghai WHERE xingming = xiaozhang; 删除 DELETE FROM table1 WHE
|
INSERT，SELECT，UPDATE和DELETE
插入
INSERT INTO table1 VALUES
('abc','cd','1980-06-10',
'beijing',16,10000);
查找
SELECT columns FROM tables;
修改
UPDATE table2
SET dizhi = 'shanghai'
WHERE xingming = 'xiaozhang';
删除
DELETE FROM table1
WHERE xingming = 'xiaobai';
大概就是这样。具体 ，还会有一些查询的条件，比如 % > = < 这些查询条件
(责任编辑：admin)
|
------分隔线----------------------------
