How to define the default values for a column when creating tables in MySQL?

Question

What is the SQL to define DEFAULT values in MySQL?

In the code below what needs to be added / changed to give IsObsolete a default value of N?

CREATE TABLE Team
(
    TeamId              CHAR(16) NOT NULL,
    DateCreated          TIMESTAMP NOT NULL,
    IsObsolete           CHAR(1) NOT NULL DEFAULT N,
    UpdateTime           TIMESTAMP NOT NULL
);

Super noob here, why CHAR(1) and not boolean?

William T. Mallard
– William T. Mallard

2013-10-02 16:02:15 +00:00
Commented Oct 2, 2013 at 16:02 — William T. Mallard
– William T. Mallard, Commented Oct 2, 2013 at 16:02

Anthony Accioly · Accepted Answer · 2011-04-27 21:05:51Z

24

IsObsolete           CHAR(1) NOT NULL DEFAULT 'N'

answered Apr 27, 2011 at 21:05

Anthony Accioly

22.6k9 gold badges76 silver badges125 bronze badges

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

2 Comments

swisscheese Over a year ago

hehe, thanks...overlooked something so simple. Appreciate the help

Anthony Accioly Over a year ago

Happens :D. I'm glad to help.

CanSpice · Accepted Answer · 2011-04-27 21:06:05Z

10

You probably want to put quotes around it:

CREATE TABLE Team
(
    TeamId              CHAR(16) NOT NULL,
    DateCreated          TIMESTAMP NOT NULL,
    IsObsolete           CHAR(1) NOT NULL DEFAULT 'N',
    UpdateTime           TIMESTAMP NOT NULL
);

answered Apr 27, 2011 at 21:06

CanSpice

36.1k10 gold badges74 silver badges87 bronze badges

1 Comment

swisscheese Over a year ago

+1 looks like your answer came in a few seconds later. Thanks for the help.

MonoThreaded · Accepted Answer · 2013-03-26 09:29:50Z

1

If your are changing your structure via phpMyAdmin, you should just type in the char (e.g N) as opposed to 'N'

answered Mar 26, 2013 at 9:29

MonoThreaded

12.1k15 gold badges78 silver badges109 bronze badges

Collectives™ on Stack Overflow

How to define the default values for a column when creating tables in MySQL?

3 Answers 3

2 Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related