Updating a row in mysql2 | 22 from 01 08 2003 / 23 from 02 08 2003 / | | 3 |
$sql = "UPDATE subscriber SET Subscriber_Name = '" .
If UPDATE gives an error like this:"You are using safe update mode and you tried to update a table without.."..it may be that your file must be edited to disable safemode. In order for the change in the file to take effect, you must have permission to restart mysqld in the server OS environment.
There is a page in the online documentation that explains safe mode entitled 'safe Server Startup Script'.
(Bug #11758262, Bug #50439) See Section 188.8.131.52, “Determination of Safe and Unsafe Statements in Binary Logging”, for more information.
If you access a column from the table to be updated in an expression, assignments are generally evaluated from left to right.