Add Records

1. Type/Copy the following statements on a notepad.
2. Save the file with extension as sql; for example, insert_fruit.sql
3. Upload the file to server(outside of public_html folder)
4. Log into your MySQL account and use command "source" to access the work; for example,
   source insert_fruit.sql;

INSERT INTO fruit (name, color) VALUE ('banana', 'yellow');
INSERT INTO fruit (name, color) VALUE ('tangerine', 'orange');
INSERT INTO fruit (name, color) VALUE ('plum', 'purple');

SELECT * FROM fruit;