SQL更新插入语句

最新推荐文章于 2024-08-01 09:46:22 发布

GeekLeee

最新推荐文章于 2024-08-01 09:46:22 发布

阅读量721

点赞数 1

分类专栏：数据库

本文链接：https://blog.csdn.net/GeekLeee/article/details/75335561

版权

数据库专栏收录该内容

16 篇文章 0 订阅

订阅专栏

REPLACE INTO {table_name} {colomns} VALUES ({x})
INSERT INTO {table_name} {colomns} VALUES ({x})
INSERT IGNORE INTO {table_name} {colomns} VALUES ({x})

实例

INSERT INTO Persons (LastName, Address) VALUES (‘Wilson’, ‘Champs-Elysees’)

更新某一行中的一个列

UPDATE Person SET FirstName = ‘Fred’ WHERE LastName = ‘Wilson’

更新某一行中的若干列

UPDATE Person SET Address = ‘Zhongshan 23’, City = ‘Nanjing’
WHERE LastName = ‘Wilson’

INSERT INTO table1 ( column1 )
SELECT  col1
FROM    table2

INSERT INTO table1 ( column1, column2, someInt, someVarChar )
SELECT  table2.column1, table2.column2, 8, 'some string etc.'
FROM    table2
WHERE   table2.ID = 7;