jabootyboy
asked on
Set default value for mysql tuple.
Hey,
I would like to create a default value FALSE for a mysql in the column flagged.
CREATE TABLE competition (
B1 int(2),
B2 int(3),
B3 int(3),
B4 int(3),
B5 int(3),
B6 int(3),
username VARCHAR(8),
??? flagged VARCHAR(6) default="FALSE", ???
foreign key (username) references user(username)
)Type = InnoDB;
I would like to create a default value FALSE for a mysql in the column flagged.
CREATE TABLE competition (
B1 int(2),
B2 int(3),
B3 int(3),
B4 int(3),
B5 int(3),
B6 int(3),
username VARCHAR(8),
??? flagged VARCHAR(6) default="FALSE", ???
foreign key (username) references user(username)
)Type = InnoDB;
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.