MySQL Forums
Forum List  »  Data Recovery

Re: Modify column to auto_increment
Posted by: Peter Brawley
Date: August 16, 2020 07:40AM

> Incorrect integer value: '' for column 'chat_id'

Yes, as the manual says, a space char or an empty string is an invalid int value. To enable auto_inc setting of that column, best leave it off the list of input columns, or select time,endtime,closed,NULL,... into your outfile.



Edited 1 time(s). Last edit at 08/16/2020 12:41PM by Peter Brawley.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Modify column to auto_increment
73
August 16, 2020 07:40AM


Sorry, only registered users may post in this forum.

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.