UPDATE table1 SET table1field =
(SELECT SUM(table2field) FROM table2 where table2field2 = 123) WHERE table1field = 123;
ERROR: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT SUM(workers) FROM buildings where uid = 20023)' at line
Is it my mistake or my mysql version is very low and don`t support subqueries. Btw how can I understand it. Is there a query witch return mysql information ( equal to phpinfo() function in PHP )
I believe subquery support was added in 4.1 (could be wrong, but close)
Set Search Time - A google chrome extension. When you search only results from the past year (or set time period) are displayed. Helps tremendously when using new technologies to avoid outdated results.