Activity 8.01 – multiple updates

The manager of the ABC company wants to add new details to the existing country table in the world_statistics database, that is, the capital city of each country, the independence status of each country, and their currency types. You have been tasked with making these changes and updating the database. This new information has been provided through SQL scripts so that you can create and populate a temporary table and create the new countryalldetails table. To implement this activity, perform the following steps:

1. Create a database connection to the world_statistics database.
2. Create the countryalldetails table with the following columns: CountryID, ContinentID, CountryCode, CountryName, Is_independent, Currency, and Capital.
3. Load the data found at https://github.com/PacktWorkshops/The-MySQL-Workshop/blob/master/Chapter08/Activity8.01/CountryDetails.sql into the countryalldetails table.
4. Using the new temporary table, populate...