Can't INSERT on diferent MySQL version
Posted by: Eduardo Luis
Date: November 24, 2020 08:38AM

Hi,

I have a long webapplication written a few years ago.
It's running "mysql Ver 14.14 Distrib 5.5.49"

Now I have a new server to start migrate and it's running mysql Ver 14.14 Distrib 5.7.32

My first problem is... My database has tables without "Predefined values" and if I INSERT something on the older server, even without values it, inserts and that's ok.

Now... with empty values I got the following error:
ERROR 1366 (HY000): Incorrect integer value: '' for column 'num_ute' at row 1

The problem is:
I have thousands and thousands of code lines... thousand of INSERTS...
I have many tables...

How can I avoid this and MySQL inserts the value anyway?!

Thank you.

Options: ReplyQuote


Subject
Written By
Posted
Can't INSERT on diferent MySQL version
November 24, 2020 08:38AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.