[thelist] simple sql question
Brian Cummiskey
brian at hondaswap.com
Thu Nov 23 23:30:34 CST 2006
how do i re-write this as a DELETE statement instead of a SELECT? I'm
pruing out some duplicate files...
SELECT max(fileid) FROM files
GROUP BY title HAVING count(*) >1
Everytime i try to delete it via phpmyadmin on the X, it gives me the
following error:
Error
*SQL query:*
DELETE FROM `files` WHERE `files`.`max( fileid )` =563 LIMIT 1
*MySQL said: *
| #1054 - Unknown column 'files.max( fileid )' in 'where clause'
I'm not sure how to get around this.
Thanks!
|
More information about the thelist
mailing list