Re: Load Data with extra field

2001-11-12 Thread Carl Troein
M. A. Alves writes: mysql database $!#$#%$ I know the feeling. :-P On Sun, 11 Nov 2001, Michael Conley wrote: . . . even though the text files that I am importing don't have the customer number of the person who submitted it, if I know the customer number . . . Where from do

The EXTRA field

2001-09-09 Thread Ralof
Hi, I would like to use the EXTRA field for sorting and maybe caption, but I find no way of setting it. I tried like: Alter table myTable change myField myNewField varchar(255) DEFAULT 'a' EXTRA '3' But that does not work. I can not find anything in the documentation about this. Thanks