Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
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, 4669👍, 0💬
Popular Posts:
How To Merge Values of Two Arrays into a Single Array? - PHP Script Tips - PHP Built-in Functions fo...
Advantages of a macro over a function? Macro gets to see the Compilation environment, so it can expa...
What is Native Image Generator (Ngen.exe)? The Native Image Generator utility (Ngen.exe) allows you ...
Which bit wise operator is suitable for turning off a particular bit in a number? The bitwise AND op...
What is the FP per day in your current company?