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 Insert a New Row into a Table
How To Insert a New Row into a Table? - Oracle DBA FAQ - Understanding SQL DML Statements
✍: FYIcenter.com
To insert a new row into a table, you should use the INSERT INTO statement with values specified for all columns as shown in the following example:
INSERT INTO fyi_links VALUES (101, 'http://dev.fyicenter.com', NULL, 0, '30-Apr-2006'); 1 row created. SELECT * FROM fyi_links; ID URL NOTES COUNTS CREATED ----- ------------------------ -------- ------- --------- 101 http://dev.fyicenter.com NULL 0 30-Apr-06
2007-04-21, 4661👍, 0💬
Popular Posts:
Describe different elements in Static Chart diagrams ? Package: - It logically groups element of a U...
What is the difference between CALL_FORM, NEW_FORM and OPEN_FORM? CALL_FORM: start a new form and pa...
What is page thrashing? Some operating systems (such as UNIX or Windows in enhanced mode) use virtua...
How do we get the current culture of the environment in windows and ASP.NET? “CultureInfo.CurrentCul. ..
How To Get the Last ID Assigned by MySQL? - MySQL FAQs - Managing Tables and Running Queries with PH...