Hi!
On Fri, Jun 13, 2014 at 3:59 AM, yoku ts. wrote:
> Hi,
>
> Would you try STRAIGHT_JOIN?
>
> mysql56> ALTER TABLE masik DROP KEY idx_test, ADD KEY idx_test(szam, id);
> Query OK, 0 rows affected (0.08 sec)
> Records: 0 Duplicates: 0 Warnings: 0
>
> mysql56> EXPLAIN SELECT e.id FROM masik m
Hi!
On Thu, Jun 12, 2014 at 1:36 PM, Antonio Fernández Pérez
wrote:
> Hi Lay,
>
> If I don't mistake, you can't eliminate "Using temporary" and "Using
> filesort" because you are using an "order by". Try the explain again
> removing order by and check the output.
Thank you, I know, without orde
Hi!
I have two tables:
CREATE TABLE `egyik` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`duma` varchar(255) NOT NULL,
PRIMARY KEY (`id`),
KEY `e_idx` (`duma`,`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
INSERT INTO `egyik` VALUES (1,'aaa'),(2,'bbb');
CREATE TABLE `m
Hi!
Can i use MySQL spatial functions directly, to compute distance
between two GPS coordinate pairs in WGS84 format?
Thank you!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
Hi!
I have a table:
CREATE TABLE IF NOT EXISTS `test` (
`id` int(11) NOT NULL auto_increment,
`cucc` varchar(255) character set utf8 NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
INSERT INTO `test` (`id`, `cucc`) VALUES
(1, 'egyszer'),
(2, 'ketszer'),
(3, 'ketszer'
