--- Dennis Cote <[EMAIL PROTECTED]> wrote:
> Qiang wrote:
> > hello,
> >
> > two questions..
> >
> > 1. comparing select one or two columns from one
> row
> > from a bigger table ( 20,000 - 30,000 rows, 20
> columns
> > ).
> >wi
makes it?
2. Comparing select a sequence number first from a
small table THEN select all rows from another table
that have the same sequence number ( hence two selects
)
with
join select on this two tables where they have the
same sequence number. any difference here?
thanks,
Qiang
I forgot to mention, I do have two connections in ONE process, one of
the connection is used to create those temp tables. but still, after
temp table is created, none of the two connection can access to the
Temp tables.
On 7/22/05, Ming Qiang Lin <[EMAIL PROTECTED]> wrote:
&g
Hi All,
Following is the sqlite CREATE TABLE definition:
If the "TEMP" or "TEMPORARY" keyword occurs in between "CREATE" and
"TABLE" then the table that is created is only visible to the process
that opened the database and is automatically deleted when the
database is closed. Any indices create
4 matches
Mail list logo