StumbleUpon  Del.icio.us  Facebook  Reddit  Add to diigo  


Follow - Monx007
Article Time Stamp: 17 August 2009, 21:08:06 GMT+7

MySQL Syntax Error And Solutions




I want to delete all record in my table with this code:
$list=mysql_query("select * from data",$myconnection);
while($delrow=mysql_fetch_row($list)){
mysql_query("delete from data");}

Those syntax has deleted all the records from table data, but not work with autoincremental field type. How can i delete the autoincremental field record ?



::Solutions::
You can use this code:
TRUNCATE `table_name`





Can't find any matching row in the user table



::Solutions::
When you try to grant privileges or password for certain user, you may get above error. Check whether those user have privileges on that host.

example:
GRANT SELECT, INSERT, DELETE, UPDATE ON `phpmyadmin`.* TO 'pma'@localhost;

Check the pma user had privileges on localhost, otherwise you'll get those error.

Article Source: Monx Digital Library

Copyrighted@ Monx Digital Library, otherwise stated
Use of our service is protected by our Terms of Use



 Back To Previous Page ...  



 

 

 

AQWorlds Banner