RE: Load data line end problem

More on this.

I have the solution and it is very simple. I had to remove the quotes from
around the numbers in the data. Double quotes at least are no good. 

With those gone the query worked very well. And it works without escaping
the quotes within the text file or with those quotes escaped. (This this may
because I used PHPMyAdmin to enter the query - on command line the result
may be different and the escape may be needed).

Thanks again for responses which helped explore various possibilities.

I have a follow up question   -  I want to add a timestamp field to show
when the data is entered and would like it to set to NOW() for each data row
as it is entered.  How do I write that in the import data file so that the
timestamp sets? I tried writing NOW() in the appropriate field space in the
file but it was ignored.

Adrian




-- 
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:    http://lists.mysql.com/[email protected]