Hi Scott,
Yes this will work. But, you the columns you are leaving out, must be auto fill or
allow blank/Null entries.
Scotty.
Original Message:
From: Scott Fletcher [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Questions about MySQL's INSERT syntax
Date: Thu, 17 Jun 2004 12:28:16
You should try it. The database will like it just fine as long as you have
as many values/columns in your VALUES/SELECT clause as you list as columns
in your INSERT clause.
Just remember, though, that for all of the columns NOT listed in the INSERT
clause of your statement the database will
Hi
You shoule be able insert fewer columns. Of course,
you should include all the NOT NULL columns unless
they arere is auto_increment for them.
Regards
Bhaskara
--snip--
INSERT INTO TABLE1
(COLUMN1,COLUMN3)
VALUES
('ONE','THREE')
--snip--
--- Scott Fletcher [EMAIL PROTECTED] wrote: