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 Create a Testing Table with Test Data
How To Create a Testing Table with Test Data? - MySQL FAQs - SQL SELECT Query Statements with GROUP BY
✍: FYIcenter.com
If you want to follow the tutorial exercises presented in this collection, you need to create a testing table and insert some test data, as shown in the following sample script:
mysql> CREATE TABLE fyi_links (id INTEGER PRIMARY KEY, url VARCHAR(80) NOT NULL, notes VARCHAR(1024), counts INTEGER, created TIMESTAMP DEFAULT CURRENT_TIMESTAMP()); Query OK, 0 rows affected (0.08 sec) mysql> INSERT INTO fyi_links VALUES (101, 'dev.fyicenter.com', NULL, 0, '2006-04-30'); Query OK, 1 row affected, 1 warning (0.01 sec) mysql> INSERT INTO fyi_links VALUES (102, 'dba.fyicenter.com', NULL, 0, DEFAULT); Query OK, 1 row affected, 1 warning (0.01 sec) mysql> INSERT INTO fyi_links (url, id) VALUES ('sqa.fyicenter.com', 103); Query OK, 1 row affected, 1 warning (0.01 sec)
You should keep this table and its data to practice other tutorial exercises presented in this collection.
2007-05-11, 4798👍, 0💬
Popular Posts:
How Do You Uninstall JUnit Uninstalling JUnit is easy. Just remember these: Delete the directory tha...
What is the difference between "printf(...)" and "sprintf(...)"? sprintf(...) writes data to the cha...
How can JavaScript make a Web site easier to use? That is, are there certain JavaScript techniques t...
How To Calculate Expressions with SQL Statements? - MySQL FAQs - Introduction to SQL Basics There is...
what is a service contract, operation contract and Data Contract? - part 1 In the below sample we ha...