What is the difference between having and where clause in mysql? Explain


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

Post New Answer

More MySQL Interview Questions

Why do we use the mysql database server?

0 Answers  


What is the purpose of using timestamp data type?

0 Answers  


What are the 3 main types of search queries?

0 Answers  


What is the storage engine for mysql?

0 Answers  


What are HEAP tables in MySQL?

1 Answers  


How to delete a trigger in mysql?

0 Answers  


How do I start mysql in linux?

0 Answers  


How big is a blob mysql?

0 Answers  


The structure of table view buyers is as follows: +----------------+-------------+------+-----+---------+----- -----------+ | Field | Type | Null | Key | Default | Extra | +----------------+-------------+------+-----+---------+----- -----------+ | user_pri_id | int(15) | | PRI | NULL | auto_increment | | userid | varchar(10) | YES | | NULL | | +----------------+-------------+------+-----+---------+----- -----------+ the value of user_pri_id the last row 2345 then What will happen in the following conditions? Condition1: Delete all the rows and insert another row then. What is the starting value for this auto incremented field user_pri_id , Condition2: Delete the last row(having the field value 2345) and insert another row then. What is the value for this auto incremented field user_pri_id

2 Answers  


how we can find nth max salary from an employe table by using my sql?

8 Answers  


write a query to mysql in safe mode and to change the root password

0 Answers  


what is mysql optimization in brief?

0 Answers  


Categories