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]
ject: Questions about MySQL's
INSERT syntax
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 s
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 wi
