Un-Answered Questions { MySQL }

Explain the different types of mysql joins.

671


What are the differences between innodb and myisam engines?

674


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

682


What is the default port number of mysql?

710


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

869


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

720


What is a storage engine?

735


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

1016


What is the purpose of using a heap table?

736


How can you change the password of a mysql user?

734


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

742


What is meant by decimal (5,2)?

747


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

684


What is the difference between unix timestamp and mysql timestamp?

741


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

756