insert 语句的语法格式如下:
insert into table_name [(column [,column ...])]
Values(Value [,value ...]);
例如:
insert into teacher_table
//当向外键里插入值时,外键列的值必须是被参照列里已有的值
Values(null,'张三', 2);
例如同时插入多个值:
insert into teacher_table
Values(null,"张三"),(null , "赵瑜");
Update语法
update语法的格式如下
update teacher_table
set column1= vslue1 [,column2 = value2 ] ....
[WHERE condition]
//下方语句会将teacher_table表里的teacher_name 列的值都改为'孙悟空'
update teacher_table
set teacher_name= '孙悟空'
//通过where语句只修改特定的语句:
//下列语句只修改teacher_id大于1的记录
update teacher_table
set teacher_name= '猪八戒'
where teacher_id>1;
delete from 语法
delete from 使用方法如下:
delete from table_name
[WHERE condition]
//如下语句会将teacher_name表中记录全部删除
delete from teacher_name;
//也可以使用where语句进行限定
delete from teacher_name
where teacher_id >1;
全部代码
查询当前实例下包含多少个数据库
show databases;
删除指定的数据库
drop databases 数据库名;
创建新的数据库
creat databases [IF NOT EXISTS] 数据库名;
insert 语句的语法格式如下
insert into table_name [(column [,column ...])]
Values(Value [,value ...]);
例如:
insert into teacher_table
Values(null,'张三', 2);
例如同时插入多个值:
insert into teacher_table
Values(null,"张三"),(null , "赵瑜");
update语法的格式如下
update teacher_table
set column1= vslue1 [,column2 = value2 ] ....
[WHERE condition]
//下方语句会将teacher_table表里的teacher_name 列的值都改为'孙悟空'
update teacher_table
set teacher_name= '孙悟空'
通过where语句只修改特定的语句
下列语句只修改teacher_id大于1的记录
update teacher_table
set teacher_name= '猪八戒'
where teacher_id>1;
delete from 使用方法如下
delete from table_name
[WHERE condition]
如下语句会将teacher_name表中记录全部删除
delete from teacher_name;
也可以使用where语句进行限定
delete from teacher_name
where teacher_id >1;