Collections:
Creating a Test Table in MySQL
How To Create a Testing Table in MySQL?
✍: FYIcenter.com
If you want to practice DML statements, like INSERT, UPDATE and DELETE, you should create a testing table. The tutorial exercise shows you a good example:
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)
You should keep this table to practice other tutorial exercises presented in this collection.
⇒ Inserting a New Row into a Table in MySQL
⇐ What Are DML Statements in MySQL
2018-01-24, 1199👍, 0💬
Popular Posts:
Why I Can Not Enter 0.001 Second in DATETIME values in SQL Server Transact-SQL? If you enter millise...
What Are the Differences between DATE and TIMESTAMP in Oracle? The main differences between DATE and...
How To Verify a User name with SQLCMD Tool in SQL Server? The quickest way to verify a user name in ...
Can Date and Time Values Be Converted into Integers in SQL Server Transact-SQL? Can date and time va...
Where to find Oracle database server tutorials? Here is a collection of tutorials, tips and FAQs for...