mysql：数据库

数据库常用语句

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="男";