Tilted Forum Project Discussion Community - View Single Post

ratbastid · 04-16-2006, 06:20 AM

When you don't supply a field list in your INSERT statment, you have to have the right number of fields in your VALUES list. You might think that SQL would just line them up one-for-one and NULL (or default) any fields at the end, but not so.

Try this:

Code:

INSERT INTO members (id, fname, lname, address, phone) VALUES (1, 'firstname','lastname','address','12345');

That should do the trick.

04-16-2006, 06:20 AM	#3 (permalink)
ratbastid Darth Papa Location: Yonder	When you don't supply a field list in your INSERT statment, you have to have the right number of fields in your VALUES list. You might think that SQL would just line them up one-for-one and NULL (or default) any fields at the end, but not so. Try this: Code: INSERT INTO members (id, fname, lname, address, phone) VALUES (1, 'firstname','lastname','address','12345'); That should do the trick.