MySQL Interview Questions
Questions Answers Views Company eMail

What are the different table present in MYsql?

3 8060

What is the difference between mysql_fetch_array and mysql_fetch_object?

CTS,

4 7740

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

2010




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

TCS,

7 21021

How can we store binary data in mysql?

HP,

2 4295

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

PCS,

1 1451

How do you start and stop MySQL on Windows?

3 3619

How do you start MySQL on Linux?

3 3261




Explain the difference between mysql and mysqli interfaces in PHP?

TCS,

10 27133

What?s the default port for MySQL Server?

Yahoo,

4 4975

What does tee command do in MySQL?

1 6492

Can you save your connection settings to a conf file?

1 2433

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

2 4818

Use mysqldump to create a copy of the database?

2 3203

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

TCS,

1 2658


Post New MySQL Questions






Un-Answered Questions { MySQL }

What are the method you will follow while sql installing

1199


i made a table whih contain a column "Photo" with image data type and i want to insert the byte of a picture present in my hardisk using insert statement in that colum... so what will be my insert statement?

1432


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

892


What is RMS Migrations

1079


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

2010






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

1039


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.

2307


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

1077


In a property booking section want a query to check that property is booked from StartDate to EndDate.Booking Table field are given id proerty_id start_date checkout_date no_of_visitor booking date status Waiting yours answer.. Thanks In Advance...

1617


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

1595


Explain the architecture models of SQL Server?

1205


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

959


How can you move the master database

820


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

1548


How internally data stores in MyISAM and INNODB table types?

1370