Use a CREATE TABLE statement to specify the layout of your table:
CREATE TABLE pet (
name VARCHAR(20),
owner VARCHAR(20),
species VARCHAR(20),
sex CHAR(1),
birth DATE,
death DATE);
CREATE TABLE test_names (
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
lastname VARCHAR(30) NOT NULL,
firstname VARCHAR(25)
);
INSERT INTO test_names (lastname, firstname)
VALUES ('Last','First');
Once you have created a table, SHOW TABLES should produce some output:
SHOW TABLES;
To verify that your table was created the way you expected, use a DESCRIBE statement:
DESCRIBE pet;