摘要:多表联合查询select a.*,b.*,c.* from a INNER JOIN b ON a.cid=b.cid INNER JOIN c ON c.cid=a.cid where a.cid=2 and a.id =3删除多条删除id为3,4589的记录deletefromlanguage_flashwhereid=3orid=4 orid=8现在这个or太多 比较2b应使用indeletefromlanguage_flashwhereid in (1,3,4,5);查询表里的所有列名select COLUMN_NAME from information_schema.co...
阅读全文
随笔分类 - 数据库