[phpodpworld-users] Re: phpodpworld 2.0 structure table

[Howard L. <hl...@gm...>]

Hi Hans,

I checked it should be specific to MySQL, and I think it affects MySQL
4.x and 5.x.

http://dev.mysql.com/doc/refman/4.1/en/insert.html
"If you do not specify a list of column names for INSERT ... VALUES or
INSERT ... SELECT, values for every column in the table must be
provided by the VALUES list or the SELECT statement. If you do not
know the order of the columns in the table, use DESCRIBE tbl_name to
find out."

And I'm thinking it might be better to use the DEFAULT keyword instead
of hard coding to -1. But the DEFAULT keyword requires MySQL 4.0.3 or
above.

Howard