modifying columns in a table 1

[simanek]

I want to add a column to an existing table. I've looked high and low and have not seen anything mentioning the modification of a table that already exists. Is it even possible? Mike
~~~~
simanek@uiuc.edu
"It's a Swingline!"
~~~~

 

[darwin101]

I think this can be done in Oracle 8i.. I don't think it's available before that.

 

[redlam]

what database are you using? if you are using MS SQL Server, you can add a column using the GUI in Enterprise Manager. simply right click on the table, select 'Design Table' and add your column...

 

[simanek]

I'm using MySQL (3.23.38) on solaris 7.

Thanks. Mike
~~~~
simanek@uiuc.edu
"It's a Swingline!"
~~~~

 

[karluk]

The way to do this in most versions of SQL is with the command

alter table your_table add column new_column_name char(1)

I found a link which indicates that the same syntax will work in Mysql. Please check it out for details.

http://www.analysisandsolutions.com/code/mybasic.htm