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]

您的赞助将会支持作者创作及本站运维

评论

共1条
  1. 11 2021-03-24 11:52

    搜不到啊

发表评论


TOP