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

975

---

What is the default port number of mysql?

995

---

Which statement is used in a select query for partial matching?

1232

---

What is the difference between now() and current_date()?

1026

---

What is a storage engine?

1018

---

What is a join? Explain the different types of mysql joins.

1465

---

What is the purpose of using a heap table?

1195

---

How can you change the password of a mysql user?

1020

---

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

1089

---

What is meant by decimal (5,2)?

1098

---

What is a trigger? How you can create a trigger in mysql?

962

---

What is the difference between unix timestamp and mysql timestamp?

1101

---

How can you change the name of any existing table by using the sql statement?

1050

---

What is the purpose of using ifnull() function?

1047

---

How can you add and remove any column of a table?

994

---