What are the different types of triggers in mysql?

0 Answers  

---

at first i'm using datediff('d', a.due_date, current_date); but it takes too long to get the result but how can i subtract the current_date - a.due_date and still get the same result like when i use datediff? thank you

1 Answers  

---

How to get a list of columns in an existing table?

0 Answers  

---

How do I connect to a database in mysql workbench?

0 Answers  

---

what is a cursor? : Mysql dba

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  

---

What is index length in mysql?

0 Answers  

---

What's new in mysql 8?

0 Answers  

---

How you will show all data from a table.

0 Answers  

---

What is prepared statement in mysql?

0 Answers  

---

How does mysql encrypt passwords?

0 Answers  

---

How to enter binary numbers in sql statements?

0 Answers  

---