|
From: Casper H. <ch...@us...> - 2002-05-12 16:12:38
|
s=F8n, 2002-05-12 kl. 17:47 skrev Rex Jolliff: > At 03:50 PM 5/12/02 +0000, you wrote: > >On Sun, May 12, 2002 at 01:00:30AM -0700, Steven Edwards=20 > >wrote: > > > SQL: INSERT INTO modules VALUES (0, NULL, , NULL, 'ReactOS', 'ReactOS > > ^ > > > operating system.') > > > > >Doesn't something need to go there? >=20 > Technically no, this form of INSERT implicitly selects all columns in the= =20 > table > for the insert. But, it is usually a bad idea from a maintainability poi= nt=20 > to use the > abbreviated form of insert. Similarly, its bad form to use '*' as a colu= mn=20 > selector in > a select statement. Well, mysql (3.23.41) does not accept this (I just checked). Try putting NULL there (it is the project_id field). I executed the same script without errors btw. |