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 -0400
>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.
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
