At 8:34 AM +0100 12/16/07, Jochem Maas wrote:
I guess back in day when rocks[tm] were still in vogue you would have had
to be much more frugal with the meager cycles at your disposal - we're
spoiled for cycles these days :-)
I gave up mine when cars came along.
To all -- All points well taken
tedd wrote:
> At 12:20 PM +0100 12/13/07, Zoltán Németh wrote:
>> 2007. 12. 12, szerda keltezéssel 20.13-kor tedd ezt írta:
>> > I would like to create a temporary table to perform searches.
>>>
>>> From my main table, I need to exclude records that have certain
>>> fields that are null or empt
5000 records is chump-change.
select *
from products
where product_name is not null
and product name != ''
order by product_id
On a 5000-record set, this should be screaming fast even with no index
UNLESS your server is already drastically overloaded.
On Thu, December 13, 2007 9:14 am, tedd wr
2007. 12. 13, csütörtök keltezéssel 10.14-kor tedd ezt írta:
> At 12:20 PM +0100 12/13/07, Zoltán Németh wrote:
> >2007. 12. 12, szerda keltezéssel 20.13-kor tedd ezt írta:
> > > I would like to create a temporary table to perform searches.
> >>
> >> From my main table, I need to exclude records
On Dec 13, 2007 10:37 AM, Daniel Brown <[EMAIL PROTECTED]> wrote:
> // Put DB and config includes here.
>
> $sql = "SELECT * FROM prod_table WHERE product_name != '' ORDER BY
> product_id";
> $result = mysql_query($sql) or die(mysql_error());
> while($row = mysql_fetch_array($result)) {
> $ss
On 12/13/07, Robert Cummings <[EMAIL PROTECTED]> wrote:
>
> On Thu, 2007-12-13 at 10:14 -0500, tedd wrote:
> > At 12:20 PM +0100 12/13/07, Zoltán Németh wrote:
> > >2007. 12. 12, szerda keltezéssel 20.13-kor tedd ezt írta:
> > > > I would like to create a temporary table to perform searches.
> > >
On Dec 13, 2007 10:14 AM, tedd <[EMAIL PROTECTED]> wrote:
> At 12:20 PM +0100 12/13/07, Zoltán Németh wrote:
> >2007. 12. 12, szerda keltezéssel 20.13-kor tedd ezt írta:
> > > I would like to create a temporary table to perform searches.
> >>
> >> From my main table, I need to exclude records th
On Thu, 2007-12-13 at 10:14 -0500, tedd wrote:
> At 12:20 PM +0100 12/13/07, Zoltán Németh wrote:
> >2007. 12. 12, szerda keltezéssel 20.13-kor tedd ezt írta:
> > > I would like to create a temporary table to perform searches.
> >>
> >> From my main table, I need to exclude records that have cer
At 12:20 PM +0100 12/13/07, Zoltán Németh wrote:
2007. 12. 12, szerda keltezéssel 20.13-kor tedd ezt írta:
> I would like to create a temporary table to perform searches.
From my main table, I need to exclude records that have certain
fields that are null or empty; and then sort the final r
2007. 12. 12, szerda keltezéssel 20.13-kor tedd ezt írta:
> Hi gang:
>
> Another mysql question.
>
> I would like to create a temporary table to perform searches.
>
> From my main table, I need to exclude records that have certain
> fields that are null or empty; and then sort the final result
tedd wrote:
Hi gang:
Another mysql question.
I would like to create a temporary table to perform searches.
From my main table, I need to exclude records that have certain fields
that are null or empty; and then sort the final result.
Should be possible without a temp table I think..
I've
Hi gang:
Another mysql question.
I would like to create a temporary table to perform searches.
From my main table, I need to exclude records that have certain
fields that are null or empty; and then sort the final result.
I've spent over an hour looking at "How do I set up a temporary table
Cima wrote:
hi,
im working with php 4 and postgresql 8 and in my php script id like to create a
temp table on my database server. how do i do this? how do i verify it was
created?
Well if the creation fails pg_query will throw an error. However temp
tables are only good for the life of the conne
On Wed, April 27, 2005 9:45 pm, Cima said:
> im working with php 4 and postgresql 8 and in my php script id like to
> create a temp table on my database server. how do i do this? how do i
> verify it was created?
>
> i tried the following:
>
> $sql = "create temp table s_info(a int, b text) on comm
hi,
im working with php 4 and postgresql 8 and in my php script id like to create a
temp table on my database server. how do i do this? how do i verify it was
created?
i tried the following:
$sql = "create temp table s_info(a int, b text) on commit delete rows ";
pg_query($dbh,$sql);
$dbh i
15 matches
Mail list logo
