i want to add a column in my table

Question

there is already some columns added in my table starsin.. i want to add a column address in my table starsin by using a query..

Answer 1

If this is mysql, you can do ALTER TABLE stasin ADD COLUMN <columnname> <type> <options>

Answer 2

In standard SQL, you want the alter table X add column Y ... command.

If you then want to populate the column for all existing rows, it's a simple matter of working out the query and: update X set Y = ....

---

Here's an example session which shows you the alter table add column in action (for DB2):

> CREATE TABLE XYZ (F1 INTEGER);                       
DSNE616I STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 0  

> INSERT INTO XYZ VALUES (1);                          
DSNE615I NUMBER OF ROWS AFFECTED IS 1                      
DSNE616I STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 0  

> INSERT INTO XYZ VALUES (2);                          
DSNE615I NUMBER OF ROWS AFFECTED IS 1                      
DSNE616I STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 0  

> SELECT * FROM XYZ;                                   
F1                                                
--
 1                                                
 2                                                
DSNE610I NUMBER OF ROWS DISPLAYED IS 2                     
DSNE616I STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 100

> ALTER TABLE XYZ ADD COLUMN F2 INTEGER;               
DSNE616I STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 0  

> UPDATE XYZ SET F2 = F1 + 7;                          
DSNE615I NUMBER OF ROWS AFFECTED IS 2                      
DSNE616I STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 0  

> SELECT * FROM XYZ;                                   
F1   F2                                   
--   --
 1    8                                   
 2    9                                   
DSNE610I NUMBER OF ROWS DISPLAYED IS 2                     
DSNE616I STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 100

Answer 3

See here

Code:

ALTER TABLE Sales 
ADD UnitPrice MONEY;

Output: The command(s) completed successfully. Explanation: This example adds a single field to the 'Sales' table by specifying the new field name and data type. Language(s): MS SQL Server

Answer 4

alter table <tablename> add(<coloumn name> <datatype>);

normal sql query to add a coloumn... in oracle it will work....