MYSQL insert

[jimseng]

Hi.
I have been using the mysql example quite sucessfully for select queries but it doesn't work for insert or delete queries. The response is an internal server error) Has anybody got an example for this?

 

[Widget]

Check the MySQL error log file (winuser.err) in the MySQL Data directory. Chances are the MySQL user you are using to connect to MySQL has read only access to the table you are trying to update. Either that or you are trying to update data in a table join. The error log file should tell you what is wrong.

You can always write the SQL statement you are trying to execute to the Android log and then copy and paste it into a MYSQL Mgr like Sqlyog and run it there. There is a free community edition for SqlYog that is quite good.

Widget