1.连接:mysql -u root -p
2.create database test_a;
3.use test_a;
4.create table test1
(
name varchar(15),
email varchar(50),
id int not null into_increment,
primary(id));
5.insert into test1 values('john','johnyong542@gmail.com',null);
6.select *from test1 where (name="john");