all the queries used in sql

0 Answers   TCS,

---

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 do you index just the first four bytes of the column?

2 Answers  

---

what is the procedure to configure the application of mysql?

0 Answers  

---

how can you test for null values in a database? : Mysql dba

0 Answers  

---

What do I do if I forgot my mysql root password?

0 Answers  

---

How can we get the number of rows affected by query?

0 Answers  

---

How do I grant privileges to a user in mysql phpmyadmin?

0 Answers  

---

How can I create database in mysql?

0 Answers  

---

Is mysql a server?

0 Answers  

---

What are the advantages of stored procedures, triggers, indexes?

5 Answers  

---

What is mysql connection limit?

0 Answers  

---