简单的mysql语句

来源:互联网 发布:乐视视频提示网络异常 编辑:程序博客网 时间:2024/05/19 00:52

//查询
SELECT * from job;
SELECT age from job;
select * from job where age=’20’;
select * from job where age=’20’ or id=’2’;

//新增
INSERT INTO job (age,job,id) VALUES (30,’阿里巴巴’,’3’);

//删除
DELETE from job where id=’2’;

//查
UPDATE job set job=’京东’ where id=’1’;

0 0
原创粉丝点击