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:
> 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.
>
__________________________________
Do you Yahoo!?
Read only the mail you want - Yahoo! Mail SpamGuard.
http://promotions.yahoo.com/new_mail
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
