Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

MySQL Interview Questions
Questions Answers Views Company eMail

what is JOIN? Give example & types of join?

iMedia, Millennium, RAM Software, Satyam,

14 36596

what are the optimization techniques for Query optimization performance issues and faster execution of queries

Infosys, Sierra Atlantica,

2 11229

what are the main differences between MyISAM and InnoDB table storage structures ? what are the advantages and disadvantages in usage of these ?

E2 Solutions, Tesco,

10 39899

in a master-master replication with two masters and alternate slaves running on two systems.can i have a script or any mysql command to know which one is right now acting as master.

1 2834

if we want to load data from a text file into a mysql table, but the columns in table are 1st: code(int) and 2nd: city(varchar), but in text file the format is 1st cityname and then code separeted by delimeters. how to load?

2 3759

how we can use more then one primary key in Single Table

Systematix,

9 12442

Ondelete clause is specified with a.)Drop table b.)Delete command c.)Create table d.)Select command

Amdocs, MediaSoft,

5 6990

how to find missing numbers between two order numbers; and dates ?

1 5154

How to get full name of monthname ?

4 7231

about join

2 3547

about foregine

2 2823

How to find out the second largest element from mysql table

15 22431

How we can copy one table data into another table whose name same as table but in differ database

8 14961

please give me the answer for this: query which generates the second highest integer in the table?

8 6012

How many tables will create when we create table, what are they?

5 7571


Post New MySQL Questions

Un-Answered Questions { MySQL }

Do you need a license for mysql?

367


Is mysql same as mariadb?

334


What is the datatype for password in mysql?

350


Is mysql same as sql?

340


What is the default port for MySQL Server?

437






How many rows can be inserted in mysql at a time?

353


How to get last inserted id after insert data from a table in mysql?

394


What is the maximum number of columns per table?

343


What is int unsigned?

355


How do you use auto increment?

362


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

473


What is ntext?

464


What are the common mysql functions?

333


How can you make a database as your current database?

357


What are the limitations of mysql?

348