Updating a mysql database
There may be a requirement where the existing data in a My SQL table needs to be modified. This will modify any field value of any My SQL table.
The following code block has a generic SQL syntax of the UPDATE command to modify the data in the My SQL table − The WHERE clause is very useful when you want to update the selected rows in a table.
Solving the 503 error with an updated URL Jiri Sedlacek said: See This will use the SQL UPDATE command with the WHERE clause to update the selected data in the My SQL table tutorials_tbl.The following example will update the tutorial_title field for a record having the tutorial_id as 3.That explanation of the "solution" may be enough for some to take the ball and run with it (and if not, I will offer more details on how to do that), though it should be noted that updating the driver is not formally supported, nor is My SQL 5.6 technically supported at all in CF10 (or 9).
But for those who will press on knowing that risk, you now know what you need to do.This course will also teach you SQL and you will be a SQL power user by the end of this course.