List:General Discussion« Previous MessageNext Message »
From:Thimble Smith Date:April 19 1999 8:40pm
Subject:Re: LOAD DATA Question
View as plain text  
On Mon, Apr 19, 1999 at 10:34:01PM +0200, Balthasar Indermuehle wrote:
> what can I do to have the new records just appended, the first
> column ignored and inserted as defined in the table, namely as
> auto_number?

sed -e 's/^[^	]/\\N/' < data_file | mysql --options dbname

Tim
Thread
LOAD DATA QuestionBalthasar Indermuehle20 Apr
  • Re: LOAD DATA QuestionThimble Smith20 Apr
    • Re: LOAD DATA QuestionThimble Smith20 Apr
  • Re: LOAD DATA QuestionEduardo Arino de la Rubia20 Apr
  • Re: LOAD DATA QuestionPaul DuBois20 Apr