MySQL Interview Questions
Questions Answers Views Company eMail

How do you prevent MySQL from caching a query?

1 2983

What?s the difference between query_cache_type 1 and 2?

1 5671

How can we repair a MySQL table?

Infosys,

2 4256




What are the advantages of stored procedures, triggers, indexes?

5 28072

What is the maximum length of a table name, database name, and fieldname in MySQL?

Accenture, TISL, Pioneer,

3 26175

How many values can the SET function of MySQL take?

Creative Informatics,

2 7317

What are the other commands to know the structure of table using MySQL commands except explain command?

SigmaTree,

2 5129

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

2 2874




What is maximum size of a database in MySQL?

Wipro, V2 Solutions, CIS, Bastioncoup, NM,

13 31406

Give the syntax of Grant and Revoke commands?

1 7258

Explain Normalization concept?

Inuva,

2 7775

How can we find the number of rows in a table using MySQL?

3 5138

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

5 8367

How can increase the performance of MySQL select query?

Span Systems, RV Technologies,

3 8692

The structure of table view buyers is as follows: +----------------+-------------+------+-----+---------+----- -----------+ | Field | Type | Null | Key | Default | Extra | +----------------+-------------+------+-----+---------+----- -----------+ | user_pri_id | int(15) | | PRI | NULL | auto_increment | | userid | varchar(10) | YES | | NULL | | +----------------+-------------+------+-----+---------+----- -----------+ the value of user_pri_id the last row 2345 then What will happen in the following conditions? Condition1: Delete all the rows and insert another row then. What is the starting value for this auto incremented field user_pri_id , Condition2: Delete the last row(having the field value 2345) and insert another row then. What is the value for this auto incremented field user_pri_id

2 2709


Post New MySQL Questions






Un-Answered Questions { MySQL }

I want to insert userid of a customer,order time,etc in a table called ordermaster with orderid as primary key.Same time the product codes and required quantities (a1,2 and a2 4 and so on)inserted in another table orderdetails with same orderid reference.How the code will be in JSP using MySQL?

826


what is mySQL. Is there any specific qualification required to do this course ? What is the scope in India after doing mySQL

308


I've looked but can't find a MySQL equivalent for MS SQL's xp_cmdshell. I have 7z files that I want to unzip and load into MySQL. I'm trying to write a sp to do the unzip, but I can't find a way to do that. Can anyone provide an example of a similar process in Windows? TIA.

2374


how to get only updated, deleted , inserted records after certain interval time in mysql with out using triggers...

1111


1)for snapshot replication which agents used? 2)for Transcation replication which agents used? 3)for merge replciation which agents used?

923






what is mysql optimization in brief?

1212


explain GROUPBY & HAVING clause with examples.

1154


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

1628


What is striped backup

1177


Please can the SQL code below be interpreted IF @xMatchCriteria='MATCH12' BEGIN IF EXISTS (Select * from #InsightData where (EmailAddress=@xDCPEmailAddress ) ) BEGIN SET @xTestMatchCriteria = @xMatchCriteria; SELECT @xCRMCustomerId=CustomerId, @xCRMDcpCustomerId=DcpCustomerId, @xCRMPortalCustomerID=PortalCustomerID,@xCRMDcpID=DcpID, @xCRMCardNumber=CardNumber, @xCRMEmailAddress=EmailAddress, @xCRMfirtLetterFirstName=firtLetterFirstName, @xCRMLastName=Surname,@xCRMAddressLine1=AddressLine1, @xCRMPostCode=PostCode FROM #InsightData where (EmailAddress=@xDCPEmailAddress ) END ELSE BEGIN SET @xTestMatchCriteria='No'+@xMatchCriteria; END END

478


why not null is not allowed at table level

1437


1.how to fetch a value and Execute store procudure in mysql(INNODB) using phpMyAdmin? 2.can i wright a package in mysql database(INNODB)?

1090


What are the method you will follow while sql installing

1228


What is difference between Sql server and MySql database? It may be silly question but i really dont know.

777


using primary can we relate two table, with out foreign key?

1578