mysql基本操作

1.create database name;

2.create table name;

create table lyy2(
-> id int not null auto_increment,
-> name varchar(40) not null,
-> height float not null,
-> primary key(id)
-> )engine=innodb default charset=utf8;

3.use database;

4.select * from table name;

5.create table xpy1(

6.insert into tablename

> insert into lyy2(id,name,height)
-> values
-> (3,"ly1",181.5),(2,"ly2",182.6);