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.

How do I show users in mysql?

984

---

What is table level locking in mysql?

850

---

What is mysqlcommand?

931

---

What is horizontally scalable?

924

---

How large can a mysql database become?

917

---

What is limit in mysql?

824

---

What is foreign key in mysql?

974

---

Explain what is mysql?

980

---

Why to use char instead of varchar in the database?

1093

---

How do I insert an image into mysql workbench?

897

---

How can you calculate the sum of any column of a table?

987

---

What is mysqli_free_result?

849

---

what is database white box testing? : Mysql dba

938

---

What is a data directory?

874

---

How do I use mysql?

848

---