CREATE DATABASE [数据库名];
DROP DATABASE [数据库名];
SHOW DATABASES;
USE [数据库名];
CREATE TABLE [表名] ([字段名] [字段类型] [约束]);
DROP TABLE [表名];
ALTER TABLE [表名] [变更内容];
INSERT INTO [表名] ([字段名]) VALUES (值);
UPDATE [表名] SET [字段名] = 值 WHERE [条件];
DELETE FROM [表名] WHERE [条件];
SELECT [字段] FROM [表名] [WHERE 条件];
DESCRIBE [表名];
SHOW TABLES;
上一篇:sql随机查询50条数据
下一篇:mysql命令教学