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
How To Create a Testing Table? - MySQL FAQs - Understanding SQL INSERT, UPDATE and DELETE Statements
✍: FYIcenter.com
If you want to practice DML statements, like INSERT, UPDATE and DELETE, you should create a testing table. The tutorial exercise shows you a good example:
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)
You should keep this table to practice other tutorial exercises presented in this collection.
2007-05-11, 4617👍, 0💬
Popular Posts:
What will be printed as the result of the operation below: main() { char *p1; char *p2; p1=(char *)m...
If we have the following in a Java code: String s="abc"; String s2="abc"; Then what will be output o...
How To Wirte a Simple JUnit Test Class? This is a common test in a job interview. You should be able...
How do you handle change request? Normally change request are handled by preparing an Impact analysi...
How Many Tags Are Defined in HTML 4.01? There are 77 tags defined in HTML 4.01: a abbr acronym addre...