以下是一些常见的SQL数据库操作的代码示例:
创建数据库
CREATE DATABASE database_name;
删除数据库
DROP DATABASE database_name;
创建表
CREATE TABLE table_name ( column1 datatype, column2 datatype, column3 datatype, ... );
删除表
DROP TABLE table_name;
修改表结构(添加列)
ALTER TABLE table_name ADD column_name datatype;
修改表结构(修改列)
ALTER TABLE table_name ALTER COLUMN column_name datatype;
修改表结构(删除列)
ALTER TABLE table_name DROP COLUMN column_name;
插入数据
INSERT INTO table_name (column1, column2, column3, ...) VALUES (value1, value2, value3, ...);
更新数据
UPDATE table_name SET column1 = value1, column2 = value2, ... WHERE condition;
删除数据
DELETE FROM table_name WHERE condition;
查询数据
SELECT column1, column2, ... FROM table_name WHERE condition;
查询排序
SELECT column1, column2, ... FROM table_name ORDER BY column_name ASC/DESC;