#建库---
create database tay
-> character set=utf8
-> collate=utf8_general_ci;
#建表---
create table student(
-> id int primary key auto_increment,
-> name varchar(20) not null,
-> age int not null,
-> address varchar(50) not null
-> );
#删库---drop database <数据库名>;
#删表---drop table <表名>;
#增---insert into student (name,age,address) values ("孙悟空",25,"花果山");
#删---delete from student where id=1;
#改---update student set name=555,age=555,address=555 where id=53;
#查---select * from student;
#使用shell查询数据库
#---mysql -uroot -pTay123.. -e "use tay;select * from student;"
#使用shell自动添加10万条数据
#---mysql -uroot -pTay123.. -e "use tay;insert into student (name,age,address) values ('${i}',${i},'${i}');"
