Re: Win & Linux

2004-05-03 Thread Ivan Cukic (Foment)
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 | Another question how can see the compatibility of authentification? | I don't know. It should be written in docs... Anyway, try the next thing... Try to create a symlink for every db except for mysql. create a symlink /var/lib/mysql/db1 -> /mnt/onedis

Re: Win & Linux

2004-05-01 Thread Ivan Cukic (Foment)
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 | | 4) My question is: Is it possible that de datadir was the same to | Win and Linux because i can't duplicate my databases? The disk2 is | read and write. If it is possible, how? You can create a symlink. Have you tested compatibility between MySQL 5

Re: oblivious to the obvious

2004-04-23 Thread Ivan Cukic (Foment)
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 | $result = mysql_query("UPDATE sunday SET | a5_n_1='$sun_5a_n1',a5_t_1='$sun_5a_t1'") What do you expect the UPDATE command to return? I think that you have the error here: | while($row = mysql_fetch_array($result)) { and here | mysql_free_result($

UTF text sorting

2004-01-28 Thread Ivan Cukic (Foment)
IS it possible to force mySQL to sort letters in different order - for example BCADEFGHI... instead of ABCDEFGHI...? I ask this question 'cause when sorting Serbian cyrilic, I get some letters before A, but A should be the first (that mixture is produced because those letters are placed badly in

Re: Getting the Parent Table for Returned Columns in a Relational Search

2004-01-11 Thread Ivan Cukic (Foment)
David Hutchison wrote: I am new to the list and glad to joining the MySQL community. I am trying to ascertain the table to which each column in a MySQL record set belongs in a relational search query. There may well be duplicate column names across tables. How can I query MySQL to tell me the

Re: Change storage location

2003-12-21 Thread Ivan Cukic (Foment)
Mysql Mysql wrote: Hi All, I have newly installed mysql 3.23.54 in Red Hat 9 (The one which was bundled with the OS). And default the data storage file location went to /var/lib/mysql, how do I change the location to /mysql, I have also tried modifying my.cnf it didn't help. Any suggestion. -m

Re: Duplicate combination

2003-12-14 Thread Ivan Cukic (Foment)
fr0g wrote: I have a table with peoples names in 3 different languages. Fields are like: id, surname_english, name_english, surname_original, name_original, surname_greek, name_greek. What I want is to check if a person has been entered twice in that table. You can create unique index on (surname_

Re: Licence question

2003-12-08 Thread Ivan Cukic (Foment)
Does this mean that I must make all of my web sites non-commercial? (since I use mySQL as my main DBMS) This was sarcastic, not real question aiming the next sentence MySQL> "You need a license if you sell a product designed specifically for use with MySQL or that requires the MySQL server to fun

Re: Licence question

2003-12-07 Thread Ivan Cukic (Foment)
"You need a license if you sell a product designed specifically for use with MySQL or that requires the MySQL server to function at all. This is true whether or not you provide MySQL for your client as part of your product distribution." Does this mean that I must make all of my web sites non-co

Re: Mysql user

2003-12-05 Thread Ivan Cukic
Binay wrote: Hi all, Can any one tell me the command to list all mysql users ??? Thanks in advance Binay use mysql; select User from user; Ivan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Licence question

2003-12-05 Thread Ivan Cukic
Ivan Cukic wrote: 1. Free use for those who are 100% GPL 2. Free use for those who never copy, modify or distribute 3. Commercial use for everyone else Strange thing: How can SUSE redistribute mySQL when it is not 100% GPL? (It has MPL, ... also, beside commercial programs) Ivan -- MySQL

Re: Licence question

2003-12-04 Thread Ivan Cukic
1. Free use for those who are 100% GPL 2. Free use for those who never copy, modify or distribute 3. Commercial use for everyone else OK. But 2nd statement is not taken from GPL. Example: SUSE ships non GPL programs such as StarOffice (not OpenOffice), SUN ships Java etc. in it's Linux... This

Re: Licence question

2003-12-03 Thread Ivan Cukic
If you were to simply download and install MySQL at your company office, then write apps for in-house use at your company, then you have no license issues. Your apps would not need to be GPL, and you do not need a Mysql commercial license. This was discussed by a Mysql AB employee during the MySQL

Re: Newbie SELECT Question

2003-08-17 Thread Ivan Cukic
__ One World, one Web, one Program -- Microsoft promotional ad Ein Volk, ein Reich, ein Fuhrer -- Adolf Hitler __ http://alas.matf.bg.ac.yu/~mr02014 ___ _ _ _ __ ___ _ / __/___ __ | __| _ _ ___ \ / _/ / . / _\/\ | _| \ \/ / ._\

Re: significant digits for division

2003-07-22 Thread Ivan Cukic
-- Adolf Hitler __ http://alas.matf.bg.ac.yu/~mr02014 ___ _ _ _ __ ___ _ / __/___ __ | __| _ _ ___ \ / _/ / . / _\/\ | _| \ \/ / ._\ Ivan Cukic, Form

Re: select * into outfile;mysql-delphi

2003-06-24 Thread Ivan Cukic
Rahmat> 2. how can i use mysql with delphi?please give me more explanation about it.. and must i have some application for it? Goto google and find "TmySQL delphi component". You will get the examples there too. Ivan --

Re: mysql access error 1044 - update

2003-06-23 Thread Ivan Cukic
If you want to set the root password you can do the next thing 1. kill the mysqld 2. start mysqld with --skip-grant-tables option 3. set the new password with mysqladmin -u root password 'RogerTheRabbit' command 4. and finally - mysqladmin -h hostname flush-privileges instead of 3 and 4 you

Re: support for Prepared statement

2003-06-19 Thread Ivan Cukic
Deepak> I wrote a program to check for Stored Procdures is running fine. Deepak> Now what i want to knwo is whether MySQL server is supporting Stored Procedures or not? Not yet, but will be supported in the 5.o version. Ivan --

Symlink

2003-06-15 Thread Ivan Cukic
Hi. I have the next problem: I have two OSs - Linux (mdk9.1) and Windows (98se) - installed on one of my computers, and on both I've installed the mySQL server. Problem is that I want to have completely identical databases on both systems - when I change something in Windows' DBs, I want it to be c