CREATE DATABASE LONGXI DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
USE LONGXI;
CREATE TABLE USERINFO
(ID INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
NAME VARCHAR(30), SEX VARCHAR(2),
ADDRESS VARCHAR(500));
CREATE DATABASE LONGXI DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
USE LONGXI;
CREATE TABLE USERINFO
(ID INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
NAME VARCHAR(30), SEX VARCHAR(2),
ADDRESS VARCHAR(500));