The Table Designer tool in MySQL Workbench is a useful, visual way to learn how to create MySQL tables. In order to create tables, you need to understand the data that those tables will contain, as well as how the data will interact with other datasets.
- [Instructor] Now that we have a database,…we need to create a table within that database…to store our data.…To create a new table,…right-click on the Tables folder…underneath your database name…and click Create Table.…This opens up a new tab with the visual table designer.…The first thing we have to do…is choose a name for our table.…Since we're going to store…California population projection data,…I'm going to call it pop_proj.…Make sure the schema has the name of the database you want.…In this case, ca_pop.…Just like creating a new database,…you can leave the schema on default,…and you can also leave the storage engine on default.…
MySQL uses different engines…with different limitations, capabilities,…and performance characteristics…when storing data in tables.…The differences between engines…are beyond the scope of this course,…and at any rate, whichever engine you choose,…it won't make any difference for basic SQL…or for the purposes of this course.…Looking back at the raw data,…we can see that the first value is the county code.…
- Strengths and weaknesses of MySQL
- Creating a database
- Joining data sets
- Integrating Python with MySQL
- Searching a database
- CRUD operations
- Performing calculations
Skill Level Intermediate
1. Data and MySQL in under Five Minutes
2. Create a Database
3. Join Two Datasets
4. Search a Database
Searching a database1m 51s
5. Create, Read, Update, and Delete Operations
6. Averages and Calculations
Next steps1m 1s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.