Skip to content

CURD增删改查常用SQL语句

SELECT * FROM [table] WHERE [condition] ORDER BY [field] DESC LIMIT [from], [to]

INSERT INTO [table] (field1, field2) VALUES (value1, value2)

// MySQL 专属
INSERT INTO [table] SET field1 = value1, field2 = value2

UPDATE [table1],[table2] SET  table1.field1 = value1, table2.field2 = value2 WHERE [condition]

DELETE FROM [table] WHERE [condition]

领支付宝红包:打开支付宝搜索 726845401

领饿了么红包:0fυィ直文本 e:/$XGzEgR8$~.👉饿了么App👈【快來領外賣紅包,最高20元,人人都有哦~】

 

您的赞助将会鼓励作者技术文章创作以及支持本站运维。

{ 1 } Comments

  1. 11 | 2021-03-24 at 11:52 | Permalink

    搜不到啊

发表评论

Your email is never published nor shared. Required fields are marked *


TOP