Answer Posted / 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.

How do I change mysql password?

1022

---

What is row locking in mysql?

969

---

How can we convert between Unix & MySQL timestamps?

967

---

What is clob datatype?

887

---

Write command to import an mysql file?

1036

---

HOW TO FIND display the total number of weeks in the year of 1998 IN EMP TABLE

2230

---

What is the use of mysqli_fetch_array?

1049

---

Is there a free mysql?

901

---

I want to insert userid of a customer,order time,etc in a table called ordermaster with orderid as primary key.Same time the product codes and required quantities (a1,2 and a2 4 and so on)inserted in another table orderdetails with same orderid reference.How the code will be in JSP using MySQL?

1908

---

What is blob storage?

986

---

How do I create a database in mysql workbench?

874

---

How you will show all data from a table.

996

---

How do I create a new database in mysql?

907

---

What is the default port for mysql and how it can change?

1064

---

How do I install mysql on windows 10?

975

---