Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


How can we change the name and data type of a column of a
table?

Answers were Sorted based on User's Feedback



How can we change the name and data type of a column of a table?..

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

How can we change the name and data type of a column of a table?..

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

How can we change the name and data type of a column of a table?..

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

How can we change the name and data type of a column of a table?..

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

How can we change the name and data type of a column of a table?..

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

How can we change the name and data type of a column of a table?..

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

How can we change the name and data type of a column of a table?..

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

How can we change the name and data type of a column of a table?..

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

How can we change the name and data type of a column of a table?..

Answer / abhishek

ALTER TABLE `<tablename>` CHANGE `<old column>` `<new
column>` new datatype( length )

Is This Answer Correct ?    5 Yes 15 No

Post New Answer



More MySQL Interview Questions

How does mysql store binary data?

0 Answers  


Write a query to display current date and time?

0 Answers  


what is the Dynamic management views? where can you use?

1 Answers   ACC,


Is sqlite faster than mysql?

0 Answers  


In which language it is written?

0 Answers  






how you will Create a database on the mysql server with unix shell.

0 Answers  


How many mysql connections can handle?

0 Answers  


how to dump all databases for backup. Backup file is sql commands to recreate all db's.

0 Answers  


How to control the max size of a heap table?

0 Answers  


What is mysql shell?

0 Answers  


write a command to view the content of the table

0 Answers  


What is full text indexing in mysql?

0 Answers  






Categories