SELECT t1.id FROM tableOne t1 LEFT JOIN tableTwo t2 ON t1.id = t2.id WHERE t2.id IS NULL The “WHERE t2.id IS NULL clause” restricts the results to only those rows where the id returned from tableTwo is null. tableTwo.id will be NULL for all records from tableOne where the id is not found in tableTwo.
I needed to automate the addition of new users with a sequential member’s ID in WordPress. Additionally, there were non-numeric entries in that column that had to be ignored. The wp_users.user_login column is a varchar(60) and so does not naturally handle numeric operations well at all. The solution is a combination of REGEXP and cast(): […]
To change security authentication mode: In SQL Server Management Studio Object Explorer, right-click the server, and then click Properties. On the Security page, under Server authentication, select the new server authentication mode (Windows and SQL auth), and then click OK. In the SQL Server Management Studio dialog box, click OK to acknowledge the requirement to […]
mysql--batch-uroot-p-e"create database yourDataBaseBackup; SELECT CONCAT('RENAME TABLE ',table_schema,'.',table_name,' TO ','yourDataBaseBackup.',table_name,';') FROM information_schema.TABLES WHERE table_schema LIKE 'yourDataBase';">backup.sql
INSERT INTO newtable(`name`,`address1`,`address2`,`city`,`state`,`zip`,`phone`)SELECT`name`,`address1`,`address2`,`city`,`state`,`zip`,`phone`FROM oldtable;
erics, May 16th, 2018 
Categories: How-To's, Technology howto, Join, Left Join, mysql, Query, Row, Rows, select, SQL, Table, tips, Where
| 
No comments 
