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, 1375🔥, 0💬
Popular Posts:
Where to find answers to frequently asked questions on Storage Engines: MyISAM, InnoDB and BDB in My...
What Is Oracle in Oracle? Oracle is a company. Oracle is also a database server, which manages data ...
What are single-byte character string data types supported in SQL Server Transact-SQL? Single-byte c...
How To Use GO Command in "sqlcmd" in SQL Server? "sqlcmd" is a command line client application to ru...
How To Get the Definition of a User Defined Function Back in SQL Server Transact-SQL? If you want ge...