Home Discussion Discuss: SQL Alter Table Add Multiple Columns

  • SQLDewashish Kuamr pal October 8, 2012 at 3:03 PM

    sql> select *from Dewashish84; E_ID E_NAME E_EDUCATION ---------- ------------- --------------- 100 MCA 101 MSCIT 145 BA 103 MTECH 5 BTECH SQL> update Dewashish84 set E_NAME= decode(E_EDUCATION,'MCA','dewa','MSCIT','Raj','BA','mohan', 'MTECH','ram'); 5 rows updated. SQL> select *from Dewashish84; E_ID E_NAME E_EDUCATION ---------- ------------- --------------- 100 dewa MCA 101 Raj MSCIT 145 mohan BA 103 ram MTECH 5 Sohan BTECH SQL> alter table Dewashish84 add (e_location varchar2(10),E_salary number(4,2)); Table altered. SQL> select *from Dewashish84; E_ID E_NAME E_EDUCATION E_LOCATION E_SALARY ---------- ------------- --------------- ---------- ---------- 100 dewa MCA 101 Raj MSCIT 145 mohan BA 103 ram MTECH 5 Sohan BTECH

Post your Comment



Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
 
 
Related Articles
SQL Question

mysql alter table add multiple columns
mysql alter table add multiple columns  Hi, I have a table in database. I want to add multiple columns into existing table. What is the code for mysql alter table add multiple columns? Thanks   Hi, You can use 

Quartz Tutorials

SQL Alter Table Add Multiple Columns
SQL Alter Table Add Multiple Columns       Alter Table Add Multiple Columns in SQL... Add Multiple Columns. The SQL Query create a table 'Stu_Table' with table 

SQL Tutorial

Mysql Alter Add Multiple Columns
Mysql Alter Add Multiple Columns       Mysql Alter Add Multiple Columns is used to modify the table and add multiple columns to the specified table. Understand with Example 

SQL Tutorial

SQL Alter Table Add Multiple Columns
SQL Alter Table Add Multiple Columns       Alter Table Add Multiple Columns in SQL... Add Multiple Columns. The SQL Query create a table 'Stu_Table 

SQL Tutorial

Mysql Alter Multiple Columns
Mysql Alter Multiple Columns       Mysql Alter Multiple Columns is used to modify the table... The Tutorial illustrate an example from 'Mysql Alter Multiple Columns'. To grasp 

SQL Tutorial

SQL Alter Table
SQL Alter Table       SQL Alter Table is used to modify the existing table definition. The modification in table relates to add columns, rename column and add primary key 

SQL Tutorial

Mysql Alter Unique Key
' and add a unique multiple columns to the table 'Employee'.  mysql> ALTER TABLE Employee ADD UNIQUE (ID, EmpID) Query OK, 2 rows...;  Mysql Alter Unique is used to change the table structure and add 

SQL Question

mysql alter table add column
mysql alter table add column  Hi, What is the syntax of mysql alter table add column? Thanks   Hi, Here is mysql alter table add column example: ALTER TABLE employee ADD address VARCHAR(50); Read more at MySQL Add 

SQL Question

mysql alter table add unique constraint
mysql alter table add unique constraint  How to add mysql alter table add unique constraint in mysql table. Thanks   Hi Following query query can be used: ALTER TABLE mytable ADD CONSTRAINT uc_key1 UNIQUE 

Java Beginners

alter table add foreign key mysql
alter table add foreign key mysql  Hi, How to add foreign key in mysql using the query 'alter table add foreign key mysql' Thanks   Hi, We can use the following query: ALTER TABLE emp_address ADD FOREIGN KEY (emp_id 

SQL Question

SQL Alter Table
SQL Alter Table  What is alter table statement in sql? Can u please show me an example of SQL Alter Table?? Thanks!   ALTER TABLE... also be used to modifiy, add or deleate a column in the existing table. SQL 

Quartz Tutorials

SQL Alter Table Name
SQL Alter Table Name       SQL Alter Table Name is used to change or modify  name of the existing table. To understand how to change the name of created table in SQL 

SQL Question

alter table create index mysql
alter table create index mysql  Hi, What is the query for altering table and adding index on a table field? Thanks   Hi, Query is: ALTER TABLE account ADD INDEX (accounttype); Thanks 

JDBC Questions

all sequences to create jdbc and how can i use jtable to display a single columns or multiple columns
columns or multiple columns  i am 3rd year cs student in ethiopia. i have... scrollPane = new JScrollPane(table); panel.add(scrollPane); add(panel); } public..."); ResultSetMetaData md = rs.getMetaData(); int columns = md.getColumnCount(); for (int i 

SQL Tutorial

Mysql Alter Add Column
Mysql Alter Add Column       Mysql Alter Add Column is used to define the existing Table...'. mysql> alter table employees -> add column city varchar(30 

Programming Tutorials

Mysql Alter Table
' to the existing table. mysql> alter table employees -> add column... Mysql Alter Table       Mysql Alter Table is used to redefine the existing table. Understand 

SQL Tutorial

Mysql Alter Table Syntax
. ALTER TABLE tbl_name ADD [COLUMN] col_name column_definition... table. mysql> alter table employees -> add column... Mysql Alter Table Syntax      

Quartz Tutorials

SQL Alter View
of an SQL statement. A virtual table contains rows and columns, as same as real table. In SQL Alter View is used to modify a previous created view... SQL Alter View       

Quartz Tutorials

SQL Alter Table Primary Key
SQL Alter Table Primary Key       Alter a Table Primary Key in SQL modifies the existing table... table_name ADD PRIMARY KEY (column_name) Alter Table Primary 

SQL Tutorial

MySQL Add Column
'. ALTER TABLE employee ADD address VARCHAR(50); Now you... table. The table structure can be changed using 'Alter table' query. You can now add the new column  in a table using add  keyword in the query 

SQL Tutorial

Mysql Alter Table Identity
the records in the table. ALTER TABLE userform ADD ID INT NOT NULL AUTO_INCREMENT FIRST, ADD PRIMARY KEY (ID); After alter the table "userform"... Mysql Alter Table Identity       

SQL Tutorial

SQL Alter Table Syntax
SQL Alter Table Syntax       SQL Alter Table Syntax modifies the existing table definition...: Alter Table Name  ADD [COLUMN] col_name column_definition[FIRST 

Java-Tutorials

JDBC: Alter Table Example
new field -  sql= " ALTER TABLE student ADD location varchar(30)" You can delete the unused field- sql="ALTER TABLE student DROP... sql = "ALTER TABLE student add location varchar(30)"; st.executeUpdate(sql 

SQL Tutorial

SQL Alter Table Name
SQL Alter Table Name       SQL Alter Table Name is used to change or modify  name of the existing table. To understand how to change the name of created table in SQL 

SQL Tutorial

Mysql Alter Constraint
: The Alter Table is used to modify the table 'userform' and add ID as a Primary Key constraint. ALTER TABLE userform ADD ID INT NOT NULL AUTO_INCREMENT FIRST, ADD PRIMARY KEY (ID); After alter the table "userform" 

SQL Tutorial

Mysql Alter Rename Table
Mysql Alter Rename Table       Mysql Alter Rename Table is used to redefine and rename the existing... Alter Rename Table'. To understand this example we create a table 'employees 

MySQL

MySQL Add Column
'. Query ALTER TABLE employee ADD address VARCHAR(50); Output...; MySQL Add Column is used to add the column to the existing table. The Alter table keyword is used to modify the table structure and add  

MySQL

MySQL Add Column
Add Column is used to add the column to the existing table. The Alter table... 'address' to the existing table 'employee'. ALTER TABLE employee ADD address VARCHAR... to add the new column  in a table. Understand with Example The Tutorial 

SQL Tutorial

SQL Alter View
of an SQL statement. A virtual table contains rows and columns, as same as real table. In SQL Alter View is used to modify a previous created view... SQL Alter View       

SQL Tutorial

Mysql Alter Command
a primary key : The Alter Table is used to modify table 'tablename' and add a primary key to the column 'index_column'. ALTER TABLE tablename ADD...'. ALTER TABLE tablename ADD Column columnname type; Change 

DMCA.com