MySQL Interview Questions
Questions Answers Views Company eMail

What are the different table present in MYsql?

3 6481

What is the difference between mysql_fetch_array and mysql_fetch_object?

CTS,

4 6226

How to set the time zone for MySQL to particular country time?

1770

What is the difference between mysql_connect() and mysql_pconnect()?

TCS,

7 18897

How can we store binary data in mysql?

HP,

2 3469

How can you get your MySQL root password, if you lost it?

PCS,

1168

How do you start and stop MySQL on Windows?

3 2799

How do you start MySQL on Linux?

3 2525

Explain the difference between mysql and mysqli interfaces in PHP?

TCS,

10 25367

What?s the default port for MySQL Server?

Yahoo,

4 4010

What does tee command do in MySQL?

1 5939

Can you save your connection settings to a conf file?

1 1978

How do you change a password for an existing user via mysqladmin?

2 3964

Use mysqldump to create a copy of the database?

2 2589

Have you ever used MySQL Administrator and MySQL Query Browser? Describe the tasks you accomplished with these tools?

TCS,

2106


Post New MySQL Questions


Un-Answered Questions { MySQL }

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

794


What is RMS Migrations

876


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)?

681


How to set the time zone for MySQL to particular country time?

1770


Explain the architecture models of SQL Server?

943


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

142


How internally data stores in MyISAM and INNODB table types?

1079


How to enable or disable a row of a table using MySQL in struts?

2222


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

711


Hi Team, This is kartik, I recently completed my B-tech. Importance of posting this question is for to know the best books on SQL(MYSQL/Oracle)? I like SQL concept's so much, at the same time i decided to choose SQL for my career purpose. So please suggest me the best books that are very helpful for a fresher to improve concepts like (SQL/PLSQL)Basics, programming concepts, architectures etc. Please consider my request as an important one. I am very thankful to you for providing this opportunity. If possible can you please send the names of books for my personal id also: karthikgdv1206@yahoo.com. Thanks, Kartik T

806


How can you move the master database

577


HOW TO FIND display the total number of weeks in the year of 1998 IN EMP TABLE

749


How can you get your MySQL root password, if you lost it?

1168


suppose data is copie to oracle to sql by using DTS. Actully it taken 2 hours. suppose some day distribute the server in the middle of 2 hours. after how can i get the data ?

747


Have you ever used MySQL Administrator and MySQL Query Browser? Describe the tasks you accomplished with these tools?

2106