List:General Discussion« Previous MessageNext Message »
From:Chukkala Bhaskar Date:June 18 2004 5:44am
Subject:Re: Questions about MySQL's INSERT syntax....
View as plain text  
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 <SFletcher@stripped> 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 
Thread
Questions about MySQL's INSERT syntax....Scott Fletcher17 Jun
  • Re: Questions about MySQL's INSERT syntax....Chukkala Bhaskar18 Jun
re: Questions about MySQL's INSERT syntax....Scott Johnson17 Jun
Re: Questions about MySQL's INSERT syntax....SGreen17 Jun