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, 1535🔥, 0💬
Popular Posts:
Where to find SQL Server Transact-SQL language references? You can find SQL Server Transact-SQL lang...
What Is a Dynamic Performance View in Oracle? Oracle contains a set of underlying views that are mai...
What Is Program Global Area (PGA) in Oracle? A Program Global Area (PGA) is a memory buffer that is ...
How To List All Login Names on the Server in SQL Server? If you want to see a list of all login name...
How To Verify a User name with SQLCMD Tool in SQL Server? The quickest way to verify a user name in ...