Dear MySQL users,
MySQL Connector/Net 6.9.3 is the first GA release for the 6.9.x
series of the .NET driver for MySQL. It can be used for production
environments.
It is appropriate for use with MySQL server versions 5.5-5.7.
It is now available in source and binary form from
This is what I am doing.
mysql select * from new;
+--+--+
| c1 | c2 |
+--+--+
|5 |5 |
| 10 | 10 |
| 15 | 15 |
| 20 | 20 |
| 30 | 30 |
+--+--+
Now,
Session 1
mysql begin;
Query OK, 0 rows affected (0.00 sec)
mysql select * from new where
Can you try the same on a big table, I think optimizer is choosing a FTS
over an index lookup.
On Wed, Sep 3, 2014 at 8:25 PM, geetanjali mehra mailtogeetanj...@gmail.com
wrote:
This is what I am doing.
mysql select * from new;
+--+--+
| c1 | c2 |
+--+--+
|5 |
Dear Akshay,
Thanks for you reply, You are really great. Now , one more confusion.
mysql create table test.new as select id,name from City;
Query OK, 4079 rows affected (0.18 sec)
Records: 4079 Duplicates: 0 Warnings: 0
mysql select * from new limit 15;
++---+
| id