数据库常用语句
mysql语句
string name;
int age;
string sex;
int phion;
1:增加
insert into student_table VALUES(NULL,"tom",14,"女",13133); insert into student_table(student_name,student_age,student_sex)VALUES("aaa",23,"男");
删除
delete from student_table where student_name="luck" and student_sex="美女";
修改
update student_table set student_age=29 where student_name="tom";
查询
select * from student_table where student_name="tom" and student_sex="男";