[Practice] 인덱스, 변수
1. 인덱스 1) 테이블 생성 DROP DATABASE IF EXISTS sqlpractice; CREATE DATABASE sqlpractice; USE sqlpractice; DROP TABLE IF EXISTS member; CREATE TABLE member ( no INT NOT NULL AUTO_INCREMENT, id VARCHAR(32) NOT NULL, name CHAR(20) NOT NULL, sex ENUM('남','여'), post_num CHAR(8), address TEXT, tel CHAR(16), age TINYINT UNSIGNED, PRIMARY KEY (no), UNIQUE KEY (id), KEY (name), KEY (name, age), FULLTEXT KEY (a..
2020.09.30