mysql的基本命令介绍

mysql -uroot -p

show databases;

create database firstsql;

use firstsql

show tables;

create table student(

  ID char(7) primary key,

  NAME varchar(20) not null,

  Age varchar(20) default '10'

)comment='信息';

desc firstsql.student;

show create table student;

select * from student;

select ID,NAME,Age from Student;

select * from Student where ID='001';

insert into student values ('001','二哈','计算机');

delete from student;

delete from student where ID='001';

update student set NAME='物联网' where ID='001';