hno Posted June 27, 2009 Share Posted June 27, 2009 HI I wrote this query:"DELETE FROM 'shop'.'comment' WHERE 'comment'.'id'=1 limit 1" and run it with php and mysqli_affected_rows shoes me that the query was successfully run but when I opened phpmyadmin it was still exist and didn't delete from there Why it's not delete ? thanks Quote Link to comment Share on other sites More sharing options...
trq Posted June 27, 2009 Share Posted June 27, 2009 Firstly, this is the Microsoft SQL - MSSQL help board, are you using MSSql or MySql? I'll assume your using MySql and just posted in the wrong board considering that your talking about phpmyadmin and the LIMIT clause does not exist within MySql. Anyway, your query uses invalid syntax and should be.... DELETE FROM shop.comment WHERE comment.id=1 limit 1 Using strings as identifiers won't get you anywhere. 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.