Find the collation of all tables within a mysql database

Needing to find a collation of a mysql database for a migration I went to google. Found several options, but the best was one from stack overflow. This will output something like: The first part of this shows the overall database collation. In this case, it is utf8_general_ci. Then the second part shows the collation Read more about Find the collation of all tables within a mysql database[…]

Query to insert all countries into database

I needed to insert all of the countries in the world into a database. I couldn’t find the query to run, so I created my own. Here it is. ‘country’ is the table name and ‘name’ is the column name. INSERT INTO country (name) VALUES (‘Afghanistan’), (‘Albania’), (‘Algeria’), (‘Andorra’), (‘Angola’), (‘Antigua and Barbuda’), (‘Argentina’), (‘Armenia’), Read more about Query to insert all countries into database[…]