Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

MySQL Interview Questions
Questions Answers Views Company eMail

What are the different table present in MYsql?

3 9993

What is the difference between mysql_fetch_array and mysql_fetch_object?

CTS,

4 10218

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

2393

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

TCS,

7 23017

How can we store binary data in mysql?

HP,

2 5236

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

PCS,

1 2295

How do you start and stop MySQL on Windows?

3 4664

How do you start MySQL on Linux?

3 4249

Explain the difference between mysql and mysqli interfaces in PHP?

TCS,

10 29793

What?s the default port for MySQL Server?

Yahoo,

4 6285

What does tee command do in MySQL?

1 7273

Can you save your connection settings to a conf file?

1 3130

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

2 5605

Use mysqldump to create a copy of the database?

2 4001

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

TCS,

1 3499


Post New MySQL Questions






Un-Answered Questions { MySQL }

What are the different types of triggers in mysql?

160


What is the maximum connection pool size?

170


What is field in mysql?

164


What is delimiter in mysql?

173


What is database clustering in mysql?

151






What are the advantages of mysql?

200


Why is the basic difference between left join, right join and inner join?

209


Transactions are used to treat sets of SQL statements atomically. State Whether True or False?

420


How do I know if mysql is installed on windows?

155


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?

1167


How to include comments in sql statements?

211


What is the usage of "i-am-a-dummy" flag in mysql?

249


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

2077


What is username in mysql?

171


What is key in mysql?

160