RE: [PHP-DB] Difficulties in handling LIMIT queries
| From: | Wesley Choate | Date: | Fri, 11 Aug 2000 14:19:44 +0000 |
| Subject: | RE: [PHP-DB] Difficulties in handling LIMIT queries | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-1956@lists.php.net to get a copy of this message | ||
Okay..then before your select query you need to also do this
my_sql_query("set SQL_BIG_TABLES = 1");
Or something like that..you need to send the commend set SQL_BIG_TABLES = 1
to be queried before you do the select statment..
> -----Original Message-----
> From: João Barreto Fernandes [SMTP:barreto@convex.pt]
> Sent: Friday, August 11, 2000 9:17 AM
> To: João Barreto Fernandes; php-db@lists.php.net
> Subject: Re: [PHP-DB] Difficulties in handling LIMIT queries
>
> Sorry guys ...
> I am using MySQL with PHP under Apache (Linux and NT).
>
> Thanks in advance,
> Joao
> -------------------------------------------------------------
> Joao Barreto Fernandes - e-Business, Security, Accounting & Billing
> CONVEX Portugal - Informática e Sistemas de Comunicações, Lda
> Edf. Inovação III, 624 - 2780-920 Porto Salvo - Portugal
> barreto@convex.pt http://www.convex.pt +351 214229200
>
> ----- Original Message -----
> From: João Barreto Fernandes <barreto@convex.pt>
> To: <php-db@lists.php.net>
> Sent: Sexta-feira, 11 de Agosto de 2000 14:55
> Subject: [PHP-DB] Difficulties in handling LIMIT queries
>
>
> > Hi all ...
> >
> > I have a simple that many of you might find extremelly simple to answer.
> >
> > I have a DB with a table with around 50.000 rows. When I do a query
> > that gives me back around 15.000 rows, I have no problems in using
> > LIMIT x,y to get only a few of them. If a use some ordering I only get
> > back some values if the query (without the order by) would give me
> > back no so many rows.
> >
> > The error I get is 1114: The table 'SQL4677_0' is full
> >
> > Any ideas or workarounds? I am using indexes on the order columns.
> >
> > Thanks in advance,
> > Joao
> > -------------------------------------------------------------
> > Joao Barreto Fernandes - e-Business, Security, Accounting & Billing
> > CONVEX Portugal - Informática e Sistemas de Comunicações, Lda
> > Edf. Inovação III, 624 - 2780-920 Porto Salvo - Portugal
> > barreto@convex.pt http://www.convex.pt +351 214229200
> >
> >
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net
> > For additional commands, e-mail: php-db-help@lists.php.net
> > To contact the list administrators, e-mail: php-list-admin@lists.php.net
> >
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net
> For additional commands, e-mail: php-db-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net
>