SQL操作指令(Sql Server)

最新推荐文章于 2024-01-18 10:01:03 发布

weixin_34128411

最新推荐文章于 2024-01-18 10:01:03 发布

阅读量129

点赞数

文章标签：数据库 python

原文链接：https://my.oschina.net/u/3796489/blog/2218542

版权

2019独角兽企业重金招聘Python工程师标准>>>

/****** 增 ******/
INSERT INTO [DataBaseTest].[dbo].[Table_3] (id, name, url, alexa, country)
VALUES ('100', '百度','https://www.baidu.com/','5555','CNCNCN');

/****** 删 ******/
DELETE FROM [DataBaseTest].[dbo].[Table_3]
WHERE name='百度' AND alexa='10';

/****** 查 ******/
SELECT *
FROM [DataBaseTest].[dbo].[Table_3]

SELECT TOP 2 id
,name
FROM [DataBaseTest].[dbo].[Table_3]

SELECT *
FROM [DataBaseTest].[dbo].[Table_3]
WHERE country collate Chinese_PRC_CS_AS_WS='cn';

SELECT * FROM [DataBaseTest].[dbo].[Table_3]
WHERE id > 1
AND (name='淘宝' OR name='菜鸟')
ORDER BY id asc;

SELECT * FROM [DataBaseTest].[dbo].[Table_3]
WHERE id > 1
AND (name='淘宝' OR name='菜鸟' OR name='百度')
ORDER BY id desc;

/****** 改 ******/
UPDATE [DataBaseTest].[dbo].[Table_3]
SET alexa='12345', country='USA123'
WHERE name='菜鸟';

转载于:https://my.oschina.net/u/3796489/blog/2218542