#Sequel pro sql insert export code#

Both primary and unique keys are indices whose members must all be unique. CREATE DATABASE is self explanatory however, itвЂ™s important to noticeВ the way we set student_id as the PRIMARY KEY here and set student_lastName as a UNIQUE key.

#Sequel pro sql insert export code#

LetвЂ™s take some time to understand the code weвЂ™ve just used. To create the table, unsurprisingly, weвЂ™ll use the command вЂњCREATE TABLEвЂќ to create a table of classmates and proceed to indicate the primary key column and an initial (unique) column for the database. To learn more about the organization of a database or, more specifically, the relationship between a database and its tables, check out this post. Now, youвЂ™ll need to create a table in order to add some actual content to your database.In order to work with the database your have just created, use the command вЂњUSEвЂќ and type USE classmate_database and run the command just as you did before.To check that youвЂ™ve successfully created the database, navigate to the вЂњTABLESвЂќ section of the Sequel Pro windowВ and locate classmate_database. To create your database, type CREATE DATABASE classmate_database В then press вЂњRun PreviousвЂќ just below in order to run your code and create your database. In this demo, I will create a database of classmates, but feel free to mimic the syntax used in order to create a database of your choosing. Once connected,В you will automatically be in the вЂњQueryвЂќ section of Sequel Pro, where you will type and run MySQL commands.Create a Standard connection to your MySQL Server, using IP address 127.0.0.1 as the Host and your MySQL root credentials for the Username and Password.See this walkthrough for assistance in doing so. Start your machineвЂ™s MySQL Server instance through System Preferences.This walkthroughВ has been created using this tutorial as a resource.