> 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 avo
Hi everybody,
I've got a MEDIUMBLOB column in a table, where I want values to be unique. So
I made it UNIQUE.
When my program wants to enter a value, it first does a select * from table
where column =x in order to see if x already exists, if not, it does an
insert. Now the interesting point:
If
