Baron Schwartz wrote:
On Dec 20, 2007 7:16 AM, Sharon <[EMAIL PROTECTED]> wrote:
Baron Schwartz wrote:
Hi,
On Dec 20, 2007 2:15 AM, Sharon <[EMAIL PROTECTED]> wrote:
Hello all,
Given this table:
DROP TABLE IF EXISTS `maprimary`.`tbl_locales_ip2l`;
CREATE TABLE `maprimary`.`tbl_
Baron Schwartz wrote:
Hi,
On Dec 20, 2007 2:15 AM, Sharon <[EMAIL PROTECTED]> wrote:
Hello all,
Given this table:
DROP TABLE IF EXISTS `maprimary`.`tbl_locales_ip2l`;
CREATE TABLE `maprimary`.`tbl_locales_ip2l` (
`ipStart` int(10) unsigned zerofill NOT NULL default '00&
query takes about 3 sec.
But when I use this query:
SELECT * FROM `tbl_locales_ip2l` WHERE `ipStart` <= 374131916 AND
`ipEnd` >= 374131916;
The primary key is used.
The table contains about 3M rows.
Can anyone explain?
Thanks, Sharon.
--
MySQL General Mailing List
For list archives: http:
I have tryed to download the mysql manual.pdf but for some reason I cant.
Would
anyone be able to email me the pdf version?
[EMAIL PROTECTED]
Thanks
Sharon
-
Before posting, please check:
http://www.mysql.com
