Creating a Test Table

∟Creating a Test Table - Comment

This section describes how to create a new table for testing purpose with MySQL monitor.

In order to perform database related tests on MySQL server, I created a new table called "Comment" with MySQL command line tool:

C:\herong> \local\mysql\bin\mysql -u Herong -pTopSecret
mysql: [Warning] Using a password on the command line interface can 
   be insecure.

mysql> USE HerongDB;
Database changed

mysql> CREATE TABLE Comment (ID INTEGER PRIMARY KEY AUTO_INCREMENT,
    ->   Name VARCHAR(256), Comment LONGTEXT);
Query OK, 0 rows affected (0.02 sec)

mysql> INSERT INTO Comment (Name, Comment)
    ->   VALUES ('Herong', 'This is a test.');
Query OK, 1 row affected (0.36 sec)

mysql> SELECT * FROM Comment;
+----+--------+-----------------+
| ID | Name   | Comment         |
+----+--------+-----------------+
|  1 | Herong | This is a test. |
+----+--------+-----------------+
1 row in set (0.00 sec)