Creating a Test Table in MySQL

Q

How To Create a Testing Table in MySQL?

✍: FYIcenter.com

A

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.

 

⇒INSERT, UPDATE and DELETE Statements in MySQL

⇒⇒MySQL Database Tutorials

2018-01-24, 408👍, 0💬

General MySQL Oracle SQL Server