How can we change the name and data type of a column of a
table?
Answers were Sorted based on User's Feedback
Answer / m. ravindar
To Change DataType of Column:
Sy: Alter Table <Table Name> Modify <ColumnName> <DataType>;
Ex: Alter Table Test Modify EmpId varchar(5);
Is This Answer Correct ? | 63 Yes | 12 No |
Answer / ashish
o Change DataType of Column:
Sy: Alter Table <Table Name> Modify <ColumnName> <DataType>;
Ex: Alter Table Test Modify EmpId varchar(5);
Is This Answer Correct ? | 10 Yes | 4 No |
Answer / guru
You can change the column data type using this query:
Alter table table_name modify column_name datatype(length)
For example:
Alter table user modify name char(30)
You can change column name using this query:
Alter table table_name change old_column_name
new_column_name datatype(length)
For example:
Alter table user change user user_name char(30)
If you want to change column name and data type in single
query, then you use this query:
Alter table table_name change old_column_name
new_column_name new_datatype(10)
For example:
Alter table user change name user_name char(30)
For more details visit,
http://www.phponwebsites.com/2013/12/mysql-change-column-name.html
(for change column name)
http://www.phponwebsites.com/2013/12/mysql-change-column-datatype.html(for
change column datatype)
Is This Answer Correct ? | 6 Yes | 0 No |
Answer / nithya
To change the name of the column:
ALTER TABLE TABLENAME RENAME COLUMN OLD_COLUMN_NAME TO
NEW_COLUMN_NAME;
eg: alter table employee rename column emp_name to ename;
To change the datatype of a column:
ALTER TABLE TABLENAME MODIGY COLUMN_NAME NEW_DATA_TYPE;
eg: alter table employee modify ename varchar(50);
NOTE: u cannot modify column of a datatype from larger value
to smaller value.U can do it only if there is no data in ur
column.
eg: alter table employ_detail modify emp_addr varchar(5);
ORA-01441: cannot decrease column length because some value
is too big
alter table employ_detail modify emp_id number(2)
ORA-01440: column to be modified must be empty to decrease
precision or scale
Is This Answer Correct ? | 9 Yes | 4 No |
Answer / aftab alam
to add new columns in databases
alter table <table name> add column <column name> datatype;
Is This Answer Correct ? | 2 Yes | 1 No |
Answer / szsad
excuse mr pls
ALTER TABLE products ALTER COLUMN price TYPE numeric
(10,2);
uyah nanhi vhalta hai
Is This Answer Correct ? | 3 Yes | 3 No |
Answer / yogesh verma
Hi This is yOgEsH....!!
By this query we can change the data type of particular column :
ALTER TABLE products ALTER COLUMN price TYPE numeric(10,2);
Is This Answer Correct ? | 7 Yes | 8 No |
Answer / m. ravindar
To Change Name of Column:
Sy: Alter Table <Table Name> Change <Old ColumnName> <New
ColumnName>;
Ex: Alter Table Test Change EmpId EID varchar(5);
Is This Answer Correct ? | 17 Yes | 19 No |
Answer / abhishek
ALTER TABLE `<tablename>` CHANGE `<old column>` `<new
column>` new datatype( length )
Is This Answer Correct ? | 5 Yes | 15 No |
What is striped backup
What is mysql community server?
how to take mysql database backup?
What's the latest version of mysql?
What is difference between mongodb and mysql?
Why mysql is open source?
What is a simple query?
What is default password for mysql?
How to see the create table statement of an existing table?
How to save images in MySQL?
How do you create a primary key?
How do I find mysql version in mysql workbench?