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 empty; and then
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
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.
why
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
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 certain
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 that have
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.
From my
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)) {
$ssql =
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 that have
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
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
12 matches
Mail list logo