--创建表Employee
--创建表之前先判断表是否存在,如果存在则删除
id integer primary key auto_increment not null,
employeeCode varchar(20) character set utf8 collate utf8_bin not null,
employeeName varchar(50) character set utf8 collate utf8_bin not null
) collate=utf8_unicode_ci;
--创建表之前先判断表是否存在,如果存在则删除
drop table if exists webstudy.Employee;
--表不存在则创建表(设置id自增长并未主键)
create table if not exists webstudy.Employee(id integer primary key auto_increment not null,
employeeCode varchar(20) character set utf8 collate utf8_bin not null,
employeeName varchar(50) character set utf8 collate utf8_bin not null
) collate=utf8_unicode_ci;