Tati Sulastri wrote:
> I am new in using mysql, forgive me if this question just disturbed you.
> I have a table with id as a primary key, as I knew a primary key never be
> a null (empty and zero), is that true ? . in mysql the default of the
> primary key is null so that if I insert zero into the id, the id has zero
> how to make the mysql return a parse error when I set a zero value ?
What makes you believe, that a PRIMARY KEY can not contain zero?
Belive me it can!
Only if you have an AUTO_INCREMENT set on that PRIMARY KEY a zero value will be treated as
an automatic generation insert into this column.