How To Create A Test Table In Your MySQL Server

How To Create A Test Table In Your MySQL Server


  • 29 Dec, 2011

    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 in>mysql -u rootWelcome to the MySQL monitor. Commands end with ; or g.Your MySQL connection id is 8 to server version: 5.0.24-mysql> use testDatabase changedmysql> CREATE TABLE test (message VARCHAR(80));Query OK, 0 rows affected (0.13 sec)mysql> INSERT INTO test -> VALUES ('Welcome to GlobalGuideLine.com');Query OK, 1 row affected (0.03 sec)mysql> SELECT * FROM test;+---------------------------------+| message |+---------------------------------+| Welcome to GlobalGuideLine.come |+---------------------------------+1 row in set (0.00 sec)mysql> DROP TABLE test;Query OK, 0 rows affected (0.01 sec)mysql> quitBye

    Comments Received:
    Please give your suggestions and feedback:

2009-2016 downloadmela.com. All rights reserved.