SELECT * FROM link_acc WHERE ((isauditing>'0' AND usergroup IN (-1)) OR (isauditing='0' AND usergroup IN (-1))) ORDER BY descMysql error description: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'desc' at line 1 Mysql error number: 1064 上面的sql语句哪里有错?我的数据库是:MySQL 4.0.25-nt
=========================================
语法错误,在'desc'附近。....order by desc
=======================
order by somethinghere desc
by什么了?
desc是降序!
如果desc是字段,要用`desc`<-这里不是引号哦,是1旁边那个符号!
因为desc是关键字!