CREATE DATABASE IF NOT EXISTS info DEFAULT CHARSET utf8;
USE info;
#创建表
CREATE TABLE IF NOT EXISTS emp(emp_id INT PRIMARY KEY AUTO_INCREMENT,
emp_name VARCHAR(20),
salary INT,
dept_id INT,
manager_id INT
);
#1.创建索引,单独创建索引
SELECT * FROM emp WHERE emp_name = "父";
#2.创建索引,修改表结构创建索引
CREATE INDEX index_name ON emp(emp_name);
SELECT * FROM emp WHERE emp_name = "父";
#3.创建索引:创建表时,创建索引
CREATE TABLE IF NOT EXISTS article(id INT NOT NULL AUTO_INCREMENT,
title VARCHAR(30),
content VARCHAR(50),
dt DATE,
PRIMARY KEY(id),
INDEX index_title (title)
);
#删除索引
DROP index_name ON emp;
#唯一索引
CREATE UNIQUE INDEX index_name ON emp(emp_name);