· 9 years ago · Nov 06, 2016, 02:54 PM
1# CREATE DATABASE IF NOT EXISTS `class` DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
2# USE `class`;
3CREATE TABLE student(
4 `id` INT UNSIGNED AUTO_INCREMENT key,
5 `username` VARCHAR(20) NOT NULL UNIQUE,
6 `email` VARCHAR(50) NOT NULL
7);
8INSERT INTO student(username,email) VALUE ("bobby","email@qq.com");