Collections:
Creating a Test Table in MySQL Server in MySQL
How To Create a Test Table in Your MySQL Server in MySQL?
✍: FYIcenter.com
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
⇒ Shutting Down MySQL Server in MySQL
⇐ Verify the Version of MySQL Server in MySQL
2018-06-06, 1536🔥, 0💬
Popular Posts:
How to download and install Microsoft .NET Framework Version 2.0 in SQL Server? .NET Framework Versi...
How To Connect ASP Pages to Oracle Servers in Oracle? If you are running Windows IIS Web server and ...
What Happens to Your Transactions When ERROR 1205 Occurred in MySQL? If your transaction receives th...
Where to find answers to frequently asked questions on Storage Engines: MyISAM, InnoDB and BDB in My...
How To Recover a Dropped Index in Oracle? If you have the recycle bin feature turned on, dropped ind...