Collections:
Create a Test Table with Test Data in MySQL
How To Create a Testing Table with Test Data in MySQL?
✍: FYIcenter.com
If you want to follow the tutorial exercises presented in this collection, you need to create a testing table and insert some test data, as shown in the following sample script:
mysql> CREATE TABLE fyi_links (id INTEGER PRIMARY KEY, url VARCHAR(80) NOT NULL, notes VARCHAR(1024), counts INTEGER, created TIMESTAMP DEFAULT CURRENT_TIMESTAMP()); Query OK, 0 rows affected (0.08 sec) mysql> INSERT INTO fyi_links VALUES (101, 'dev.fyicenter.com', NULL, 0, '2006-04-30'); Query OK, 1 row affected, 1 warning (0.01 sec) mysql> INSERT INTO fyi_links VALUES (102, 'dba.fyicenter.com', NULL, 0, DEFAULT); Query OK, 1 row affected, 1 warning (0.01 sec) mysql> INSERT INTO fyi_links (url, id) VALUES ('sqa.fyicenter.com', 103); Query OK, 1 row affected, 1 warning (0.01 sec)
You should keep this table and its data to practice other tutorial exercises presented in this collection.
⇒ Selecting All Columns of All Rows in MySQL
⇐ What Is a SELECT Query Statement in MySQL
2017-11-05, 1712🔥, 0💬
Popular Posts:
How To Look at the Current SQL*Plus System Settings in Oracle? If you want to see the current values...
What Is "mysqld" in MySQL? "mysqld" is MySQL server daemon program which runs quietly in background ...
Where to find answers to frequently asked questions on CREATE, ALTER and DROP Statements in MySQL? H...
What Is Oracle in Oracle? Oracle is a company. Oracle is also a database server, which manages data ...
What To Do If the StartDB.bat Failed to Start the XE Instance in Oracle? If StartDB.bat failed to st...