MySQL Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

MySQL Interview Questions

Questions Answers Views Company eMail

what is the advantage of stored procedures, triggers and indexing in mysql

1 4614

maximum size of a database in mysql?

2 4892

how many fields can be updated using set in a mysql query?

1 3458

how many table created when we create a table in mysql?

3 5658

how many ways we can get the current date in mysql?

2 5013

what is mysql optimization in brief?

2361

What is the difference between CHAR and VARCHAR data types?

Ramco,

2 8881

Give the syntax of REVOKE commands?

1 4410

Give the syntax of GRANT commands?

3 6347

How many ways we can we find the current date using MySQL?

3 8865

What is the maximum length of a table name, a database name, or a field name in MySQL?

4 8548

Query to select passwords from a table having a column "Password" Whose length is b/w 8 &15 and having 'A' as the first character in the password irrespective of case.

3 6461

Fname Lname City Pin ramesh kumar salem 365241 Query to generate a code having the firstletter of Fname,Lname & 3letter of city Last 3letter of pin,all in capital letters

3 5375

SELECT country,city FROM customers GROUP BY country ORDER BY city DESC

HCL,

5 11029

how we can find nth max salary from an employe table by using my sql?

8 14243

Post New MySQL Questions

Un-Answered Questions { MySQL }

What is the data type for file in mysql?

986

In mysql, what is the default storage engine?

1006

what is constraints?

1155

What is use command in mysql?

1041

Does adding an index lock a table?

960

What is the current version of mysql?

969

Table - Products has number of products as below Productid ProductName 1 iPhone 2 iPad 3 BlackBerry Table - SalesPersonProduct has the below records Salespersonid productid S1 1 S1 2 S1 3 S2 1 S3 2 Write a SQL query that returns the total number of sold products

2831

What causes mysql too many connections?

962

What are the differences between char and nchar?

1095

Is oracle better than mysql?

886

What is the full meaning of mysql?

967

Can I use mysql for free?

905

What is the difference between database and table?

1003

How triggers can be used in mysql?

1017

Is mysql open source?

934

For More Un-Answered { MySQL } Questions Click Here