Create a Test Table with Test Data in MySQL

Q

How To Create a Testing Table with Test Data in MySQL?

✍: FYIcenter.com

A

If you want to follow the tutorial exercises presented in this collection, you need to create a testing table and insert some test data, as shown in the following sample script:

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)

mysql> INSERT INTO fyi_links VALUES (101, 
  'dev.fyicenter.com', 
  NULL,
  0,
  '2006-04-30');
Query OK, 1 row affected, 1 warning (0.01 sec)

mysql> INSERT INTO fyi_links VALUES (102, 
  'dba.fyicenter.com', 
  NULL,
  0,
  DEFAULT);
Query OK, 1 row affected, 1 warning (0.01 sec)

mysql> INSERT INTO fyi_links (url, id) 
  VALUES ('sqa.fyicenter.com', 103);
Query OK, 1 row affected, 1 warning (0.01 sec)

You should keep this table and its data to practice other tutorial exercises presented in this collection.

 

SELECT Query Statements with GROUP BY in MySQL

⇒⇒MySQL Database Tutorials

2016-10-17, 158👍, 0💬