order by "version number"

Hi, in my table I have one varchar(20) column where I store version number. Version looks like: 1.1.2 1.2.1 1.10.3 It is possible order this column in natural order (1.2 before 1.10)? Stano. -- Stanislav PaÅka programÃtor, www skupina KIOS s.r.o. tel: 033 / 794 00 18 -- MySQL General Mailing List

Re: concat multirow subselect

Michael Stassen wrote: Stano Paska wrote: Hi, it is possible to ? I have two tables. create table aaa (id int auto_increment not null, title varchar(255), primary key (id)); create table bbb (id int auto_increment not null, fk_aaa int not null, detail varchar(255), primary key (id)); insert into

concat multirow subselect

Hi, it is possible to ? I have two tables. create table aaa (id int auto_increment not null, title varchar(255), primary key (id)); create table bbb (id int auto_increment not null, fk_aaa int not null, detail varchar(255), primary key (id)); insert into aaa values (1, 'aaa'), (2, 'bbb'); insert

Re: service problems

tly), problem is connecting on service. I forgot: netstat reports that mysqld 3306 port is in LISTEN state Stano. Pahlevanzadeh Mohsen wrote: Dear,You must run "mysqld.exe start" --- Stano Paska <[EMAIL PROTECTED]> wrote: Hi, I have one problem with service MySQL on Windows XP Home Ed

service problems

Hi, I have one problem with service MySQL on Windows XP Home Edition. I use unzipped version of MySQL. Problem occurs in version 4.1.2 alpha, 4.1.2b alpha, 4.1.3 beta, 4.1.3b beta. Let me explatin: I unzipped mysql into c:\mysql. Set some variables in my.ini (only default-character-set), install

Re: open notify

You explaination is very good. My application is in python with wxpython gui, it would be easy implement row deletion from lock-table in onclose event of dialog with details about person. (this is horrible sentence, maybe I wrote some semantical errors :)) Thank you for your time... Stano. [EMA

open notify

Hi, I am developing some network application with central database. I have table of persons and two dialog windows. One window is for viewing the list of persons, when user doubleclick on some person, second window appears. On this window user can modify data about this person. Nothing unusual.