MySQL Interview Questions
Questions Answers Views Company eMail

What are the different table present in MYsql?

3 8683

What is the difference between mysql_fetch_array and mysql_fetch_object?

CTS,

4 8527

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

2124




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

TCS,

7 21583

How can we store binary data in mysql?

HP,

2 4551

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

PCS,

1 1729

How do you start and stop MySQL on Windows?

3 3990

How do you start MySQL on Linux?

3 3563




Explain the difference between mysql and mysqli interfaces in PHP?

TCS,

10 27860

What?s the default port for MySQL Server?

Yahoo,

4 5374

What does tee command do in MySQL?

1 6742

Can you save your connection settings to a conf file?

1 2658

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

2 5047

Use mysqldump to create a copy of the database?

2 3422

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

TCS,

1 2933


Post New MySQL Questions






Un-Answered Questions { MySQL }

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

2909


Can u give the example by taking an unnormalized table and make that 1nf and then 25nf, and then 3 nf?

3626


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

1212


What are the method you will follow while sql installing

1316


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

1023






What is RMS Migrations

1248


What are the critical issues you have resolved in your company

1159


How can you move the master database

924


why not null is not allowed at table level

1593


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

408


How can you plan the logshipping before processing?

1270


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...

1779


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?

1538


Explain the architecture models of SQL Server?

1351


what is mysql optimization in brief?

1308