Hi! The SQL's INSERT Syntax that have been frequently been used is
--snip--
INSERT INTO TABLE1
(COLUMN1,COLUMN2,COLUMN3,COLUMN4,COLUMN5)
VALUES
('ONE','TWO','THREE','FOUR','FIVE')
--snip--
where the TABLE1 have 5 columns, COLUMN1, COLUMN2, COLUMN3, COLUMN4,
COLUMN5. What I wanna know is
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
]
com cc:
Fax to:
06/17/2004 12:28 Subject: Questions about MySQL's
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: