4 Mar
2010
4 Mar
'10
8:29 a.m.
*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.
--
Rohit Kalhans
4 Mar
4 Mar
8:43 a.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
5308
days inactive
5308
days old
1 comments
2 participants
participants (2)
-
Marc Delisle -
Rohit Kalhans