You can’t specify target table ‘XXX’ for update in FROM clause – MySQL
If you try to run this query below in MySQL UPDATE XXX SET count = count + 5000 WHERE id IN ( SELECT id FROM XXX WHERE id > 2 ) ; You will get … Read more
Category : MySQL
Cannot connect to Database server – Cannot start SSH tunnel manager (mysql workbench 5.2.33 or earlier)
Cannot connect to Database server – Cannot start SSH tunnel manager (mysql workbench 5.2.33 or earlier) Cause: Corrupted PYTHONHOME system variable. Solution : Add the mysql workbench python path to the system variable. The Mysql … Read more
MySQL and MSSQL Maximum Integer (Numeric) Values
MySQL TINYINT 127 SMALLINT 32767 MEDIUMINT 8388607 INT 2147483647 BIGINT 9,223,372,036,854,775,807 MSSQL TINYINT 255 SMALLINT 32767 INT 2147483647 BIGINT 9,223,372,036,854,775,807 Reference MSSQL http://msdn.microsoft.com/en-us/library/aa258271(v=sql.80).aspx MySQL http://dev.mysql.com/doc/refman/5.0/en/numeric-types.html
Add a Mysql as a Linked Server
The other day I got a request to migrate some data from Mssql to Mysql. I am like ok fine, I will just use SSIS and it will take me a second. This second led … Read more
Rename a Table in Mysql
The other day I wrote a piece on renaming a Mysql databases and I thought that it could also be useful if I show you how to rename a Table using phpMyAdmin and MySQL Workbench … Read more