MySQL基础语法

1、创建库

create database mq

2、创建表

create table students(
	id int(8) not null primary key auto_increment,	//not null=>不能为空，primary key=>id设置为主键，auto_increment=>自动增加id值
   username varchar(20),
   password varchar(20),
   phone    bigint(10),	// bigint=>该字段下能输出显示的最大数字长度
   address  varchar(20)     
)

3、插入语句

insert into vip(username,password,phone,address) value('小乔','123','1008611111','lb@168.com')
insert into vip(username,password,phone,address) value('奥尼尔','124','1008611112','fz@168.com')

4、查询语句

select	* from students	//查询表格中所有信息
select	username,password from students	//查询字段username，password信息
select	* from students where username='小乔'	//查询username='小乔'的信息
select	* from students where username='小乔'	and password='123456' //and 且
select	* from students where username='奥尼尔'	or password='111111' //or 或

5、更改语句

update students set password='sws123' where username='小乔'

6、删除语句

删除行：delete from vip where username='小乔' 
删库：drop database mq
删表：drop table student