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, 4632👍, 0💬
Popular Posts:
How To Create Nested Tables? - XHTML 1.0 Tutorials - Understanding Tables and Table Cells You can cr...
How do we access attributes using “XmlReader”? Below snippets shows the way to access attributes. Fi...
Can a variable be both const and volatile? Yes. The const modifier means that this code cannot chang...
What is Service Oriented architecture? “Services” are components which expose well defined interface...
Can event’s have access modifiers ? Event’s are always public as they are meant to serve every one r...