create database test1 default character set utf8 collate utf8_general_ci;
use test1;
use mysql;
--查询表结构
show columns from user;
-增加字段
alter table user add column username int not null default 0 after Host;
--删除非空约束
alter table user modify username varchar(100) null;
--已建表,未建字段
alter table user add id int auto_increment primary key;
--已建表,已建字段
alter table user change id newid int auto_increment primary key;
use test1;
use mysql;
--查询表结构
show columns from user;
-增加字段
alter table user add column username int not null default 0 after Host;
--删除非空约束
alter table user modify username varchar(100) null;
--已建表,未建字段
alter table user add id int auto_increment primary key;
--已建表,已建字段
alter table user change id newid int auto_increment primary key;