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. stackoverflow.com/questions/5242990/… — Till Helge
– Till Helge, Commented Nov 21, 2011 at 14:54
possible duplicate of How do you set a default value for a MySQL Datetime column? — Johan
– Johan, Commented Nov 21, 2011 at 15:17

勿绮语 · Accepted Answer · 2011-11-21 14:53:12Z

6

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

answered Nov 21, 2011 at 14:53

勿绮语

9,3401 gold badge31 silver badges37 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Ike Walker · Accepted Answer · 2011-11-21 15:02:05Z

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, 2011 at 15:02

Ike Walker

65.8k14 gold badges115 silver badges112 bronze badges