Categories:
.NET (961)
C (387)
C++ (185)
CSS (84)
DBA (8)
General (31)
HTML (48)
Java (641)
JavaScript (220)
JSP (109)
JUnit (31)
MySQL (297)
Networking (10)
Oracle (562)
Perl (48)
Perl (9)
PHP (259)
PL/SQL (140)
RSS (51)
Software QA (28)
SQL Server (5)
Struts (20)
Unix (2)
Windows (3)
XHTML (199)
XML (59)
Other Resources:
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
✍: 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)
2007-05-11, 4482👍, 0💬
Popular Posts:
What are the high-level thread states? The high-level thread states are ready, running, waiting, and...
Which bit wise operator is suitable for turning off a particular bit in a number? The bitwise AND op...
How To Wirte a Simple JUnit Test Class? This is a common test in a job interview. You should be able...
What Information Is Needed to Connect SQL*Plus an Oracle Server? - Oracle DBA FAQ - Introduction to ...
How can you write a loop indefinitely? Two examples are listed in the following code: for(;;) { ... ...