Adding More Data to the Test Table in MySQL

Q

How To Add More Data to the Testing Table in MySQL?

✍: 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)

 

SELECT Query Statements with GROUP BY in MySQL

⇒⇒MySQL Database Tutorials

2017-11-02, 261👍, 0💬