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 an example of a delimiter?

930

---

How do you know the version of your mysql server?

1170

---

How many mysql connections can handle?

891

---

How you will Show unique records.

1026

---

Is mysql free for commercial use?

916

---

How can you count the total number of records of any table?

920

---

Does facebook still use mysql?

931

---

How do I change mysql password?

1014

---

what is database black box testing? : Mysql dba

1118

---

What are queries used for?

951

---

What is regexp?

1133

---

What is the maximum no of columns a table can have?

907

---

How do I install mysql?

900

---

What are the different mysql database engines?

1160

---

What is latest version of mysql?

1022

---