Home >> FAQs/Tutorials >> MySQL Tutorials

MySQL Tutorial - Creating a Test Table in MySQL Server

By: FYIcenter.com

(Continued from previous topic...)

How To Create a Test Table in Your MySQL Server?

If you want to create a test table in your MySQL server, you can use the "mysql" program in a command window as shown in the following tutorial:

>cd \mysql\bin
>mysql -u root
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 8 to server version: 5.0.24-

mysql> use test
Database changed

mysql> CREATE TABLE test (message VARCHAR(80));
Query OK, 0 rows affected (0.13 sec)

mysql> INSERT INTO test
    -> VALUES ('Welcome to FYIcenter.com');
Query OK, 1 row affected (0.03 sec)

mysql> SELECT * FROM test;
+---------------------------+
| message                   |
+---------------------------+
| Welcome to FYIcenter.come |
+---------------------------+
1 row in set (0.00 sec)

mysql> DROP TABLE test;
Query OK, 0 rows affected (0.01 sec)

mysql> quit
Bye

(Continued on next topic...)

  1. What Is MySQL?
  2. How To Install MySQL Server?
  3. How To Start MySQL Server?
  4. How Do You Know If Your MySQL Server Is Alive?
  5. How Do You Know the Version of Your MySQL Server?
  6. How To Create a Test Table in Your MySQL Server?
  7. How To Shutdown MySQL Server?

MySQL Tutorials:

More...


Other Tutorials/FAQs:

More...


Related Resources:

More...


Selected Jobs:

More...