tqla Posted May 21, 2010 Share Posted May 21, 2010 I would like to delete every row in my Clients table except one that has the ID of 1091. I am trying this but I get an error: DELETE * FROM `Clients` WHERE ID != '1091' What is the correct syntax? Thanks! Quote Link to comment Share on other sites More sharing options...
Mchl Posted May 21, 2010 Share Posted May 21, 2010 DELETE FROM `Clients` WHERE ID != '1091' Quote Link to comment Share on other sites More sharing options...
tqla Posted May 21, 2010 Author Share Posted May 21, 2010 Worked! Thanks Mchl. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.