Insert column into existing table

[Steu Mann]

I am just learning SQL and am stumped. How do I add a new colum called PLANES to an existing table called TRAVEL? I tried this syntax with no success.... insert into TRAVEL values ('PLANES&#39 ......

Thanks in advance for your help!

[Ray Miao]

Use alter table statement. You use insert statement to insert data only into table.


------------
Steu Mann at 3/10/00 9:40:01 AM

I am just learning SQL and am stumped. How do I add a new colum called PLANES to an existing table called TRAVEL? I tried this syntax with no success.... insert into TRAVEL values ('PLANES&#39 ......

Thanks in advance for your help!

[Craig]

To add a column, use ALTER TABLE.

What you are doing is trying to insert data into an existing table.


------------
Steu Mann at 3/10/00 9:40:01 AM

I am just learning SQL and am stumped. How do I add a new colum called PLANES to an existing table called TRAVEL? I tried this syntax with no success.... insert into TRAVEL values ('PLANES&#39 ......

Thanks in advance for your help!