Using Insert to populate tables

The following code example is from Connecting to a MySQL Databaseis allows you to insert data into a table by first creating the table, and then using the Insert syntax:

CREATE TABLE Counselor (
    id SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT,
    firstName VARCHAR (50),
    nickName VARCHAR (50),
    lastName VARCHAR (50),
    telephone VARCHAR (25),
    email VARCHAR (50),
    memberSince DATE DEFAULT '0000-00-00',
    PRIMARY KEY (id)
);

Then populate the table with the data:

INSERT INTO Counselor
    VALUES (1, 'Ricky', '"The Dragon"', 'Steamboat','334 612-5678', 'r_steamboat@ifpwafcad.com', '1996-01-01')

Using Insert to populate tables

Labels