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, 1460🔥, 0💬
Popular Posts:
How To Generate CREATE VIEW Script on an Existing View in SQL Server? If you want to know how an exi...
How To Fix the INSERT Command Denied Error in MySQL? The reason for getting the "1142: INSERT comman...
Where to find answers to frequently asked questions on PHP Connections and Query Execution for MySQL...
What Is "mysqld" in MySQL? "mysqld" is MySQL server daemon program which runs quietly in background ...
How To Convert a Unicode Strings to Non-Unicode Strings in SQL Server Transact-SQL? Since Unicode ch...