wordpress能做什么网站,vivo官方网站进入,销售平台,网络平台运营是做什么的1.查看数据库编2.查看数据表的编码格式3.创建数据库时指定数据库的字符集mysqlcreate database character set utf8;4.创建数据表时指定数据表的编码格式create table tb_books (name varchar(45) not null,price double not null,bookCount int not null,author varchar(4…1.查看数据库编2.查看数据表的编码格式3.创建数据库时指定数据库的字符集mysqlcreate database character set utf8;4.创建数据表时指定数据表的编码格式create table tb_books (name varchar(45) not null,price double not null,bookCount int not null,author varchar(45) not null ) default charset utf8;5.修改数据库的编码格式mysqlalter database character set utf8;6.修改数据表格编码格式mysqlalter table character set utf8;7.修改字段编码格式mysqlalter table change character set utf8;mysqlalter table user change username username varchar(20) character set utf8 not null;8.添加外键mysqlalter table tb_product add constraint fk_1 foreign key(factoryid) references tb_factory(factoryid);mysqlalter table add constraint foreign key REFERENCES ;9.删除外键mysqlalter table tb_people drop foreign key fk_1;mysqlalter table drop foreign key ;
