What is the difference between heap table and temporary table?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More MySQL Interview Questions

I have a table like this tblData (month int,Qty int) and i am inserting three rows in this table 1.tblData Values (1,100) 2.tblData Values (2,200) 3.tblData Values (3,300) The Result I want is the Running total of the field Qty that is 1 100 100 2 200 300 3 300 600 What is the Query for that ?

4 Answers  


What is delimiter $$?

0 Answers  


Where is mysql password stored?

0 Answers  


What is the default port number of mysql?

0 Answers  


What is auto increment in mysql?

0 Answers  






Can we rename database in mysql?

0 Answers  


How do you concatenate strings in mysql?

0 Answers  


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

3 Answers  


What are the three types of queries?

0 Answers  


How do I setup mysql?

0 Answers  


What is the use of mysqli_fetch_assoc?

0 Answers  


What is the default port for MySQL Server?

0 Answers  


Categories