Home >> FAQs/Tutorials >> MySQL Tutorials
MySQL Tutorial - Creating a Test Table
(Continued from previous topic...)
How To Create a Testing Table?
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,
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.
(Continued on next topic...)
- What Are DML Statements?
- How To Create a Testing Table?
- How To Insert a New Row into a Table?
- How To Specify Default Values in INSERT Statement?
- How To Omit Columns with Default Values in INSERT Statement?
- What Happens If Unique Value Constraints Are Violated?
- How To Insert Multiple Rows with One INSERT Statement?
- How To Update Values in a Table?
- How To Update Column Values on Multiple Rows?
- How To Use Existing Column Values in the SET Clause?
- Is the Order of Columns in the SET Clause Important?
- How To Use Values from Other Tables in UPDATE Statements?
- What Happens If the UPDATE Subquery Returns No Rows?
- What Happens If the UPDATE Subquery Returns Multiple Rows?
- How To Delete an Existing Row from a Table?
- How To Delete Multiple Rows from a Table?
- How To Delete All Rows in a Table?