brl2179118218的博客

原创 数据库基础增删改查操作

select * from emp where gender='男' and age>=20&&age<=40 and name like '___';select * from emp where gender='女' and age=20 or age=21 or age=22 or age=23;insert into 表名(字段1，字段2,...)values(值1，值2,...)[,(值1，值2,...)...];CREATE DATABASE （if not exist）数据库名;