Create A Table

• Creating a table is easy.
  • The hard part is deciding what structure the table should have.
  • What kind of data should go into the table.
  • One must decide how the fields should be named.
  • One must also decide what data type each field should have.

• Use the CREATE TABLE statement to specify the layout of a table.
  • For example:

    mysql> CREATE TABLE pet (name VARCHAR(20), owner VARCHAR(20), species VARCHAR(12);

• Use the ALTER TABLE statement to alter the layout of a table.
  • For example:

    mysql> ALTER TABLE pet ADD id INT AUTO_INCREMENT PRIMARY KEY;

• To see a list of existing tables, use the SHOW TABLES statement:
  • For example:

    mysql> SHOW TABLES;

• To verify the table was created as expected, use the DESCRIBE statement:
  • For example:

    mysql> DESCRIBE pet;

How do I load data into a table?

---

---

© 2007 John Michael Pierobon

Notes