Mysql default value

Question

I would like to know how to create a default value.

For example:

CREATE TABLE something 
(
name varchar(20),
rank int
)

i would like to set the RANK value to 1.

(whenever i add new records, rank is automatically set to 1).

There are lots and lots of questions on this topic here at SO, e.g. http://stackoverflow.com/questions/5242990/default-value-for-a-text-column — Till Helge, Nov 21 '11 at 14:54
possible duplicate of [How do you set a default value for a MySQL Datetime column?](http://stackoverflow.com/questions/168736/how-do-you-set-a-default-value-for-a-mysql-datetime-column) — Johan, Nov 21 '11 at 15:17

score 6 · Accepted Answer · answered Nov 21 '11 at 14:53

6

CREATE TABLE something 
(
    name varchar(20),
    rank int default 1
)

answered Nov 21 '11 at 14:53

勿绮语

score 1 · Answer 2 · answered Nov 21 '11 at 15:02

1

If the table already exists and you want to add the default value the fastest way to do it is with ALTER TABLE like this:

ALTER TABLE something
  ALTER COLUMN rank SET DEFAULT 1;

answered Nov 21 '11 at 15:02

Ike Walker

2 Answers2