To create the table inside of a database:

CREATE TABLE MyGuests (
id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
firstname VARCHAR(30) NOT NULL,
lastname VARCHAR(30) NOT NULL,
email VARCHAR(50),
reg_date TIMESTAMP
) 

To populate the table:

INSERT INTO MyGuests (firstname, lastname, email) VALUES ('John', 'Doe', 'john@example.com');
INSERT INTO MyGuests (firstname, lastname, email) VALUES ('Barbara', 'Hecker', 'bhecker@acm.org');
INSERT INTO MyGuests (firstname, lastname, email) VALUES ('Jane', 'Doe', 'jane@example.com');