Re: DBI: Add column to mysql table

2008-12-07 Thread Chas. Owens
On Sat, Dec 6, 2008 at 20:23, hotkitty <[EMAIL PROTECTED]> wrote: > Hi, > > I am using DBI to add a column to my existing table, goodtable. W/ a > phpmyadmin I can add a column w/ a numeric or nonnumeric label. Using > perl DBI, I can only add a column w/ a nonnumeric label, as follows: > > $dbh->d

DBI: Add column to mysql table

2008-12-07 Thread hotkitty
Hi, I am using DBI to add a column to my existing table, goodtable. W/ a phpmyadmin I can add a column w/ a numeric or nonnumeric label. Using perl DBI, I can only add a column w/ a nonnumeric label, as follows: $dbh->do("ALTER TABLE goodtable ADD testname VARCHAR( 250 ) NULL"); >is a non