Sorry I forgot to include table-defs: ..
OK, I've got it entirely reproducible now, without giving away any
sensitive data.
No, the column-lengths are the same. But doing this has shown me that
it's something to do with the partial key on the 'email' column in the
'user' table. If you remove it,
Hi, Tom Cunningham wrote:
> I have a funny problem: I'm getting thousands of "Data Truncated"
> warnings when I insert a single row of data into a table, using an
> INSERT...SELECT.
I bet that the columns you're joining on have different sizes.
--
Matthias Urlichs | {M:U} IT Design @ m-u-it
Hi Everybody.
I have a funny problem: I'm getting thousands of "Data Truncated"
warnings when I insert a single row of data into a table, using an
INSERT...SELECT.
The funny thing is, the warning is for a column I'm not even
inserting. It's only a column that I'm doing a join on.
The query is th
