G-Nugget questions

G-Nugget answers

• MySQL: Using GROUP BY vs subselect in columns list
• If table exists drop table then create it, if it does not exist just create it
• What is the best column type for a United States ZIP code?
• If jQuery AJAX data is sent/received, is it possible to only receive SOME of the data?
• Database design for posts and comments
• problems with node joining the cluster when using sst:xtrabackup (galera)
• PHP MySQL - Select all where expiry date = todays date + 7 days
• Best way to debug an array using PHP
• Mysql::Error: Specified key was too long; max key length is 767 bytes: CREATE INDEX
• PHP OPcache optimization levels - what are they?