【A】常见的MySQL命令有很多,以下是10个常用的命令及其代码示例:
-
创建数据库:
CREATE DATABASE database_name;
-
创建数据表:
CREATE TABLE table_name ( column1 datatype, column2 datatype, ... );
-
插入数据:
INSERT INTO table_name (column1, column2, ...) VALUES (value1, value2, ...);
-
更新数据:
UPDATE table_name SET column1 = value1, column2 = value2, ... WHERE condition;
-
删除数据:
DELETE FROM table_name WHERE condition;
-
查询数据:
SELECT column1, column2, ... FROM table_name WHERE condition;
-
查询表结构:
DESCRIBE table_name;
-
添加索引:
ALTER TABLE table_name ADD INDEX index_name (column1, column2, ...);
-
删除索引:
ALTER TABLE table_name DROP INDEX index_name;
-
导入数据:
LOAD DATA INFILE 'file_name'
INTO TABLE table_name
FIELDS TERMINATED BY ',' ENCLOSED BY '"'
LINES TERMINATED BY '\n'
(column1, column2, ...);
请注意,在上述代码示例中,请将 database_name
、table_name
、column1
、column2
等替换为具体的数据库、表和列名。