alter table information add column English char(6);
update table
update information set English=’89’ where no=0001;
insert into
MySQL [mydb]> insert into employee values -> (‘李天乐’,’93453′,’34’,’中科院信息技术研究所’); Query OK, 1 row affected (0.090 sec)
create database or table
MySQL [(none)]> create database mydb; Query OK, 1 row affected (0.093 sec) MySQL [(none)]> use mydb; Database changed MySQL [mydb]> create table employee; ERROR 1113 (42000): A table must have at least 1 column MySQL [mydb]> create table employee\ (name varchar(20) not null, number varchar(10),\ age char(5), department varchar(50)); Query OK, 0 rows affected (0.094… Continue reading create database or table