MySQL 初级命令

CREATE DATABASE 数据库名;

CREATE TABLE IF NOT EXISTS 表名(
  字段名 列定义,
  字段名 列定义
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

SHOW DATABASES;

SHOW TABLES;

SHOW TABLES FROM 数据库名;

SHOW COLUMNS FROM 表名;

CREATE TABLE 表名(
  pid 定义,
  FOREIGN KEY (pid) REFERENCES 父表 (字段) [参照操作];
);

USE mysql;
DELETE FROM user WHERE user='admin' and host='%';

character-set-server = utf8mb4

SHOW VARIABLES LIKE 'character%';

SELECT VERSION();

SELECT DATABASE();

SELECT USER();

SHOW STATUS;         # 服务器状态

SHOW VARIABLES;      # 服务器配置变量

default-storage-engine = engine