Don't forget to flock! DBD::CSV does this for you, but manually changing files you will have to do this yourself.
Chris ----- Original Message ----- From: "Jeff Zucker" <[EMAIL PROTECTED]> To: "Jose Blanco" <[EMAIL PROTECTED]>; "dbi-users" <[EMAIL PROTECTED]> Sent: Monday, January 07, 2002 7:30 PM Subject: Re: DBD::CSV alter statement > Jose Blanco wrote: > > > > Can I issue an alter statement to change the definition of a CSV table using DBD::CSV? > > > > For example, > > ALTER TABLE Collection ADD c varchar (20) > > DBD::CSV doesn't currently support an ALTER statement. But since CSV > files are just plain text files, you can accomplish the same thing by > adding a comma and the name of the new column to the end of the first > row of your file and thereafter DBD::CSV will recognize the column the > same way it recognizes the other columns. > > -- > Jeff
