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 Omit Columns with Default Values in INSERT Statement
How To Omit Columns with Default Values in INSERT Statement? - MySQL FAQs - Understanding SQL INSERT, UPDATE and DELETE Statements
✍: FYIcenter.com
If you don't want to specify values for columns that have default values, or you want to specify values to columns in an order different than how they are defined, you can provide a column list in the INSERT statement. If a column is omitted in the column, MySQL applies 3 rules:
The following tutorial exercise gives you some good examples:
mysql> INSERT INTO fyi_links (url, id) VALUES ('sqa.fyicenter.com', 103); Query OK, 1 row affected, 1 warning (0.01 sec) mysql> INSERT INTO fyi_links (id) VALUES (110); Query OK, 1 row affected, 1 warning (0.06 sec) mysql> INSERT INTO fyi_links (url) VALUES ('www.fyicenter.com'); Query OK, 1 row affected, 1 warning (0.00 sec) mysql> SELECT id, url, notes, counts, DATE(created) FROM fyi_links; +-----+-------------------+-------+--------+---------------+ | id | url | notes | counts | DATE(created) | +-----+-------------------+-------+--------+---------------+ | 101 | dev.fyicenter.com | NULL | 0 | 2006-04-30 | | 102 | dba.fyicenter.com | NULL | 0 | 2006-07-01 | | 103 | sqa.fyicenter.com | NULL | NULL | 2006-07-01 | | 110 | | NULL | NULL | 2006-07-01 | | 0 | www.fyicenter.com | NULL | NULL | 2006-07-01 | +-----+-------------------+-------+--------+---------------+ 5 rows in set (0.00 sec)
2007-05-11, 5107👍, 0💬
Popular Posts:
How To Create an Add-to-Google-Reader Button on Your Website? - RSS FAQs - Adding Your Feeds to RSS ...
What metrics will you look at in order to see the project is moving successfully? Most metric sets d...
How To Return Top 5 Rows? - MySQL FAQs - SQL SELECT Statements with JOIN and Subqueries If you want ...
How To Call a Sub Procedure? - Oracle DBA FAQ - Creating Your Own PL/SQL Procedures and Functions To...
What is NullPointerException and how to handle it? When an object is not initialized, the default va...