RE: Select Earliest Related Row

em_id) Group by class_name, c. item_id I did not check it in DB and it can have some parse errors. But It should work. Best Regards, Pavel Zimahorau -Original Message- From: Don Wieland [mailto:d...@pointmade.net] Sent: Tuesday, February 09, 2016 6:57 PM To: MySql Subject: Select Ear

Re: Variable for row number?

BY clause, you are not guaranteed to get >> your rows back in any particular order. As you want the top 10 listings >> sorted by n24 for the country 'UA', you still need the ORDER BY to make >> this a deterministic query. SG> You do not need to sort by n24 in this la

Re: Variable for row number?

On Fri, Mar 12, 2010 at 11:37:16PM +0100, Carsten Pedersen writes: CP> Pavel Gulchouck skrev: >> Is there any way to get sequence row number in request? >> I need row number calculated before "having" but after "group by" >> and "order", so &q

Variable for row number?

Hi! Is there any way to get sequence row number in request? I need row number calculated before "having" but after "group by" and "order", so "select @row := @row+1" unsuitable in my case (it executed before grouping). -- Pavel -- MySQL Gene

Re: very slow select with join

ef | PRIMARY | PRIMARY | 8 | servis_info3.e3.partnerid |1 | | ++-+---++---+-+-+-+--+---+ -- Thanks, Pavel Novak -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: very slow select with join

7;0', `express` tinyint(3) unsigned NOT NULL default '0', PRIMARY KEY (`id`), KEY `brandid` (`brandid`), KEY `productid` (`productid`), KEY `customerid` (`customerid`), KEY `orderid` (`orderid`), KEY `createdby` (`createdby`,`changedby`), KEY `completed` (`completed`,

very slow select with join

PRIMARY | PRIMARY | 8 | servis_info3.cal.engineerid | 1 | Distinct| | 1 | SIMPLE | pr| eq_ref | PRIMARY | PRIMARY | 8 | servis_info3.e3.partnerid | 1 | Using index; Distinct | ++-+---+----+----

Data mining

Hello, Does anybody use MySQL for dataminig such as clustering or decision trees? Is there anything that can be integrated with the database or do you use some other software? Thank you With regards, Pavel Kusch - Before

MySQL and data mining

Hello, Please do you know about any good solution for data mininig (clustering, decision trees ..) that works fine with MySQL. Thank you With regards, Pavel Kusch - Before posting, please check: http://www.mysql.com

MySQLGUI: Win32 zipped binary seems corrupted

Hi, I've just tried to download the Win32 binaries of the MySQLGUI tool. I recieved about 50kB. When I tried to unpack the archive, WinCommander told me, that the zip archive is corrupted. Hope it helps, thanx guys for wonderfull MySQL.

binaries not stripped Subject: mysqlshow doesnt work properly

>Description: 2 problems with MySQL-3.23.49a-1 (linux x86 rpm) 1) binaries not stripped (= 40MB !!!) 2) mysqlshow doesnt work properly >How-To-Repeat: from /etc/my.cnf: [client] socket = /tmp/.mysql.sock (work)~$ mysqlshow mysqlshow: Can't

[Bug in replications] "set character set" don't work

with *slave* only. >Submitter-Id: >Originator:Pavel Andreew >Organization: Ekaterinburg Telegraph >MySQL support: none >Synopsis: "set character set cp1251_koi8" don't work on slave server >Severity: serious >Priority: low >Category:

Migration to mysql from MS SQL Server

Hi everybody, I am trying to migrate a database from MS SQL Server 2000 to mysql. Does anybody know any source of information on this matter, or can anybody share his/her own experience of such a migration? Suggestions? Any help would be appreciated. Thanks, Pavel

UDF

Hi, All. I have tried to add UDF, but has received a error 1105. The beginnings to understand and has found out, I do not have table "func" in base "mysql". Help me, please! What structure it has? -- Best regards, Pavel mai

comp_err util

Hi, All. Help my, please! I can't compile MySQL util comp_err. Where can I find it as binary for Win32? -- Best regards, Pavel mailto:[EMAIL PROTECTED] - Before posting, please check:

Re: Problems with my.cnf

nsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Best regards, Pavel mailto:[EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http:/

Mysql doesn't allow to alias locked tables

SAM table "testtable" lock tables testtable write; select t.* from testtable t; -- mysql says "ERROR 1100: Table 't' was not locked with LOCK TABLES" >Fix: >Submitter-Id: >Originator:Pavel Kolesnikov >Organization: T

MyODBC

e_string' make: *** [execute.lo] Error 1 Pleas help Thanks -- S pozdravem Pavel Trefny = Pavel Trefny, Ticha 338, Blatna 38801 [EMAIL PROTECTED] tel. +420344421326 mob. tel. +420607643770, +420603921397 ICQ No : 20476221 se

distinct problem with join and order by

comments) results from me and my status comments (OK|BAD) >Fix: make distinct from last result, not from grouped row (from order by) ?? >Submitter-Id: >Originator:Pavel Riha >Organization: >MySQL support: none >Synopsis: problem with distinct when join an

Re: ERROR 1130: Host 'dhcp-70-219' is not allowed to connect to this MySQL server

pose you have to set up grants on the server side. See the manual (command "grant") how to allow the Win host (dhcp...) connect to the server (Solaris). Regards Pavel > thanks, > Kerry > > - > Before po

Re: date_format

e, import data or what? "DATE" structures in mysql tables use just numeral format, as far as I know... Pavel > > --Cindy - Before posting, please check: http://www.mysql.com/manual.php (the manual) ht

nested query alternative?

Hi, I just realized that mysql does not have nested queries, and I need to do something like this: update table1 set A="blah" where B=(select B from table1, table2 where table1.B=table2.B) Is it possible? Thanks, Jeff Pavel [EMAIL

Re: Perl5 needed ?

enough? > I think in the older discussion somebody said that the packager knows about that and in the next RPM it will be fixed. Now try to do: ln -s /usr/bin/perl5.005 /usr/bin/perl5 Regards Pavel > Martin, Omnisoft Sweden > > > ---