How To Add More Data to the Testing Table

Q

How To Add More Data to the Testing Table? - MySQL FAQs - SQL SELECT Query Statements with GROUP BY

✍: FYIcenter.com

A

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> UPDATE fyi_links SET tag = 'DEV' WHERE id = 101;
mysql> UPDATE fyi_links SET tag = 'DBA' WHERE id = 102;
mysql> UPDATE fyi_links SET tag = 'SQA' WHERE id = 103;

mysql> INSERT INTO fyi_links VALUES (104, 
   'www.mysql.com', '', '0', '2006-01-01', 'DBA');
mysql> INSERT INTO fyi_links VALUES (105,
   'www.oracle.com', '', '0', '2005-01-01', 'DBA');
mysql> INSERT INTO fyi_links VALUES (106,
   'www.php.net', '', '0', '2004-01-01', 'DEV');
mysql> INSERT INTO fyi_links VALUES (107, 
   'www.winrunner.com', '', '0', '2003-01-01', 'SQA');

mysql> UPDATE fyi_links SET counts = FLOOR(RAND()*10);

mysql> SELECT id, url, counts, DATE(created), tag 
   FROM fyi_links;
+-----+-------------------+--------+---------------+------+
| id  | url               | counts | DATE(created) | tag  |
+-----+-------------------+--------+---------------+------+
| 101 | dev.fyicenter.com |      4 | 2006-04-30    | DEV  |
| 102 | dba.fyicenter.com |      3 | 2006-07-01    | DBA  |
| 103 | sqa.fyicenter.com |      6 | 2006-07-01    | SQA  |
| 104 | www.mysql.com     |      1 | 2006-01-01    | DBA  |
| 105 | www.oracle.com    |      7 | 2005-01-01    | DBA  |
| 106 | www.php.net       |      4 | 2004-01-01    | DEV  |
| 107 | www.winrunner.com |      8 | 2003-01-01    | SQA  |
+-----+-------------------+--------+---------------+------+
7 rows in set (0.00 sec)

2007-05-11, 4482👍, 0💬

How To Select All Columns of All Rows from a Table
How To Select All Columns of All Rows from a Table? - MySQL FAQs - SQL SELECT Query Statements with GROUP BY 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 column... 2007-05-11, 5886👍, 0💬

How To Sort Output in Descending Order
How To Sort Output in Descending Order? - MySQL FAQs - SQL SELECT Query Statements with GROUP BY If you want to sort a column in descending order, you can specify the DESC keyword in the ORDER BY clause. The following SELECT statement first sorts the "tag" in descending order, then sorts the "counts... 2007-05-11, 5069👍, 0💬

How To Sort the Query Output
How To Sort the Query Output? - MySQL FAQs - SQL SELECT Query Statements with GROUP BY 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 ... 2007-05-11, 4742👍, 0💬

How To Use SELECT Statement to Count the Number of Rows
How To Use SELECT Statement to Count the Number of Rows? - MySQL FAQs - SQL SELECT Query Statements with GROUP BY If you want to count the number of rows, you can use the COUNT(*) function in the SELECT clause. The following tutorial exercise shows you some good example: mysql> SELECT COUNT(*) FROM ... 2007-05-11, 4729👍, 0💬

Can the Query Output Be Sorted by Multiple Columns
Can the Query Output Be Sorted by Multiple Columns? - MySQL FAQs - SQL SELECT Query Statements with GROUP BY You can specifying multiple columns in the ORDER BY clause as shown in the following example statement, which returns employees' salaries sorted by department and salary value: mysql> SELECT ... 2007-05-11, 4484👍, 0💬

How To Add More Data to the Testing Table
How To Add More Data to the Testing Table? - MySQL FAQs - SQL SELECT Query Statements with GROUP BY 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_l... 2007-05-11, 4483👍, 0💬

How To Select Some Columns from a Table
How To Select Some Columns from a Table? - MySQL FAQs - SQL SELECT Query Statements with GROUP BY 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 tabl... 2007-05-11, 4442👍, 0💬

How To Create a Testing Table with Test Data
How To Create a Testing Table with Test Data? - MySQL FAQs - SQL SELECT Query Statements with GROUP BY 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... 2007-05-11, 4437👍, 0💬

Can SELECT Statements Be Used on Views
Can SELECT Statements Be Used on Views? - MySQL FAQs - SQL SELECT Query Statements with GROUP BY Select (query) statements can be used on views in the same way as tables. The following tutorial exercise helps you creating a view and running a query statement on the view: mysql> CREATE VIEW myLinks A... 2007-05-11, 4373👍, 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.