Log on as the temporary user, Alex, to create a test table and insert rows.
- Log on as Alex.
- Set the default database for the session to Tables_Database. For example:
DATABASE Tables_Database;
- Create a table named employee with emp_id, emp_name, and start_date columns. For example:
CREATE SET TABLE employee ( emp_id INTEGER, emp_name CHARACTER(20) CHARACTER SET LATIN NOT CASESPECIFIC, start_date DATE) PRIMARY INDEX (emp_id);
- Insert rows of data into the table. For example:
INSERT INTO employee (emp_id, emp_name, start_date) VALUES (1001, 'Mary', '2010-01-10');
INSERT INTO employee (emp_id, emp_name, start_date) VALUES (1002, 'Sam', '2014-07-01');
INSERT INTO employee (emp_id, emp_name, start_date) VALUES (1003, 'Charles', '2016-02-10');