SQL Where values are not in another table
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 next available ID
Select next available ID ## Select the next available UID ## Do not delete users from unixuid and unix gid as there id’s may get re-used ######################################## [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 >200 AND r2.uid […]
MYSQL – Replication
MYSQL – Replication Login to your mysql server: mysql -uBla -p Some useful commands SHOW SLAVE STATUS; SHOW MASTER STATUS; SHOW PROCESSLIST ; SHOW SLAVE HOSTS;