Re: does mysql alert about all the duplicates?
Reindl Harald <[email protected]>
| Newsgroups | gmane.comp.db.mysql.general |
|---|---|
| Organization | the lounge interactive design |
| Message-ID | <[email protected]> |
Am 16.03.2016 um 13:38 schrieb lejeczek: > hi everybody > > just another beginner's question. > if I insert into table and there are duplicate primary keys - does mysql > alert about all the duplicates or just the first one and then > exits/abandon the rest of the insert without any alerts for potential > further duplicates? > And is this a user/config controlled behavior? only the first because it makes no sense when you attempt to make 1000000 inserts proceed the whole operation when in the second one a fatal error happens
signature.asc
(application/pgp-signature, 181 B)
-----BEGIN PGP SIGNATURE----- Version: GnuPG v2 iEYEARECAAYFAlbpVb8ACgkQhmBjz394Ank69gCgjZgQ8uuQEhTnT+Vs3SyGVGjA vPsAnRagSnRbdebaxXE3vfNgZyD3V+p9 =CFxb -----END PGP SIGNATURE-----