Summarize the following:
There are a few main aspects of your table that you'll want to know before creating one: Title Your title will go directly after the "create table" command, and must follow the same rules as your database's name (e.g., no spaces). Column Heading You can determine column headings by typing different names into a set of parentheses (see the next step's example). Cell Length When determining cell length, you'll use either "VARCHAR" (variable characters, meaning that you can type in between one and the VARCHAR's limit number of characters) or "CHAR" (requires no more and no less than the specified number of characters; for example, CHAR(1) requires one character, CHAR(3) requires three characters, and so on). Date If you want to add a date to your chart, you'll use the "DATE" command to indicate that the column's contents will be formatted as a date. The date should be entered in YYYY-MM-DD format. Before you can input data for your chart, you'll need to create the chart's structure by typing in the following and then pressing Enter: create table name (column1 varchar(20), column2 varchar(30), column3 char(1), column4 date); For example, to create a table called "Pets" with two VARCHAR columns, a CHAR column, and a date column, you might write the following: create table Pets (Name varchar(20), Breed varchar(30), Sex char(1), DOB date); Using the "insert" command, you can enter your database's information line-by-line: insert into name values ('column1 value', 'column2 value', 'column3 value', 'column4 value'); For the "Pets" table example used previously, your line might look like this: insert into Pets values ('Fido', 'Husky', 'M', '2017-04-12'); You can enter the word NULL for a column's contents if the column is blank. If your database is relatively small, you can insert the rest of the data line-by-line by using the "insert" code. If you elect to do this, skip the next step. If you have a database which requires more lines of information than are practical to insert by hand, you can reference a text file that contains the data by using the following code: load data local infile '/path/name.txt' into table name lines terminated by '
'; For the "Pets" example, you would write something like the following: load data local infile 'C:/Users/name/Desktop/pets.txt' into table Pets lines terminated by '
'; On a Mac computer, you'll need to use the "lines terminated by" command with '
' instead of '
'. Enter the show databases; command, then select your database by typing in select * from name; where "name" is the database's name. For example, if using the "Pet Records" database, you'd enter the following: show databases; select * from Pet_Records;

Summary:
Understand the different table commands. Create the table outline. Add a line to your table. Insert the rest of your data if possible. Upload a text file if needed. View your table.