[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql
Subject:    Re: find a particular record.
From:       "Alex Greg" <alex.greg () gmail ! com>
Date:       2007-06-29 7:12:12
Message-ID: 50d1fa4e0706290012p1d845620hc2f5c6b6362fd92c () mail ! gmail ! com
[Download RAW message or body]

> I am doing this to move data from one table to other and getting below
> error.
> How can check this particular record at this row number 921888 in dats_tem
> table.
>
> insert into reports1.dats1 select * from dats_tem;
>
> ERROR 1292 (22007): Incorrect datetime value: '0000-00-00 00:00:00' for
> column 'P_LAST_SOLD_DATE' at row 921888

An extremely quick and dirty solution:

mysqldump -uusername -p -t --skip-opt database_name dats_tem | grep
INSERT | head -921888 | tail -1

replacing username with your username and database_name with your
database name, of course.

-- Alex

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=mysql-marcsub@progressive-comp.com

[prev in list] [next in list] [prev in thread] [next in thread]