Un-Answered Questions { MySQL }

Explain the different types of mysql joins.

691


What are the differences between innodb and myisam engines?

708


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

707


What is the default port number of mysql?

746


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

894


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

747


What is a storage engine?

753


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

1047


What is the purpose of using a heap table?

751


How can you change the password of a mysql user?

762


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

759


What is meant by decimal (5,2)?

776


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

708


What is the difference between unix timestamp and mysql timestamp?

764


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

786