MySQL Interview Questions
Questions Answers Views Company eMail

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

1 3672

maximum size of a database in mysql?

2 3971

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

1 2752

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

3 4445

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

2 4059

what is mysql optimization in brief?

1931

What is the difference between CHAR and VARCHAR data types?

Ramco,

2 7794

Give the syntax of REVOKE commands?

1 3545

Give the syntax of GRANT commands?

3 5023

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

3 7505

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

4 7154

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 5409

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 4120

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

HCL,

5 8941

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

8 11255


Post New MySQL Questions

Un-Answered Questions { MySQL }

Which datatype is used for email in mysql?

472


How we can get the current date in mysql?

500


Is mysql a database?

483


What is mysql used for?

510


What does do in mysql?

468






How can you add and remove any column of a table?

513


How to define numeric 9(3) in db2 table without decimal point??

2387


What is memory table?

488


What is the difference between a heap table and temporary table?

491


Why is mysql used?

515


How to enter numeric values as hex numbers?

527


What is triggers and how it can be used in mysql?

519


How do I change mysql password?

484


What are the advantages of a procedure?

464


How to enter microseconds in sql statements?

513