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, 1891🔥, 0💬
Popular Posts:
How To Break Query Output into Pages in MySQL? If you have a query that returns hundreds of rows, an...
What Are the Differences between DATE and TIMESTAMP in Oracle? The main differences between DATE and...
How To Convert Numeric Values to Character Strings in MySQL? You can convert numeric values to chara...
Where to find answers to frequently asked questions on PHP Connections and Query Execution for MySQL...
How To Break Query Output into Pages in MySQL? If you have a query that returns hundreds of rows, an...