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

How do I create a mysql database?

974

---

What is max connection in mysql?

989

---

How internally data stores in MyISAM and INNODB table types?

2805

---

Where is mysql data stored linux?

1065

---

Can you tell how to find the number of rows in a resultset using php?

958

---

What is row level locking in access?

937

---

Table - Products has number of products as below Productid ProductName 1 iPhone 2 iPad 3 BlackBerry Table - SalesPersonProduct has the below records Salespersonid productid S1 1 S1 2 S1 3 S2 1 S3 2 Write a SQL query that returns the total number of sold products

2884

---

What is the use of pdo?

1002

---

How do I enable mysqli extension?

1068

---

Is mysql query case sensitive?

1017

---

What is csv?

1018

---

How do I drop a database in mysql?

1178

---

What is blob in mysql?

1090

---

How do I insert multiple rows in a table?

952

---

What is mysqlcommand?

1065

---