What is delimiter in mysql trigger?


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

Post New Answer

More MySQL Interview Questions

Should I use pdo or mysqli?

0 Answers  


In mysql, what is the default storage engine?

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 can we get the number of rows affected by query?

0 Answers  


What is mysql cursor?

0 Answers  






How many sql ddl commands are supported by 'mysql'?

0 Answers  


What is a tinyint?

0 Answers  


What is the difference between truncate and delete in mysql?

0 Answers  


how to display nth highest salary from a table in a mysql query? : Mysql dba

0 Answers  


What are the different data types in mysql?

0 Answers  


What are the different column comparison operators in mysql?

0 Answers  


How do I install the latest mysql on ubuntu?

0 Answers  


Categories