Saturday, November 11, 2017

Got rid of #1036 - table is read only using phpmyadmin

Today when one of my acquittance asked me that he is unable to access mysql on his wamp server I asked him to show me his system. Initially I thought that the problem is in his php script. I check the script but nothing was wrong.
Then I decided to check the query. The query was also looking fine. I was suspecting that the problem might be related to incorrect syntax so I decided to print the query generated by php and run it direct on mysql server (it was insert statement).

Exercise Basic Programming Concepts