테이블 생성테이블생성시 인덱스 없을경우CREATE TABLE 'table_name' ( 'var_a' int(10) NOT NULL AUTO_INCREMENT, 'var_b' char(100) NOT NULL, 'var_c' char(100) NOT NULL, 'var_d' char(100) NOT NULL, 'var_e' char(100) NOT NULL, 'var_f' char(100) NOT NULL, PRIMARY KEY ('var_a')) ENGINE=InnoDB AUTO_INCREMENT=131071 DEFAULT CHARSET=UTF-8테이블생성시 인덱스가 있을경우CREATE TABLE 'table_name' ( 'var_a' int(10) NOT NULL AUTO_INCREMENT, 'var_b' char(100) NOT NULL, 'var_c'..........
원문 링크 : mysql / mariaDB DDL
