You can add a column with a simple
"ALTER TABLE tablename ADD COLUMN columnname
columndefinition AFTER existingcolumnname;
What could be simpler? : )
On Wednesday 21 May 2003 05:50 pm,
> I am new to mysql and have a quasi-design question.
> I have a php site which uses a few mysql tables for data.
> It is becoming clear that some of these tables need
> extra columns (for data items I originally overlooked).
> What I am wondering is:
> Is it easier to add columns to an existing table (which
> already has lots of rows, but not a huge number)?
> Is it easier to create a new table which uses the first
> table's id/key/whatever to correlate the new data with
> the existing table?