MySQL
Subquery using NOT IN doesn’t seem to work in MySQL
For some reason today when attempting to do a an INSERT INTO statement using a SELECT from to populate the condition I used to retrieve data, that is a NOT IN statement to prevent existing records being duplicated simply wouldn’t work. I’ve heard that on MSSQL server that NOT EXISTS is a more efficient option [...]
MySQL ERROR 1153: Got a packet bigger than ‘max_allowed_packet’ bytes
Default packet settings can be problematic when you’re doing backups/restores of large DBs.
To overcome this issue, just set larger buffers by running these SQL statements in your normal SQL window:
set global max_allowed_packet=1000000000;
set global net_buffer_length=1000000;