Mysql Interview Questions Part-1

Q- what is indexes in mysql ?
Answer:- 

Q- How many types of indexes in mysql ?

Q- What is the difference between clustered index and non clustered index?

Q- How to get nth highest salary in MySQL
SELECT salary FROM Employee  ORDER BY Salary DESC LIMIT n-1,1

1st highest salary in MySQL using LIMIT clause:
SELECT DISTINCT(salary) FROM Employee ORDER BY salary DESC LIMIT 0,1

2nd highest salary in MySQL using LIMIT clause:
SELECT DISTINCT(salary) FROM Employee ORDER BY salary DESC LIMIT 1,1

3rd highest salary in MySQL using LIMIT clause:
SELECT salary FROM Employee ORDER BY salary DESC LIMIT 2,1
                                             OR
SELECT DISTINCT(salary) FROM Employee ORDER BY salary DESC LIMIT 2,1

4th highest salary in MySQL using LIMIT clause:
SELECT salary FROM Employee ORDER BY salary DESC LIMIT 3,1
                                             OR

SELECT DISTINCT(salary) FROM Employee ORDER BY salary DESC LIMIT 3,1

Q- How to remove duplicate rows from table in mysql ?

Q- How to update gender male to female and female to meal in a table ?

Q- What are storage engine in mysql ?

Q- How many types of  storage engine in mysql ?

Q- How many types of storage engines in mysql ?

Q- How to create stored procedure, functions, view, trigger ?
Answer :- 
Stored Procedure in Mysql

Q- Stored procedure Vs Functions in mysql?

Q- How to debug stored procedure in?
Answer:- 
Use Visual Studio to debug Stored Procedure.
Choose a Stored Routine to Debug
Download : MySQL for Visual Studio (Archived Versions)
MySQL for Visual Studio
Debugging Stored Procedures and Functions

Related Tutorials

• Indexing in Database
  
• Mysql Interview Questions Part 1
• Mysql Joins
  
• Case Statement in MySQL
  
• Mysql Alter Table Statement
  
• MySQL HAVING Clause
  
• MySQL trigger
• Stored Procedure In Mysql
• Backup & Restore MySQL Database Using Java
  
• Spring Data JPA Interface Methods
  
• Spring Boot And Oauth2 With Jdbc
  
• Spring JdbcTemplate
  
• Integrate H2 Database In Spring Boot
  
• Spring Boot Multiple Datasources Configuration
  
• Spring Boot Multiple Database Configuration Example
  
• Spring Boot JdbcTemplate Configuration
  
• Spring DataSource JNDI with Tomcat Example
• Hibernate
• N+1 problem in hibernate
• Hibernate Session Interface
• Merge Vs SaveOrUpdate In Hibernate
• Spring Data JPA Interface Methods
• Mysql Interview Questions
• Hibernate interview questions part-1
• Hibernate interview questions part-2
• Hibernate interview questions part-3
• Hibernate interview questions part-4
• Hibernate interview questions part-5