Category: Mysql
-
#1093 You can not specify target table comments for update in FROM clause
When I try to run update query for my table “comments”, MySQL returns the #1093 – You can’t specify target table ‘comments’ for update in FROM clause message. My contrived table structure and update query are as follow: Actually, your above update query seems illegal as per SQL standard. MySQL does not allow to UPDATE […]
-
Mysql – Restore only one database from sqldump
Restoring the whole mysql dump is easy. Either use phpMyAdmin(if the file is not too big) or do it from the console. I had a hard time finding it how to restore only one database from the sqldump of all databases.