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 normalization and list the different types of normalization?

936

---

In how many ways we can retrieve data in the result set of mysql using php?

1104

---

What mysql -u john -p command does?

957

---

How do you insert a table?

914

---

What is mysqli_num?

925

---

What is delimiter in mysql trigger?

924

---

Is sqlite faster than mysql?

910

---

What are the other commands to know the structure of a table using mysql commands except explain command?

1003

---

how to add a new column to an existing table?

969

---

What is a mysql server?

967

---

What is difference mysql and mysqli?

936

---

How to increment dates by 1 in mysql?

1011

---

What is difference between unix timestamp and mysql timestamp?

991

---

Is mysql a backend?

914

---

How to create table show example

944

---