查询
select id,jobName,salary,company_name,welfare,JobDetail from mytable where eduLevel = “本科” and city_name = “广州”
带order语句的顶薪排序查询
select substring(salary,-2),id,jobName,salary,company_name,welfare,JobDetail from mytable order by substring(salary,-3)
降序可在最后加DESC,查询起薪可以修改substring函数的参数
带有聚集函数和group by的工作类型查询
select jobType2_name,count(*) from mytable group by jobType2_name
添加
insert into mytable(id,jobName,salary,jobType2_code,jobType2_name,industry_code,city_code,city_name,welfare,eduLevel,workingExp,company_name,positionURL)
values(12580,“Java软件研发工程师”,“8K-10K”,160000,“软件/互联网开发/系统集成”,“160000,160400,160200”,763,“广州”,"[五险一金, 绩效奖金, 餐补, 通讯补贴, 定期体检]",“本科”,“1-3年”,“浪潮集团有限公司”,"https://jobs.zhaopin.com/CC120143601J00063993413.htm,")
检查添加是否成功
select * from mytable where id = 12580
默认模式为安全模式,无法对原本的数据进行修改或删除,所以如果要使更新和删除功能需要关闭安全模式,
SET SQL_SAFE_UPDATES = 0;
查询操作是否成功
删除并查询结果
delete from mytable where id =11111
创建视图