Mysql难语句总结
1.concat 函数SELECT id, nameFROM customerWHERE geo_code LIKE CONCAT(?, '%');2.模糊查询+in elementsSELECT s FROM teacher t,student s WHERE t.tno ='001' AND s.sname LIKE '张%' AND s IN ELEMENTS(t.students)3.自定...
原创
2018-06-29 17:07:15 ·
725 阅读 ·
0 评论