mysql char() type

Anon

Hi!

Anybody so kind to answer this: I have a column defined as char(2), default
'no', not null.
When I create new entry into the table, I skip entering value into mentioned
column
because I expect to be filled with the default value, that is 'no'. But that
doesn't happen!
Why?

Thanks!
Bye

knickerlas

Not sure but I think you have to enter a 'null'? Try it anyway.

Nick

steved

Care to show us the full table definition and the insert statement you are using?

Anon

Yes, here's the table:

CREATE TABLE recepti (
rid smallint(6) NOT NULL auto_increment,
put varchar(20) NOT NULL,
nazivStranice varchar(15) NOT NULL,
nazivRecepta varchar(60) NOT NULL,
brojOsoba varchar(15) NOT NULL,
uvod text NOT NULL,
slika varchar(70) NOT NULL,
nacinPripreme text NOT NULL,
savjet text NOT NULL,
vrijemePripreme_min tinyint(3) unsigned DEFAULT '0' NOT NULL,
energVrijedJednogObroka_kJ smallint(6) DEFAULT '0' NOT NULL,
datumEmitiranja_maleTajne date DEFAULT '0000-00-00' NOT NULL,
izvorRecepta varchar(50) NOT NULL,
thumb tinyint(1) DEFAULT '0' NOT NULL,
objavi varchar(4) DEFAULT 'ne' NOT NULL,
PRIMARY KEY (rid),
FULLTEXT (nazivRecepta, uvod, nacinPripreme)
);

Here's the query:
INSERT INTO recepti (rid, put, nazivStranice, nazivRecepta, brojOsoba, uvod, slika, nacinPripreme, savjet, vrijemePripreme_min, energVrijedJednogObroka_kJ, datumEmitiranja_maleTajne, izvorRecepta, thumb, objavi) VALUES ('', '', '', 'foo', '', '', '', '', '', '', '', '', '', '', '')

Hmm... long message, huh!
Bye

steved

Well, your insert statement as it is now will not work. You should not include the "rid" column because that is auto-incremented. You should not include any values you want to use the defaults for. You do need to include a value for any columns without a default that are defined as NOT NULL. So, you could use something like:

INSERT INTO recepti (put, nazivStranice, nazivRecepta, brojOsoba, uvod, slika, nacinPripreme, savjet, izvorRecepta) VALUES ('foo1', 'foo2', 'foo3', 'foo4', 'foo5', 'foo6', 'foo7', 'foo8', 'foo9')

You should get your defaults and a bunch of foo inserted into the database.