00 sec)
> >
> > insert into test (a,b) values(1,1);
> > insert into test (a,b) values(1,1);
> > ERROR 1062: Duplicate entry '1-1' for key 1
> >
> >>Fix:
> >>
> > No fix.
> >
> >>Submitter-Id:
> >>
est (a,b) values(1,1);
insert into test (a,b) values(1,1);
ERROR 1062: Duplicate entry '1-1' for key 1
>Fix:
No fix.
>Submitter-Id:
>Originator:Jon Barker
>Organization:
>MySQL support: none
>Synopsis: NULLs don't work correctly in unique ind
Hi,
>I'm having a problem when using Load Data where the single and double quotes
>in the text file are getting nuked. It appears that the escape character is
>not being respected but I'm not sure why. It is also knocking out
>characters near the quotes.
Your single and double quotes come out
>I came up with the following sql statement, but I still don't see any
>records that are missing in table active_monitors, I assume i am abusing the
>'join syntax' but I don't know how to fix it:
>
>select D.monitor, D.endpoint ,A.monitor
>from endpoints_defined_monitors D
>left outer join active
Convert the datetime column to nullable? Not really a fix since it breaks the
schema.
>Submitter-Id:
>Originator:Jon Barker
>Organization:
Ingenta PLC
>MySQL support: none
>Synopsis: LEFT OUTER JOIN where not null datetime column is null fails.
>Severity:
n
mysql Ver 11.15 Distrib 3.23.41, for pc-linux-gnu (i686) (AMD 1 CPU)
and
mysql Ver 11.15 Distrib 3.23.39, for pc-linux-gnu (i686) (Intel SMP 2 CPU)
Thanks for any assistance,
Jon Barker
-
Before posting, please check:
htt
