Hi All,
We have an application that needs to update rows in the database 'as fast
and efficiently' as possible.
To this end, we've tried re-designing the table - can someone clarify the
following assumptions we're about to make?
1. Fixed length CHAR fields are quicker to update than VARCH
--On 22 August 2004 21:05 +0800 Manisha Sathe <[EMAIL PROTECTED]>
wrote:
I want to select first 10 records out of 100. And then get the 10th
position.
If i make use of
order by score asc limit 1
then I will get 100th record, How shall i pick up 10th position?
I'm not quite sure I follow what you
--On 22 August 2004 20:31 +0800 Manisha Sathe <[EMAIL PROTECTED]>
wrote:
I am having more than 10 records in a table. I want to select only first
top 10 records (depending on one field score) and then want to select
10th position record.
select * from table1 order by score desc LIMIT 10
This wil
On 05 August 2001 23:42 -0700 Schajee Achmad wrote,
> now I get this error "Access Denied
> for user: 'root@localhost' (Using password: NO).
>
> I've tried several ways o get out of this mess, even
> the documentation of MySQL but there is no mention of
> this error.
Run up mysql with the '--ski
