Answer / lekhrajdeshmukh

i have answer regarding on master and one slave running on
the status:-
show slave status \G;

What is full text indexing in mysql?

0 Answers  

---

How do I rename a table in mysql?

0 Answers  

---

What are MySQL transactions?

2 Answers  

---

How do I show all mysql databases?

0 Answers  

---

Explain about reporting services of MYSQL?

0 Answers  

---

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

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  

---

Give the syntax of Grant and Revoke commands?

1 Answers  

---

How can we get total number of records by query in mysql?

0 Answers  

---

What is save point in mysql?

0 Answers  

---

List the different types of normalization?

0 Answers  

---

How can I see connections in mysql?

0 Answers  

---