2002 Cannot log in to the MySQL server – MAC To fix In /etc/php.ini, replaced the three occurences of /var/mysql/mysql.sock with /tmp/mysql.sock prompt% sudo chmod u+w php.ini <- had to give myself write permission to that file.. you may need to become root user to actually edit the file.. depends who owns php.ini Now edit […]
SQL Where values are not in another table [sql] select TCode from Tracking where not exists (select * from Task where Task.TCode = Tracking.TCode ) [/sql]
Select the next available value in a table Let’s say I have a table like this: ID Value ———————- 100 val1 101 val2 104 val3 105 val4 107 val5 [sql] SELECT Min(r1.uid) + 1 AS next_available_uid FROM unixuid AS r1 LEFT OUTER JOIN unixuid AS r2 ON r2.uid = r1.uid + 1 WHERE r1.uid > […]