about billson
Gathering & Sharing
Showing posts with label
mysql
.
Show all posts
Showing posts with label
mysql
.
Show all posts
2022-05-31
Alternative - Error Code: 1093. You can't specify target table 'YOUR_TABLE' for update in FROM clause
›
Error Code: 1093. You can't specify target table 'YOUR_TABLE' for update in FROM clause UPDATE YOUR_TABLE SET columnA = 'd...
2021-10-22
Export connections in MySQL Workbench
›
saw in log: %USERPROFILE%\AppData\Roaming\MySQL\Workbench\connections.xml cd %USERPROFILE%\AppData\Roaming\MySQL\ zip up whole folder: Workb...
2021-09-23
Unable update table where clause in same sub table.
›
https://stackoverflow.com/a/43610081 If you can't do UPDATE table SET a = value WHERE x IN ( SELECT x FROM table WHERE c...
2021-06-28
Is working - while create function: ERROR 1418 (HY000) & ERROR 1267 (HY000)
›
SHOW VARIABLES LIKE '%char%'; ERROR 1418 (HY000): This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declar...
2013-07-31
MySql Select statement export to a file.
›
SELECT column_a, column_b, column_c FROM tb_abc INTO OUTFILE 'C:/folders/location/tb_abc.txt' FIELDS TERMINATED BY ',' OPT...
›
Home
View web version