List:General Discussion« Previous MessageNext Message »
From:Martin Ramsch Date:August 5 1999 11:32am
Subject:Re: Tables
View as plain text  
On Mi, 1999-08-04 14:19:08 -0600, Steve Ruby wrote:
> use 
> 
> insert into tablename (col1name,col2name,col3name) values
> (col1value,col2value,col3value)
> 
> to actually specify the names of the columns you are putting
> data into

Or, fill the unused fields with NULL:

  INSERT INTO tablename
  VALUES (col1value, col2value, col3value, NULL, ..., NULL);

Whatever you like better.  I'd prefer Steve's suggestion, as it is
more robust against changes in the table definition.

Regards,
  Martin
-- 
Martin Ramsch <m.ramsch@stripped> <URL: http://home.pages.de/~ramsch/ >
PGP KeyID=0xE8EF4F75 FiPr=52 44 5E F3 B0 B1 38 26  E4 EC 80 58 7B 31 3A D7
Thread
TablesNazar4 Aug
  • Re: TablesSteve Ruby5 Aug
    • Re: TablesMartin Ramsch5 Aug
  • Re: TablesJohn Littlefield5 Aug
  • Re: TablesChristian Mack5 Aug