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 mysql default database?

1008

---

What are all the Common SQL Function?

1140

---

Is mysql same as mariadb?

911

---

What does innodb stand for?

977

---

List some comparisons operators used in mysql?

992

---

How do I install the latest mysql on ubuntu?

994

---

Can you tell the difference between $message and $$message?

975

---

How can you retrieve a portion of any column value by using a select query?

924

---

How do I free up space in mysql?

918

---

What is the difference between sql and mysql and oracle?

896

---

Which is faster innodb or myisam?

1059

---

How do I zip a file in mysql?

986

---

Can I use mariadb instead of mysql?

927

---

How do I truncate all tables in mysql?

988

---

How do I find mysql version in mysql workbench?

943

---