List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:July 6 2000 8:09pm
Subject:Re: Index Problem on 3.23.20, with Large Query
View as plain text  
In the last episode (Jul 06), Joe Kislo said:
> 
> 	Yep, read that. However I need to populate the table with
> -multiple- constants.  They're not located in any database, so I
> can't select them out of a table.  What I want is some select
> statement that would return say
> |--|
> |33|
> +--+
> |22|
> +--+
> |46|
> ----

I'm a bit confused.  Are you trying to populate a table, or select
data?  If you want to fill a table with a bunch of rows in one command,
"INSERT INTO table VALUES (33),(22),(46)" will work.   If you want to
grnerate an arbitrary SQL resultset from a select statement with no
backing table, I'm not sure that's possible.
 
-- 
	Dan Nelson
	dnelson@stripped
Thread
Index Problem on 3.23.20, with Large QueryJoe Kislo3 Jul
  • Re: Index Problem on 3.23.20, with Large Querysinisa4 Jul
  • Re: Index Problem on 3.23.20, with Large QueryJoe Kislo5 Jul
    • Re: Index Problem on 3.23.20, with Large Querysinisa6 Jul
  • A question of INSERT LOW_PRIORITY and INSERT DELAYEDWordtracker5 Jul
  • Re: Index Problem on 3.23.20, with Large QueryJoe Kislo6 Jul
    • Re: Index Problem on 3.23.20, with Large QueryDan Nelson6 Jul
    • Re: Index Problem on 3.23.20, with Large Querysinisa6 Jul
      • Re: Index Problem on 3.23.20, with Large QueryJoe Kislo6 Jul
        • Re: Index Problem on 3.23.20, with Large Querysinisa6 Jul
  • Re: Index Problem on 3.23.20, with Large QueryJoe Kislo6 Jul
    • Re: Index Problem on 3.23.20, with Large Querysinisa6 Jul
      • Re: Index Problem on 3.23.20, with Large QueryJoe Kislo6 Jul
        • Re: Index Problem on 3.23.20, with Large QueryDan Nelson6 Jul
        • Re: Index Problem on 3.23.20, with Large Querysinisa6 Jul