Answer Posted / 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

What is the use of mysql workbench?

1060

---

What is InnoDB?

1157

---

Is mysql running ubuntu?

1057

---

What are the 'mysql' command line options?

1048

---

What is MySQL?

1051

---

What is the use of mysqli_query?

929

---

How do I truncate all tables in mysql?

1039

---

using primary can we relate two table, with out foreign key?

2764

---

What is relational database in mysql?

977

---

What is a table schema?

1044

---

How do I start mysql database?

1027

---

What is row level locking?

989

---

Do you need a license for mysql?

987

---

how to take mysql database backup?

1126

---

What is logs in mysql?

949

---