MySQL 4.1

2003-05-29 Thread Martin Hudec
Hello, can anyone tell me estimated production release for mysql 4.1? We are now testing it in development enviroment, and it looks like we will be utilizing its variable charsets per table, column etc. :). -- Martin Hudec -- :@: [EMAIL PROTECTED] :w: http

processlist

2003-04-01 Thread Martin Hudec
Hello all at mysql list, can anyone tell me, please, what kind of format is Time in PROCESSLIST? thanks -- Martin Hudec -- :@: [EMAIL PROTECTED] :w: http://www.corwin.sk :m: +421.907.303.393 "In google non est, ergo non est." - unknown IR

Re: remote login

2003-02-13 Thread Martin Hudec
rname -p -h XXX.XXX.XXX.XXX > > then I got message > > Error 1045: Access denied for user: 'username@machine_name' (Using > password: YES) > > What should I do?? > > Thanks, > Branko > sql, mysql -- Martin Hudec === :m:+421 907 303 393

Re: mysql limitations

2003-02-08 Thread Martin Hudec
o be file system than dB I think depending on the version. > > Jerry > > Apps-R&D > Cable and Wireless > -------- -- Martin Hudec === :m:+421 907 303 393 :@:[EMAIL PROTECTED] :w: http://www.corwin.s

Re: Can MySQL work on Windows XP?

2003-02-08 Thread Martin Hudec
onnect("localhost"); > if (! $link) > die ("Couldn't Connect"); > $db_res = mysql_list_dbs($link); > $num = mysql_num_rows($db_res); > for($x=0;$x < $num; $x++) > print mysql_tablename( $db_res,$x).""; > mysql_close($link); > ?> > > > > > > > --

mysql limitations

2003-02-07 Thread Martin Hudec
Hello, I would like to know what are limitations for mysql in number of records, size of records, size of tables etc. Can anyone help me please? -- Martin Hudec === :m:+421 907 303 393 :@:[EMAIL PROTECTED] :w: http://www.corwin.sk "In google non est, ergo no

phpmyadmin and mysql

2003-01-08 Thread Martin Hudec
Hello MySQL, we have this problem: when using phpmyadmin if we select database to view and we put SQL command to ENTER SQL QUERY/QUERIES TO DATABASE field and submit it, it will display NO SQL QUERYwhat is wrong? please help me...thank you -- Best regards, Martin

order results by count of searched expression

2002-12-12 Thread Martin Hudec
Hello mysql, I am trying to figure out sql command for ordering results descending by counts of searched expressions found in result. like this: $search="some"; TEXT | COUNTS | - Something has..| 4| Some have..| 3| Some take..| 1|

Re: Unable to Start the Server

2002-10-30 Thread Martin Hudec
Hello Jason, just pasting you something what appeared whiles ago... If you have Redhat, a GLIBC upgrade might have broken your MySQL installation. (Look in the mailing list archives). What happens when you telnet to port 3306 on your Linux database server from the machine Tomcat is running on?

getting name of columns

2002-10-29 Thread Martin Hudec
Hello, How can i extract names of columns from table? I am doing select * from table, then i want to get name of columnsis it possible? -- Best regards, Martin mailto:corwin@;corwin.sk for filter - sql and query --

Re[6]: [PHP-DB] database synchronization

2002-10-29 Thread Martin Hudec
Hello, see below... -- Best regards, Martinmailto:corwin@;corwin.sk Tuesday, October 29, 2002, 10:51:17 AM, you wrote: PL> Hi PL> If the records are all independant - ie travel agent (TA) A has their own PL> records and so does TA B then REPLACE INTO MainDB SELECT

Database sync

2002-10-29 Thread Martin Hudec
Hello Peter, okay :)))so far I understand...buthmmm let me explain I have server of travel agencies records (we need to update this, so it is slave) with stable IPand then bunch of other computers (from these we are updating...so they are all masters) in various travel agencies...

Re[4]: [PHP-DB] database synchronization

2002-10-29 Thread Martin Hudec
Hello Peter, okay :)))so far I understand...buthmmm let me explain I have server of travel agencies records (we need to update this, so it is slave) with stable IPand then bunch of other computers (from these we are updating...so they are all masters) in various travel agencies...