Re: ERROR 1439 (42000) at line 2440: Display width out of range for column

From: Gowrishankar Pandurangan <hiiamgowri_at_gmail.com>
Date: Sun, 17 Dec 2017 22:30:17 -0800 (PST)
Message-ID: <3c615bcb-9bca-42f3-95c1-a938c078d09d_at_googlegroups.com>


[Quoted] On Sunday, December 17, 2017 at 5:17:14 PM UTC+5:30, Kees Nuyt wrote:
> On Sun, 17 Dec 2017 02:37:58 -0800 (PST), hiiamgowri_at_gmail.com
> wrote:
>
> >Hello Team,
> >
> > I am getting an error
> > "ERROR 1439 (42000) at line 2440: Display width out of range for column"
> > when trying to import dump in to the MySQL5.5.
> >
> > Could you please anyone help me out to fix this issue.
> >
> > Thanks in advance!
>
> What's in line 2440 of the dump you are trying to import?
>
> awk '(NR==2440){print)' /path/to/your/dumpfile
> --
> Kees Nuyt

[Quoted] Hey Kees Nuyt ,

Thanks for your reply.

2440 : `bk_rank` bigint(320) DEFAULT NULL Received on Mon Dec 18 2017 - 07:30:17 CET

Original text of this message