> Hi everybody, > my humble excuse to all I bothered with that ... mysql type mediumblob is working > perfectly, but there's another column in the tabel of type varchar > containing mostly the same values. So that's it > Stefan > > > P. S: I do the select first because I need the ID anyway. > > > > > Hi! > > > > > > First of all, MEDIUMBLOB type is case-sensitive. > > > I checked this sequence and everything worked as > > > expected. I think you have a mistake in your table. > > > What does "SHOW CREATE TABLE table" give? > > > Second, there is no needs to check that the value is already > > > presents using "SELECT" just to avoid an attempt of double > > > key value inserting. It is safe to insert without selecting. > > > After inserting you have just to check that really happened, > > > either record was inserted or error happened. > > > Why do you want to do iy
--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php