Loading...

Make MySql Interview Questions

View: 501    Dowload: 0   Comment: 0   Post by: hanhga   Category: Php&mySql   Fields: Other

MySql is one of the most used open-source database. In this article, i try to cover some of the most asked mysql interview questions. In my previous post i published PHP MCQ for Practice.

MySql Interview Questions

1Difference between Primary key and Unique Key ?

Answer – Both primary and unique is used to identify the rows uniquely. Here are some important differences.

i) Primary key cannot be null as compared to unique key which can be null for at least one value.
ii) In a table you can declare only one primary key, but unique keys can be multiple.
iii)In case of primary key clustered index is created, whereas Non-Clustered index is created in case of unique key.

2. What’s the difference between MyISAM and InnoDB storage engines.

Answer- MySql supports several storage engines out of which MyISAM and InnoDB are mostly used.

Check Complete Explanation.

3. How to create index in mysql and what are it’s advantage ?

Answer – Syntax for creating index in MySql

1
CREATE INDEX index_name ON table_name (column_name);

Let’s say i am creating index on salary column of employee table

create index salary_indx on employee (salary);

Advantage of Indexes-

It speeds up the search. Means when you query some data it will find the result very quickly.

4. What are the disadvantages of creating an index ?

Answer – i) Slower writes – Means your insert and update statement run slow.

ii) Takes more disk space.

5. How to select unique rows ?

Answer – Using distinct keyword in mysql, you can select unique rows.

select distinct fieldname from table_name;

6. How to sort the record in ascending or descending order in MySql.

Answer – Using order by with asc for ascending and desc for descending.

To select rows in ascending order

select * from table_name order by field_name asc;

Ex- suppose i have to show the result of an employee, from lowest to highest salary.

select * from employee order by salary asc;

To select rows in descending order

select * from table_name order by field_name desc;

7. How to select 100th record of a table.

select * from table_name limit 99,1;

8. Given a table products and product_review. Select the product name whose review is given by user.

+------+-----------------+---------+---------------------+
| p_id | p_name          | p_price | p_created           |
+------+-----------------+---------+---------------------+
|    1 | Dell Backpack   |     324 | 2014-07-09 17:55:40 |
|    2 | The White Tiger |     348 | 2014-07-01 17:55:40 |
|    3 | Iphone 5s       |   40000 | 2014-07-08 00:00:00 |
+------+-----------------+---------+---------------------+

Table Name – products_review

+------+-------------------+
| p_id | review            |
+------+-------------------+
|    2 | Excellent product |
|    3 | Amazing           |
+------+-------------------+

Here we have to fetch the record from two tables. In this case we need to use Join.

select p.p_name from products p inner join product_review pr on p.p_id=pr.p_id;
 
+-----------------+
| p_name |
+-----------------+
| The White Tiger |
| Iphone 5s |
+-----------------+

9. Default port on which MySql is running.

Answer Default for MySql is 3306.

To check the setting, open my.cnf file.

10. What’s the difference between inner join and left join.

Answer – Joins are used when we want to fetch data for more than one table.

Make MySql Interview Questions

MySql is one of the most used open-source database. In this article, i try to cover some of the most asked mysql interview questions. In my previous post i published PHP MCQ for Practice.

Posted on 06-10-2016 

Comment:

To comment you must be logged in members.

Files with category

  • Twitter-like Hashtag Function in PHP

    Twitter-like Hashtag Function in PHP

    View: 0    Download: 0   Comment: 0

    Category: Php&mySql     Fields: none

    If you ever want a function to hashtag and style words within a string which has '#' next to it like twitter. This piece of code will help

  • PSITS Automated Voting System

    PSITS Automated Voting System

    View: 24    Download: 3   Comment: 0

    Category: Php&mySql     Fields: none

    A free sourcecode for PSITS Automated Voting System develop in PHP programming language. The purposed of the system is to automate the process of voting and maintain the quality of data

  • PHP-University Application System

    PHP-University Application System

    View: 30    Download: 6   Comment: 0

    Category: Php&mySql     Fields: none

    Greeting from Malawi the warm heart of Africa. I developed this university registration system project just to share with the people who can make use of the project like this and at the same time for others like students who can learn from it. This...

  • School Event Management System in PHP/MSQLi

    School Event Management System in PHP/MSQLi

    View: 22    Download: 0   Comment: 0

    Category: Php&mySql     Fields: none

    This School Event Management System can create school events such as Volleyball games, Basketball, Cultural presentation, Election of school officers etc . During school election Instead of having a compile list of candidates and voters this system...

  • Resort Reservation System with PayPal/Credit Card/Debit Card Payment

    Resort Reservation System with PayPal/Credit Card/Debit Card Payment

    View: 27    Download: 0   Comment: 0

    Category: Php&mySql     Fields: none

    This reservation system has the ability to help its customers find available rooms, cottages and even function hall for their convenience . And in here, they will also have the idea of the room rates where they can quickly reserve for their family...

  • Activity log

    Activity log

    View: 20    Download: 0   Comment: 0

    Category: Php&mySql     Fields: none

    Simple program to track user's activity log-in time and online/offline status.

  • Electricks - eCommerce

    Electricks - eCommerce

    View: 22    Download: 0   Comment: 0

    Category: Php&mySql     Fields: none

    Electricks is an e-commerce website built using PHP, Bootstrap and some jQuery plugins. It has all the major functionalities of a typical e-shop. This project was used to present in Southern Luzon State University - Lucban. Feel free to use this code...

  • Simple Email App Using PHP

    Simple Email App Using PHP

    View: 18    Download: 0   Comment: 0

    Category: Php&mySql     Fields: none

    Creating a simple PHP script using mail function for sending out emails.

 
File suggestion for you
Loading...
File top downloads
Loading...
Loading...
Codetitle - library source code to share, download the file to the community
Copyright © 2018. All rights reserved. codetitle Develope by Vinagon .Ltd