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, 4453👍, 0💬
Popular Posts:
What is the purpose of finalization? The purpose of finalization is to give an unreachable object th...
Are risk constant through out the project ? * Never say that risk is high through out the project. R...
Does .NET support UNICODE and how do you know it supports? Yes .NET definitely supports UNICODE. Try...
If cookies are not enabled at browser end does form Authentication work? No, it does not work.
What Are Named Parameters? - Oracle DBA FAQ - Creating Your Own PL/SQL Procedures and Functions Name...