Answer / bhavin parikh

SERIAL is an alias for BIGINT UNSIGNED NOT NULL
AUTO_INCREMENT UNIQUE.
Reference Link :
http://dev.mysql.com/doc/refman/5.0/en/numeric-type-overview.html

Answer / simon mahony

Check for yourself in the official docs at:
http://dev.mysql.com/doc/refman/5.0/en/numeric-type-overview.html

This states:
SERIAL is an alias for BIGINT UNSIGNED NOT NULL AUTO_INCREMENT UNIQUE.

SERIAL DEFAULT VALUE in the definition of an integer column is an alias for NOT NULL AUTO_INCREMENT UNIQUE.

Answer / amith

BIGINT NOT NULL PRIMARY KEY AUTO_INCREMENT .

Explain what is mysql?

0 Answers  

---

What are the other commands to know the structure of a table using mysql commands except explain command?

0 Answers  

---

Why do we use group by and order by function in mysql?

0 Answers  

---

Is mysql distributed?

0 Answers  

---

What does mysqli_fetch_assoc do?

0 Answers  

---

What can you do with mysql?

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  

---

Can we rollback truncate in mysql?

0 Answers  

---

What does schema mean?

0 Answers  

---

How do you kill a long running query in mysql?

0 Answers  

---

What are the steps involved in query processing?

0 Answers  

---