mysql常学命令

jdbc:mysql://192.168.200.11:3306/mydb02?useUnicode=true&characterEncoding=UTF-8

创建数据连接并默认编码格式

create table pro(id int primary key auto_increment, fName varchar(25), price int, area varchar(25), cinema varchar(25) not null) default charset = utf8;

创建数据库表 id自动增长

create table t1(id primary key auto_increate, name varchar(19), gender varchar(9), age int);

CREATE DATABASE `db_project` DEFAULT CHARACTER SET utf8;