Collections:
Adding More Data to the Test Table in MySQL
How To Add More Data to the Testing Table in MySQL?
✍: FYIcenter.com
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)
⇒ Sorting Query Output in MySQL
⇐ Select Rows with WHERE Clause in MySQL
2017-11-02, 1342🔥, 0💬
Popular Posts:
How To Generate Random Numbers with the RAND() Function in SQL Server Transact-SQL? Random numbers a...
How To Round a Numeric Value To a Specific Precision in SQL Server Transact-SQL? Sometimes you need ...
How To Get Year, Month and Day Out of DATETIME Values in SQL Server Transact-SQL? You can use DATEPA...
How To Connect ASP Pages to Oracle Servers in Oracle? If you are running Windows IIS Web server and ...
How To Convert Characters to Numbers in Oracle? You can convert characters to numbers by using the T...