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 Specify Default Values in INSERT Statement
How To Specify Default Values in INSERT Statement? - Oracle DBA FAQ - Understanding SQL DML Statements
✍: FYIcenter.com
If a column is defined with a default value in a table, you can use the key word DEFAULT in the INSERT statement to take the default value for that column. The following tutorial exercise gives a good example:
INSERT INTO fyi_links VALUES (102, 'http://dba.fyicenter.com', NULL, 0, DEFAULT); 1 row created. SELECT * FROM fyi_links; ID URL NOTES COUNTS CREATED ----- ------------------------ -------- ------- --------- 101 http://dev.fyicenter.com NULL 0 30-Apr-06 102 http://dba.fyicenter.com NULL 0 07-MAY-06
2007-04-21, 4717👍, 0💬
Popular Posts:
What is CAR (Causal Analysis and Resolution)? The basic purpose of CAR is to analyze all defects, pr...
What is normalization? What are different types of normalization? It is set of rules that have been ...
Enable ASP.NET polling using “web.config” file Now that all our database side is configured in order...
what are the advantages of hosting WCF Services in IIS as compared to self hosting? There are two ma...
How do we generate strong names ? or What is use the of SN.EXE ? or How do we apply strong names to ...