数据库增删改查的基本指令

1个回答

呼噜123

2026-01-05 23:51

1. 增加数据：sqlINSERT INTO table_name (column1, column2, column3)VALUES (value1, value2, value3);2. 删除数据：sqlDELETE FROM table_nameWHERE condition;3. 更新数据：sqlUPDATE table_nameSET column1 = value1, column2 = value2, ...WHERE condition;4. 查询数据：sqlSELECT column1, column2, ...FROM table_name;5. 分页查询：sqlSELECT * FROM table_name LIMIT start, end;6. 批量查询：sqlSELECT * FROM table_name WHERE condition1 AND condition2 AND condition3;7. 唯一约束：sqlALTER TABLE table_name ADD CONSTRAINT constrAInt_name UNIQUE column_name;8. 外键约束：sqlALTER TABLE table_name ADD CONSTRAINT constrAInt_name FOREIGN KEY (column_name)REFERENCES other_table (other_column);9. 主键约束：sqlALTER TABLE table_name ADD CONSTRAINT constrAInt_name PRIMARY KEY (column1, column2, column3);10. 索引创建：sqlCREATE INDEX index_name ON table_name (column1);

举报有用（0）分享收藏

数据库增删改查的基本指令

1个回答

呼噜123

热门话题

相关问题