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_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)