Answer Posted / nithya

changing a column name differs from the type of database we use.

MySQL:
ALTER table customer CHANGE Address Addr char(50);

Oracle:
ALTER table customer RENAME COLUMN Address TO Addr;

SQL Server:
It is not possible to rename a column using the ALTER TABLE
statement in SQL Server. Use sp_rename instead.

What is mysqlcommand?

1007

---

What is mysql aggregate functions? Explain

1099

---

Explain the different types of constraints?

949

---

What is the use of mysql_fetch_array () function in php?

942

---

What language does mysql use?

915

---

Is microsoft sql same as mysql?

993

---

What is the use of mysql workbench?

1017

---

What is logs in mysql?

905

---

What could be the reason that the mysql statement 'select avg (salary) from emp' generates an inaccurate output?

921

---

How to determine the location of the data directory?

967

---

What is procedure in mysql?

941

---

Can a table have multiple primary keys?

908

---

What are all the Common SQL Function?

1139

---

Why should I learn mysql?

922

---

How large can a mysql database become?

1004

---