Re: upgrade 3.23 -> 4.0.3 question

2002-09-01 Thread Varshavchick Alexander
I'm using 3.23.49 and it behaves perfectly. Okay I'll try 4.0.2 and see if it helps, thanks for the hint. Alexander Varshavchick, Metrocom Joint Stock Company Phone: (812)118-3322, 118-3115(fax) On Fri, 30 Aug 2002, Steven Roussey wrote: > Date: Fri, 30 Aug 2002 10:49:28 -0700 > From: Stev

MYSQL & DELPHI COMPONENTS

2002-09-01 Thread Nick Lazidis
I wonder if someone could tell me if I can use Delphi 6's , ClientDataSet, Query, DataSetProvider, Database and UpdateSQL components with MYSQL or I have to look at an alternative third party library. Does MYSQL supports transactions with InnoDB type tables ? Thanks Nikos ---

Application for Employment / Contract Work

2002-09-01 Thread Anthony Heller
*** Please Note: Do Not Use your Reply button if you wish to respond to this email *** *** Please reply to [EMAIL PROTECTED] *** Hello, I came across your website, and thought I would send you a copy of my CV / Resume (please scroll down the page) to see if you are in need of any help in pr

RE: delete rules in mysql

2002-09-01 Thread Chugh Shalini
Thankx Victoria, Now the things are working perfectly fine.. query, mysql > -Original Message- > From: Victoria Reznichenko [SMTP:[EMAIL PROTECTED]] > Sent: Thursday, August 29, 2002 7:08 PM > To: [EMAIL PROTECTED] > Subject: Re: delete rules in mysql > > Chugh, > Thursday, Augus

Problem installing

2002-09-01 Thread Scott Burnside
The instructions that I have to install MySQL, tells me to "cd to the bin directory and run this command: ./mysql_install_db" The problem is that my system can't find this file. Any suggestions? Thanks, Scott - Before posting

Re: mysql default charset

2002-09-01 Thread Paul DuBois
At 9:19 +0900 9/2/02, suresh wrote: >Go to mysqlAdmin >Go to my.ini setup >add >language = MYSQL_HOME/share/your_language_here >Save the changes That changes the language in which error messages are displayed, not the character set used for table data. > >Hope this will help > >regards >Kayamboo

Re: mysql default charset

2002-09-01 Thread suresh
Go to mysqlAdmin Go to my.ini setup add language = MYSQL_HOME/share/your_language_here Save the changes Hope this will help regards KayambooSuresh At 11:33 Χ΋ 02/09/01 +0300, you wrote: >Hi, >How can I set my mysqld-nt.exe to run different charset >for example cp1251. >I tried mysqld-nt.e

RE: mysql is driving me mad (3)

2002-09-01 Thread Tom Emerson
> -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Subject: [which I usually snip as it's redundant] Re: RE: mysql is driving me mad (3) [however it appears it would have avoided this:] > Your message cannot be posted because it appears to be either spam

RE: mysql is driving me mad (3)

2002-09-01 Thread Paul DuBois
At 20:56 +0100 9/1/02, Bob G wrote: >my sql problem > >Thanks for the mild rebuke paul. Not a rebuke, really. It's just that people cannot help you without information. > >I (re) created the table as follows ;- > >drop table clients; >create table clients( > purchasers_ID int, > pur

mysql default charset

2002-09-01 Thread Alexander Petrov
Hi, How can I set my mysqld-nt.exe to run different charset for example cp1251. I tried mysqld-nt.exe --default-charset-set=cp1251 but it started second instance of mysqld-nt and my MySQL did not order correctly cyrillic. Any help apreciated. SaS. ---

RE: mysql is driving me mad (3)

2002-09-01 Thread Bob G
my sql problem Thanks for the mild rebuke paul. I (re) created the table as follows ;- drop table clients; create table clients( purchasers_ID int, purchasers_name varchar (50), purchase_ID int, price decimal (7,2), dated varchar(50) ); I put the data a

Re: mysql is driving me mad (2)

2002-09-01 Thread Paul DuBois
At 19:50 +0100 9/1/02, Bob G wrote: >Hello all! As you will see I am very new to mysql (about three weeks) I am >running under windows 2000. My problem is simple. I have a programme with >three databases. Two went up fine but the third is proving obstinate. I have >a field defined with varchar (5

mysql is driving me mad (2)

2002-09-01 Thread Bob G
Hello all! As you will see I am very new to mysql (about three weeks) I am running under windows 2000. My problem is simple. I have a programme with three databases. Two went up fine but the third is proving obstinate. I have a field defined with varchar (50). No matter what I do it won't let me

Re: InnoDB: wild memory allocation size => server restarted

2002-09-01 Thread Heikki Tuuri
Yuri, looks like InnoDB was trying to allocate 4 GB + 232 bytes. A major bug in the 64-bit version was fixed in 3.23.52: July 20, 2002: On 64-bit computers updating rows whichcontained the SQL NULL in some column could cause theundo log andthe ordinary log to become corrupt. Fixed in 3.23.52. Howe

Re: Problem Installing mysql-3.23.52

2002-09-01 Thread David Lloyd
( mysql, query ) > Can anyone help. > I'm installing (at the mo) 4.0.3 Beta, but the error message is the same > which ever version.. > > libmysql.c: In function `mysql_real_connect': > libmysql.c:1675: warning: passing arg 5 of `gethostbyname_r' from > incompatible pointer type > libmysql.c:16

Problem Installing mysql-3.23.52

2002-09-01 Thread Doug Hall
Can anyone help. I'm installing (at the mo) 4.0.3 Beta, but the error message is the same which ever version.. libmysql.c: In function `mysql_real_connect': libmysql.c:1675: warning: passing arg 5 of `gethostbyname_r' from incompatible pointer type libmysql.c:1675: too few arguments to function

Re: JOIN?

2002-09-01 Thread DL Neil
Hi Justin, > ...the docs to be looking for examples. > > I have three tables... > cd (id, title, etc) > artist (id, name) > cd_to_artist (cdid, artistid) > Given an artist id, I want to retrieve all cds related to that artist, given > the information in the table cd_to_artist. The reason for the

JOIN?

2002-09-01 Thread Justin French
Hi all, First post, so be gentle :) I have a query which is more complex (taking advantage of relational databases more) than I have ever done before... and I'm not sure where in the docs to be looking for examples. I have three tables... cd (id, title, etc) artist (id, name) cd_to_artist (cdi