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.

⇒ Selecting All Columns of All Rows in MySQL

⇐ What Is a SELECT Query Statement in MySQL

⇑ SELECT Query Statements with GROUP BY in MySQL

⇑⇑ MySQL Database Tutorials

2017-11-05, 2716🔥, 0💬

SELECT Query Statements with GROUP BY in MySQL
Where to find answers to frequently asked questions on SELECT Query Statements with GROUP BY in MySQL? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team SELECT Query Statements with GROUP BY in MySQL. Clear answers are provided with tutorial exercises ... 2017-11-05, 2699🔥, 0💬

Deleting Multiple Rows from a Table in MySQL
How To Delete Multiple Rows from a Table in MySQL? You can delete multiple rows from a table in the same way as deleting a single row, except that the WHERE clause will match multiple rows. The tutorial exercise below deletes 3 rows from the fyi_links table: mysql> SELECT id, url, notes, coun... 2018-01-08, 2655🔥, 0💬

Select Rows with WHERE Clause in MySQL
How To Select Some Rows from a Table in MySQL? If you don't want select all rows from a table, you can specify a WHERE clause to tell the query to return only the rows that meets the condition defined in the WHERE clause. The WHERE clause condition is a normal Boolean expression. If any data from ta... 2017-11-02, 2526🔥, 0💬

Deleting an Existing Row from a Table in MySQL
How To Delete an Existing Row from a Table in MySQL? If you want to delete an existing row from a table, you can use the DELETE statement with a WHERE clause to identify that row. Here is good sample of DELETE statements: mysql> INSERT INTO fyi_links (url, id) VALUES ('www.myspace.com', 301);... 2018-01-08, 2521🔥, 0💬

Sorting Query Output in MySQL
How To Sort the Query Output in MySQL? If you want the returning rows to be sorted, you can specify a sorting expression in the ORDER BY clause. The simplest sort expression is column name who's values will be sorted by. The following select statement returns rows sorted by the values in the "counts... 2017-11-02, 2484🔥, 0💬

Deleting All Rows in a Table in MySQL
How To Delete All Rows in a Table in MySQL? If you want to delete all rows from a table, you have two options: Use the DELETE statement with no WHERE clause. Use the TRUNCATE TABLE statement. The TRUNCATE statement is more efficient the DELETE statement. The tutorial exercise shows you a good exampl... 2018-01-08, 2465🔥, 0💬

Selecting All Columns of All Rows in MySQL
How To Select All Columns of All Rows from a Table in MySQL? The simplest query statement is the one that selects all columns of all rows from a single table: "SELECT * FROM tableName;". The (*) in the SELECT clause tells the query to return all columns. The missing WHERE clause tells the query to r... 2017-11-05, 2302🔥, 0💬

Adding More Data to the Test Table in MySQL
How To Add More Data to the Testing Table in MySQL? If you want to continue with other tutorial exercises in this FAQ collection, you need to add more data to the testing table. Follow the script below to add a new column and: mysql> ALTER TABLE fyi_links ADD COLUMN tag VARCHAR(8); mysql&... 2017-11-02, 2227🔥, 0💬

Selecting Columns in a Query in MySQL
How To Select Some Columns from a Table in MySQL? If you want explicitly tell the query to return some columns, you can specify the column names in the SELECT clause. The following select statement returns only two columns, "id" and "url" from the table "fyi_links": mysql> SELECT id, url FROM... 2017-11-05, 2191🔥, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.