· 8 years ago · Aug 28, 2018, 03:00 PM
1SET NAMES 'utf8';
2CREATE DATABASE IF NOT EXISTS leftj DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
3USE leftj;
4DROP TABLE IF EXISTS test1;
5CREATE TABLE test1 (
6 id mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
7 name varchar(255) NOT NULL,
8 PRIMARY KEY(id)
9) ENGINE = MYISAM DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;