Hello,

I am trying to update two fields of a table that are a composed foreign
key to another table. These fields cant be updated with this kind of
warning:

 Warning | 1292 | Truncated incorrect DOUBLE value: 'A05'

Both tables are InnoDB and I have tried with all types of constraints,
ON UPDATE CASCADE, SET NULL and NO ACTION, as foreign key constraints of
the table that I want to update.

Any help or idea of how can I solve this problem?

Thank you very much in advance,
Alicia


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to