Just by curiosity is there any difference between this 2 queries
select * from users where users_id=10
and
select * from users where users_id='10'
assuming that the users_id column is of type integer primary key (if it
would be varchat I know there is a big difference)
Gilles Dumangin writes:
> Hi,
>
> I have a strange problem happening. I have created an application on a PC
> with Mysql-3.23.22-beta and I have different results than on a standard
> Mysql-3.23.35.
>
> The main problem seems to be at the following:
>
> Say have 6 rows with a column
Hi,
I have a strange problem happening. I have created an application on a PC
with Mysql-3.23.22-beta and I have different results than on a standard
Mysql-3.23.35.
The main problem seems to be at the following:
Say have 6 rows with a column name "actif", out of these 6 rows 3 have a
NULL va
I am having trouble getting this query to run faster:
SELECT * FROM t1 WHERE col1 = 'text' OR col2 = 'text';
Here is the output of the explain for that query
+---+--+---+--+-+--+--+-
---+
| table | type | possible_keys | key | key_len | r
