How To Create a Test Table in Your MySQL Server?

Answer

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

>cd mysqlbin
>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 wbtest
Database changed

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

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

mysql> SELECT * FROM wbtest; +---------------------------------+

| message |

+---------------------------------+

| Welcome to GlobalGuideLine.come |

+---------------------------------+

1 row in set (0.00 sec)

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

mysql> quit
Bye

All sql dba Questions

Ask your interview questions on sql-dba

Write Your comment or Questions if you want the answers on sql-dba from sql-dba Experts
Name* :
Email Id* :
Mob no* :
Question
Or
Comment* :
 





Disclimer: PCDS.CO.IN not responsible for any content, information, data or any feature of website. If you are using this website then its your own responsibility to understand the content of the website

--------- Tutorials ---