---Enter password: ******* Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3 to server version: 5.0.4-beta-nt Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> create database cake; Query OK, 1 row affected (0.00 sec) mysql> connect cake; Connection id: 4 Current database: cake mysql> CREATE TABLE contacts ( -> id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY, -> subject VARCHAR(50), -> body TEXT, -> sent DATETIME DEFAULT NULL, -> received DATETIME DEFAULT NULL -> ); Query OK, 0 rows affected (0.09 sec) mysql> INSERT INTO contacts (subject,body,sent) VALUES ('First message', 'What i s a database ?', NOW()); Query OK, 1 row affected (0.05 sec) mysql> INSERT INTO contacts (subject,body,sent) VALUES ('Second message', 'Is it just a set of tables ?', NOW()); Query OK, 1 row affected (0.03 sec) mysql> INSERT INTO contacts (subject,body,sent) VALUES ('Third message', 'A data base must be relational ?', NOW()); Query OK, 1 row affected (0.03 sec) mysql> select * from contacts; +----+----------------+---------------------------------+---------------------+----------+ | id | subject | body | sent | received | +----+----------------+---------------------------------+---------------------+----------+ | 1 | First message | What is a database ? | 2008-03-12 10:29:15 | NULL | | 2 | Second message | Is it just a set of tables ? | 2008-03-12 10:29:28 | NULL | | 3 | Third message | A database must be relational ? | 2008-03-12 10:30:46 | NULL | +----+----------------+---------------------------------+---------------------+----------+ 3 rows in set (0.00 sec)