Home >> FAQs/Tutorials >> MySQL Tutorials >> Index

MySQL FAQs - Downloading and Installing MySQL on Windows

By: FYIcenter.com

Part:   1  2  3  

(Continued from previous part...)

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

How To Shutdown MySQL Server?

If you want to shutdown your MySQL server, you can run the "mysqladmin" program in a command window as shown in the following tutorial:

>cd \mysql\bin
>mysqladmin shutdown

Part:   1  2  3