On 10/15/06, Freebat Wangh <[EMAIL PROTECTED]> wrote:
mysql> explain select lw.id, lw.sender as guest_id from gossip lw where
lw.owner = 21821 order by lw.id desc limit 18540, 20\G;
*** 1. row ***
id: 1
select_type: SIMPLE
t
where
lw.owner= 21821 order by
lw.id desc limit 18540, 20;
Shen139 wrote:
> I don't understand why you are using an index like `owner_id` composed
> by `owner` and `id`!
> I think that you should change it removing `id` from the fields list:
> ...
> PRIMARY KEY (`id`),
On 10/15/06, Timothy Wu <[EMAIL PROTECTED]> wrote:
Hi,
hi
My MySQL on Debian is on version "4.0.24_Debian-10sarge1-log". I have a
varchar(255) as a primary key for a table. I have found the primary key
case
insensitive. Is this normal?
Yes, it's normal!
To force mysql to use case-sensiti
I don't understand why you are using an index like `owner_id` composed by
`owner` and `id`!
I think that you should change it removing `id` from the fields list:
...
PRIMARY KEY (`id`),
KEY `owner_id` (`owner`)
...
On 10/15/06, freebat <[EMAIL PROTECTED]> wrote:
this is the table:
CREATE TA
Hi,
You can simply use the following query:
ALTER IGNORE TABLE ADD UNIQUE INDEX(cli,type,status);
On 9/25/06, gerodim <[EMAIL PROTECTED]> wrote:
Hi there, I have this serious issue about a db i have to work with
Thing is there is a table called cpsorders
This table has a structure
On 4/12/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
> Hi to all,
hi
I have to build a search of products on web catalog site. It has to search
> a whole words to avoid when somebody search for a pin and get "*pin*k
> shirt".
> I was suggested to use MATCH() AGAINST() and it works perfect
You should use:
SELECT username FROM workflow.user WHERE username LIKE BINARY 'NicO' LIMIT
1;
reference:
http://dev.mysql.com/doc/refman/5.0/en/string-comparison-functions.html
On 12/12/05, Nico Sabbi <[EMAIL PROTECTED] > wrote:
>
> Hi,
> my mysql always executes case insensitive queries:
>
>
>
