4 Mar
2010
4 Mar
'10
4:43 p.m.
Rohit Kalhans a écrit :
*Insert ignore - ID: 2924956*
Can an option be added to the insert page to use "insert ignore"
instead of
"insert".
Perhaps the drop-down that has the "Insert a new row" option could also
have "Insert ignore a new row".
In the above citation from the to-do list what does* Insert ignore*
suppose to do?
I mean we already have a check-box for ignoring any unused field while
inserting rows.
From http://dev.mysql.com/doc/refman/5.1/en/insert.html :
"If you use the IGNORE keyword, errors that occur while executing the
INSERT statement are treated as warnings instead. For example, without
IGNORE, a row that duplicates an existing UNIQUE index or PRIMARY KEY
value in the table causes a duplicate-key error and the statement is
aborted. With IGNORE, the row still is not inserted, but no error is
issued. "
--
Marc Delisle
http://infomarc.info