day17 MySQL

登录数据库

mysql -h localhost -P 3307 -u root -p

查看所有数据库

show databases;

退出数据库

exit;

//现有表格
use situ;//使用哪个数据库
create table student(
	id int primary key,
	s_name varchar(10) not null,
	s_age int nut null,
	s_sex varchar(2) nut null
);
select * from student;

//--或者#是navicat的单行注释（有且只有这两种）
//数据库增删改查
//# 增
insert into student(s_name,s_age,s_sex) values('zs',11,'男');

//#删
delete from student where id = 1;

//#改
update student set age=18 where name='zs';

//#查
selete*from student;
select s_name,s_age where id=2;

day17 leaningVideos