SQL Structure & Queries for Exoplanet Database

SQL file of structure of exoplanet database. When the file is downloaded, be sure to change the "txt" extension to "sql". If using Windows, open Powershell and run this command:

rename-item ExoplanetStructure-ChangeExtensionToSql.txt ExoplanetStructure.sql

If using Linux, open a Command Line and run this command:

mv ExoplanetStructure-ChangeExtensionToSql.txt ExoplanetStructure.sql

Once it is renamed, you can import the SQL file into a relational database management system like phpMyAdmin/MariaDB which can be downloaded from here: https://www.apachefriends.org/

Also included file with queries; be sure to change the extension to "sql" similar to how the database structure file was changed. Then import the file into the database. Tested imports of both files with phpMyAdmin/MariaDB.

1. MariaDB database
2. phpMyAdmin front end
3. Apache webserver
4. All of the above 3 can be installed using XAMPP at www.apachefriends.org

PDF presentation about the exoplanet database is attached, along with a text version of the queries. Do not import this file into phpMyAdmin. It is for reference purposes only.