RE: Select Earliest Related Row

oup 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 <mysql@lists.mysql.com>

Re: Variable for row number?

. In fact, since we SG sorted the intermediate results and ranked them by the `rank` colum, I SG could have just as easily said SG SELECT * SG from rankme SG where country='UA' SG ORDER BY rank SG limit 10; -- Pavel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

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 General Mailing List For list archives: http://lists.mysql.com

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 select @row := @row+1 unsuitable in my case (it executed before

Re: very slow select with join

` (`completed`,`express`), KEY `orders` (`createdby`,`changedby`,`customerid`,`productid`,`brandid`,`scheduleid`) ) ENGINE=InnoDB DEFAULT CHARSET=latin2; -- Regards, Pavel Novak -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

Re: very slow select with join

| | ++-+---++---+-+-+-+--+---+ -- Thanks, Pavel Novak -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

very slow select with join

.partnerid | 1 | Using index; Distinct | ++-+---++---+-+-+-+---+-+ 9 rows in set (0.30 sec) -- Best Regards Pavel Novak -- MySQL General Mailing List For list archives

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. Pavel

binaries not stripped Subject: synopsis of the problem (one line) 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

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: mysql Class: sw-bug Release: mysql-3.23.47 (Source distribution) Server: /usr

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

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: http

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 mailto:[EMAIL PROTECTED

Re: Problems with my.cnf

-- Best regards, Pavel mailto:[EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request

Mysql doesn't allow to alias locked tables

write; select t.* from testtable t; -- mysql says ERROR 1100: Table 't' was not locked with LOCK TABLES Fix: Submitter-Id: submitter ID Originator:Pavel Kolesnikov Organization: Templation MySQL support: none Synopsis: Mysql doesn't allow to alias locked tables

MyODBC

Pleas help Thanks -- S pozdravem Pavel Trefny = Pavel Trefny, Ticha 338, Blatna 38801 [EMAIL PROTECTED] tel. +420344421326 mob. tel. +420607643770, +420603921397 ICQ No : 20476221 server network administrator Czech Republic

distinct problem with join and order by

status comments (OK|BAD) Fix: make distinct from last result, not from grouped row (from order by) ?? Submitter-Id: submitter ID Originator:Pavel Riha Organization: organization of PR author (multiple lines) MySQL support: none Synopsis: problem with distinct when

Re: date_format

ures 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) http://lists.mysql.com/ (the list archive) To re

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