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 will MySQL accept a fewer columns
instead of all, like this...
--snip--
INSERT INTO TABLE1
(COLUMN1,COLUMN3)
VALUES
('ONE','THREE')
--snip--
Because on some database software/application, it won't accept this if
the table get very long with many columns and I was forced to use all of
hte columns in the SQL Syntax. I don't know how MySQL react to this
with a very long table and with many columns.
Thanks,
Scott F.
