MySQL interview questions for experienced MySQL query for finding max and second max and nth max salary for a employee table using MySQL Suppose you have a table ’employee’ given as below —————————— | EmpId | Salary | | 2 | 2000 | | 3 …
What is the difference between GROUP BY and ORDER BY in MySql? Mostly this question has been asked by the interviewer, even if you have used it many times but at that time generally the guy not satisfied the interviewer by the answer. Please go through the below and give very appropriate answer…
DROP TABLE tablename; DROP command is used for deleting the table and its structure from the data base.Use this command when you don’t need that table any more. Other Spec: 1. Removes a table from the database.Table structures, indexes, privileges, constraints will also be removed. 2. Cannot be rolled back. 3. No Triggers can…
ACID(Atomicity Consistency Isolation Durability) is a set of properties that guarantee that database transactions are processed reliably. In the context of databases, a single logical operation on the data is called a transaction. Atomicity Atomicity is an all-or-none proposition. Modifications on the data in the database either fail or succeed. Each transaction is said…
If you want to reset or change xampp mysql password, or have forgot the password for accessing phpMyAdmin then just follow the below step to reset the password or change the password. You can do this by two methods. Method 1 The easiest way is to use the security console, which you can…
If your databases are located on same MySQL server.You don’t need two connections, you can access them both as unique user. You also don’t need to select a DB. Just use the database-name as prefix when specifying the tables. That’s it. Or if you want to select database, you can do Please note there can…
