server changes my password

2001-08-20 Thread Tadej Guzej
Hi! This is wierd: Whenever I restart mysql server it somehow changes the password for user tadej@localhost. The password for tadej@'%' remains unchanged and I have to copy the password to the localhost entry. I am running mysql 3.23.38-nt on windows 2000 advanced server. Anyone knows how to fix

myODBC on Irix 6.5

2001-08-20 Thread Wen Tien
Hi all, I downloaded the latest Unix source of myODBC drivers but the configure script failed under Irix 6.5. ("Unexpected end of file") I looked at some web resources and it seems that many developers also have similar difficulties configuring/compiling myODBC for Irix. I was wondering

Stability of Windows installation of MySQL 3.23.38

2001-08-20 Thread Jerry van Leeuwen
Are there any known stability issues with installing MySQL under Windows 9x? By this I mean actual issues with the MySQL server itself, because I realise Windows 9x itself is not the most stable option available. Is there any reason to believe that this combination results in more regular tab

SELECT COUNT(*) question ...

2001-08-20 Thread G r e g L a w r i e
Howdy all, I have two tables as described further down below ... I use the following query to get the data I need ... sql = "SELECT tblTempConsolidation.*, tblCustomer.customerLibrary FROM tblCustomer, tblTempConsolidation WHERE tblCustomer.customerId = tblTempConsolidation.customerId AND tblTe

problems with cin.ignore()

2001-08-20 Thread Malkhaz Mangoshvili
Hello. My name is Mike. I am writing a c++ program which uses mysql++. In my program I used cin.ignore() function in order to flush the stdin. When I try to compile, it gives me such an error message: no matching function for call to _IO_istream_withassign::mysql_ignore()'. I created one t

bianary dist, of 3.23.41 ... >>

2001-08-20 Thread Andre Mercado Divoff
hi all, is there a way i can install the rpm's with a path of /usr/local/mysql ? or how would i go by confguring to install in that path using the src.rpm ? TIA Andre __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yaho

Fw: Correction added= replace/insert into

2001-08-20 Thread Network
Sorry for the duplicate msg. I forgot to state what version server I was running (next line) server version: 3.23.32 - Original Message - From: "Network" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, August 20, 2001 11:38 PM Subject: replace/insert into ... 150,000 -plus rows

replace/insert into ... 150,000 -plus rows

2001-08-20 Thread Network
The problem= The 'addy1' column or field (in attdata) is tainted with incorrect data entries ... e.g. 'addy1' should only have addresses stored however, some bright person(s) have managed to input company names in the address/addy1 field. I'm presented the task of fixing this data before incorpora

compilation problem

2001-08-20 Thread kennethchao
>Description: When I compiled my program with the new installed "mysql-3.23.41-pc-linux-gnu-i686" binary version I got the following eror message: gcc -I. -I/usr/local/mysql/include regprg.c net.o util2k.o httppost.c syslog.o -o regprg -L. -L/usr/local/mysql/lib -lmysqlclient /usr/local/mysql/

Re: innodb on linux raw partitions

2001-08-20 Thread Christian Jaeger
On Mon, 20 Aug 2001 22:24:26 +0300 "Heikki Tuuri" <[EMAIL PROTECTED]> wrote: > My impression comes from a MySQL AB computer > with Red Hat 6.2 (kernel something like 2.2.19). >From what I read, RedHat often patches their kernels with inofficial stuff (and the >famous inofficial/buggy gcc thing (

information about ADODB for PHP4

2001-08-20 Thread Jochen Kaechelin
is there a source for further information connecting to databases with ADODB for PHP4? I only know http://php.weblogs.com/ADODB -- WA-P : Jochen Kaechelin Programmierung - Beratung - Hosting Stuttgarter Strasse 3, D-73033 Göppingen Tel. 07161 - 92 95 94, Fax 92 95 98 --

mySQL v.3.23.41 - Brazilian Portuguese Error Messages Files Update

2001-08-20 Thread Roberto de Martin Serqueira
Hello,   I'm forwarding you the attached file named - mysql_3.23.41_pt-brazil.zip -  which contains the updated Brazilian Portuguese idiom version of files ERRMSG.TXT and ERRMSG.SYS, to be parked in directory mySQL\share\portuguese. The translation of error messages to Brazilian Portuguese

notice from your webhost

2001-08-20 Thread webhost
This email is being sent to you on behalf of your current webspace provider. This message is not a spam or junk email, your email address was supplied to WebHosting.com You will not receive any more messages from WebHosting.com this is a one time special offer notice. WebHosting.com is offeri

Invalid authorization specification: Access denied for user: 'prodoc@ns' (Using password: YES)

2001-08-20 Thread Harry M. Aasterud
Dear Madam, Sir, I created a new user with : ./mysql -u root -p1234 mysql grant select,insert,update,delete,create,drop on prodoc to prodoc@"%" identified by '1234'; In my asp script that is opening the connection I use : cnnString = "DRIVER=org.gjt.mm.mysql.Driver;URL={jdbc:mysql://xxx.xxx.xx

Returned mail: Account "e_business" does not exist

2001-08-20 Thread GetResponse Postmaster
We were unable to deliver information because: Account "e_business" does not exist The FREE autoresponder service is provided by GetResponse.com >>> http://www.GetResponse.com/ - Transcript of session follows - ... while talking to getresponse.com >>> RCPT To:<[EMAIL PROTECTED]>

Aliasing

2001-08-20 Thread Hans Zaunere
Is there a way to have MySQL label columns returned from a select query with the complete column name, in table.column format? So if a column name is id, which is in the main table, can MySQL return main.id instead of just id. Sure I could alias each column, but if there is 30 columns, that's

Re: Help with a simple query ..

2001-08-20 Thread David Turner
Try this. I couldn't find if MYSQL supports not in's so I followed there outer joins. You can read up on in in the mysql manual, do a search on outer joins. select base.zipcode,properties.zipcode from base right join properties on base.zipcode=properties.zipcode where base.zipcode is null; On

Re: Cancelling a slave

2001-08-20 Thread Jeremy Zawodny
On Sun, Aug 19, 2001 at 02:39:36PM -0600, Michael Blood wrote: > > >I setup a slave on my database by placeing the correct lines in > /etc/my.cnf. > > > >I have since removed those lines and restarted the server but I still get > >this line error in my .err file. > > > > > >010819 14:31:13 Slave

RE: Help with a simple query ..

2001-08-20 Thread Carsten H. Pedersen
> I have 2 tables: > > bases, and properties > > base has a ZIPCODE field in the table, as does the properties table. > > I'm trying to find all bases that do NOT have a property in that zip code. > > What I've tried is: The general answer: http://www.bitbybit.dk/mysqlfaq/faq.html#ch7_10_0 In yo

UPDATE problem

2001-08-20 Thread Martin Kampherbeek
Hello, I have created a predictionscompetition and some code counts te total score of a match of a person. On the screen it workes, but in de database it goes wrong. Each person gets the total of the last person. There must be something wrong with the update statement. I hope someone can help m

explain query question

2001-08-20 Thread name nik name nik_two
sql optimize Please help me. I can't understand why i've got this results.I have very simple table with name cz Field TypeNullKey Default Extra Privileges tv int(11) MUL 0 select,insert,update,references rez_id int(11)

Help with a simple query ..

2001-08-20 Thread Chad Day
I have 2 tables: bases, and properties base has a ZIPCODE field in the table, as does the properties table. I'm trying to find all bases that do NOT have a property in that zip code. What I've tried is: select distinct cb.*, cp.* from classified_bases as cb left join classified_properties as

Re: innodb on linux raw partitions

2001-08-20 Thread Jeremy Zawodny
On Tue, Aug 21, 2001 at 03:37:28AM +0800, Tonu Samuel wrote: > On 20 Aug 2001 11:09:37 -0700, Jeremy Zawodny wrote: > > > Does this impression come from your bad experiences or those of > > others? I ask because we're about to upgrade one of our Linux MySQL > > servers to the 2.4.x kernel series

MySQL dump 8.9 and telephone field - need help

2001-08-20 Thread Jean Lambert
MySQL dump 8.9 is doing weird things on me, I wonder what's going on. I have the following SQL column type : com_tel_fax_cr char(3), com_tel_fax_no varchar(8), the com_tel_fax_no is for storing an seven-digit phone number and the '-', ie: 727-1163 When the data is dumped, all char and varchar

Re: innodb on linux raw partitions

2001-08-20 Thread Trond Eivind Glomsrød
Tonu Samuel <[EMAIL PROTECTED]> writes: > On 20 Aug 2001 11:09:37 -0700, Jeremy Zawodny wrote: > > > Does this impression come from your bad experiences or those of > > others? I ask because we're about to upgrade one of our Linux MySQL > > servers to the 2.4.x kernel series and are looking to

mysql@lists.mysql.com

2001-08-20 Thread root
>Description: >How-To-Repeat: >Fix: >Submitter-Id: >Originator:root >Organization: >MySQL support: [none | licence | email support | extended email support ] >Synopsis: >Severity: >Priority: >Category: mysql >Class: >Release:

Install Mysql in Ibm-Aix 4.3.2.0

2001-08-20 Thread Simone Cincotto Souto
Please, if anyone could help me. I have a question: - I give a download of mysql 3.23.41 for aix-ibm 4.3.3.0 (binary version), but my version of aix is 4.3.2.0, I don´t know if it is a problem. - The problem is that when I give the instalation command: shell> scripts/mysql_install_db I receiv

Re: Failover

2001-08-20 Thread David Turner
It looks like this will only run on Linux and I must either use Sparc Solaris or X86. I hate to implement the failover within the application. Thanks anyway, Dave On Mon, Aug 20, 2001 at 01:04:10PM -0700, Jeremy Zawodny wrote: > On Mon, Aug 20, 2001 at 09:28:20AM -0700, David Turner wrote: > >

Re: Problem with INSERT INTO ... SELECT

2001-08-20 Thread Philip Mak
On Mon, 20 Aug 2001, Michiel Leegwater wrote: > insert into table1 select Startnr, Tijd, Afstand, Slag, Datum, Opmerking, > CRvan,CRtot,PR,Categorie from table2; > > This doesn't work, it says "Column count doesn't match value count at row 1" > I understand the problem. But I can't use my ID colu

RE: Problem with INSERT INTO ... SELECT

2001-08-20 Thread Cord Thomas
Michiel i believe you need to tell the target what fields it will have too... INSERT INTO Table1 (A, B) SELECT Table2.A, Table2.B FROM Table2 Of course you can omit the Table2. part in this trivial case. making it INSERT INTO Table1 (A, B) SELECT A, B FROM Table2 -Original Message- Fr

Re: Failover

2001-08-20 Thread David Turner
Great, thanks, Dave On Mon, Aug 20, 2001 at 01:04:10PM -0700, Jeremy Zawodny wrote: > On Mon, Aug 20, 2001 at 09:28:20AM -0700, David Turner wrote: > > > > I have two identical primarily readonly databases that I want to be > > able to upgrade on the fly. What I want to be able to do is take one

Re: innodb on linux raw partitions

2001-08-20 Thread Tonu Samuel
On 20 Aug 2001 11:09:37 -0700, Jeremy Zawodny wrote: > Does this impression come from your bad experiences or those of > others? I ask because we're about to upgrade one of our Linux MySQL > servers to the 2.4.x kernel series and are looking to use software > RAID + ReiserFS on it. > > If that'

Re: Failover

2001-08-20 Thread Jeremy Zawodny
On Mon, Aug 20, 2001 at 09:28:20AM -0700, David Turner wrote: > > I have two identical primarily readonly databases that I want to be > able to upgrade on the fly. What I want to be able to do is take one > down and have all my connections redirected to the second database > automatically. I woul

Problem with INSERT INTO ... SELECT

2001-08-20 Thread Michiel Leegwater
Hello, This is the situation: Table1: ID Startnr TijdAfstand SlagDatum Opmerking CRvan CRtot PR Categorie Table2: Identical columns. What is the problem? I'm trying to append all the values from table2 to table1. I was trying this SQL query: insert into table1 s

Re: Replication and temporary tables

2001-08-20 Thread Jeremy Zawodny
On Mon, Aug 20, 2001 at 02:04:09PM -0500, Mike Wexler wrote: > > Is there any reason why I shouldn't create temporary tables on a > slave server? The tables only last until the client closes its > connection, they aren't visible to other clients. > > I don't do any > INSERT INTO SELECT ...

Re: RH Linux 7.1 - Source or Binary

2001-08-20 Thread Trond Eivind Glomsrød
[EMAIL PROTECTED] writes: > I have read conflicting reports in the MySQL documentation concerning which > type of MySQL is better to install in Linux - Source or Binary? Can some > of you please enlighten me to which type you prefer or which you have been > successful with? Source can be tuned

Re: Problem with nested delete - help

2001-08-20 Thread William R. Mussatto
On Sat, 18 Aug 2001, Ram wrote: > Date: Sat, 18 Aug 2001 06:16:39 -0700 (PDT) > From: Ram <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Subject: Problem with nested delete - help > > Hi, > > I have a problem with nested delete query. I want to > delete some record from one table based on the se

Re: innodb on linux raw partitions

2001-08-20 Thread Heikki Tuuri
Hi! My impression comes from a MySQL AB computer with Red Hat 6.2 (kernel something like 2.2.19). There were strange disk read errors. I tracked it down to a problem where 8 bytes sometimes were reset to zero at an 8 kB page boundary when the OS had read a large block of about 300 kB. Also, just

Replication and temporary tables

2001-08-20 Thread Mike Wexler
Is there any reason why I shouldn't create temporary tables on a slave server? The tables only last until the client closes its connection, they aren't visible to other clients. I don't do any INSERT INTO SELECT ... FROM --

RH Linux 7.1 - Source or Binary

2001-08-20 Thread Robert . Hoey
Good Afternoon, I have read conflicting reports in the MySQL documentation concerning which type of MySQL is better to install in Linux - Source or Binary? Can some of you please enlighten me to which type you prefer or which you have been successful with? Thank you in advance. -Rob *

Re: setting a character set

2001-08-20 Thread Sinisa Milivojevic
Tadej Guzej writes: > I'm trying to use a charset different than latin1. > I did this: > > I created a file - c:\my.cnf - and inserted the following text into it: > [client] > default-character-set=win1250 > > I restarted mysql server and I still have latin1. What am I doing wrong ? > > >

Re: mysql becomes slow

2001-08-20 Thread Sinisa Milivojevic
winnecon writes: > > -- > I am having the same kind of difficulty. Slow returns on results. > It may be bad database architecture or implementation (perhaps both), > but I need to be able to pick out text fragments . . . like %value%. > > I understand that indexes do not help with "LIKE %val

Re: innodb on linux raw partitions

2001-08-20 Thread Jeremy Zawodny
On Mon, Aug 20, 2001 at 07:35:17PM +0300, Heikki Tuuri wrote: > I have the impression that current sofware RAID is not reliable in > Linux. Does this impression come from your bad experiences or those of others? I ask because we're about to upgrade one of our Linux MySQL servers to the 2.4.x ke

Re: error creating webobjects tables with mysql

2001-08-20 Thread Paul Schreiber
here's another error: >ERROR 1064 at line 80: You have an error in your SQL syntax near 'id' at line 1 the offending line: >create index ad_sections id; according to the docs, the syntax is: CREATE [UNIQUE|FULLTEXT] INDEX index_name ON tbl_name (col_name[(length)],... ) so i

Re: mysql becomes slow

2001-08-20 Thread winnecon
-- I am having the same kind of difficulty. Slow returns on results. It may be bad database architecture or implementation (perhaps both), but I need to be able to pick out text fragments . . . like %value%. I understand that indexes do not help with "LIKE %value%" queries, is there anythin

setting a character set

2001-08-20 Thread Tadej Guzej
I'm trying to use a charset different than latin1. I did this: I created a file - c:\my.cnf - and inserted the following text into it: [client] default-character-set=win1250 I restarted mysql server and I still have latin1. What am I doing wrong ? Thanks, Tadej P.S. For the filter: da

error creating webobjects tables with mysql

2001-08-20 Thread Paul Schreiber
config: debian linux "testing", kernel 2.2.18pre21, mysql 3.23.36, webobjects 5 I copied the sql from eomodeler and am attempting to use it with mysql. it says: >ERROR 1064 at line 35: You have an error in your SQL syntax near ')' at line 1 here's an excerpt from the sql: 30 31 CREAT

libmysql - secure connection

2001-08-20 Thread Elizabeth Alderton
If I'm using libmysql to connect from Delphi to mysql - does it automatically provide a secure connection then? Regards Elizabeth

Re: Formatting the DATE field on a web page

2001-08-20 Thread Ian Barwick
Hi As the Perl hackers say, "tmtowtdt" (there's more than one way to do this) - you are free to do format your dates wherever you like. If you're that way inclined you could even do the formatting on the client side in JavaScript ;-) IIRC correctly PHP offers a lot of inbuilt date formatting wo

Re: FreeBSD and multiple daemons

2001-08-20 Thread Ken Menzel
Hi Jerry, Someone has already answered why the load stays at 1.3 to 1.5. Sounds like one query may be slowing down the others, mytop (/usr/ports/databases/mytop) might help identify that query also try enabling the slow-log and track down any long queries. Have you tuned any of the cache param

RE: MySQL OLEDB

2001-08-20 Thread Venu
Hi !!! )-Original Message- )From: Bruce Stewart [mailto:[EMAIL PROTECTED]] )Sent: Monday, August 20, 2001 8:41 AM )To: 'Roy, Steeve'; [EMAIL PROTECTED] )Subject: RE: MySQL OLEDB ) ) )Steeve, ) )I have had the same problem for months, with no solutions. )If you find a solution, please let

Re: Formatting the DATE field on a web page

2001-08-20 Thread Thomas Spahni
Hi Steve, have a look at the DATE_FORMAT(date,format) function. You can retrieve the date in exactly the format you want doing it on the SQL side. Thomas On Mon, 20 Aug 2001, pc wrote: > Hi people > > I am using mySQL and PHP for my web page database management thingy. I've > managed to get

Re: innodb on linux raw partitions

2001-08-20 Thread Heikki Tuuri
Christian, Linux raw partitions are of course supported. Peter Duffy already got them working with 3.23.40. In .41 I have removed data file size checks if you put the keyword 'newraw' or 'raw' after the file size. Look in the manual! The idea in using raw partitions is that then the i/o bypasses

Failover

2001-08-20 Thread David Turner
I have two identical primarily readonly databases that I want to be able to upgrade on the fly. What I want to be able to do is take one down and have all my connections redirected to the second database automatically. I would also like the same auto failover when a database crashes, because of

Formatting the DATE field on a web page

2001-08-20 Thread pc
Hi people I am using mySQL and PHP for my web page database management thingy. I've managed to get my date field from my Table into my page ($myDate). I was wondering, how would I format the date from -MM-DD format to something a bit nicer like DD/MM/YY ? Is this meant to be a SQL side thing

innodb on linux raw partitions

2001-08-20 Thread Christian Jaeger
Hello I read in http://www.mysql.com/doc/I/n/InnoDB_Disk_i_o.html that Innodb supports raw partitions on "some unixes". We look forward to use innodb on debian (intel): are linux raw partitions supported? Is it wise to try to use linux2.4 raw partitions with innodb on a production system? I h

RE: MySQL OLEDB

2001-08-20 Thread Bruce Stewart
Steeve, I have had the same problem for months, with no solutions. If you find a solution, please let be know. Thanks, Bruce -Original Message- From: Roy, Steeve [mailto:[EMAIL PROTECTED]] Sent: Mon, 20 August 2001 16:21 To: '[EMAIL PROTECTED]' Subject: MySQL OLEDB Hello, I us emysql

Re: synchronisation (replication)

2001-08-20 Thread Jeremy Zawodny
On Thu, Aug 16, 2001 at 12:20:07PM +, Neil Tompkins wrote: > Hello > > Below is a message I posted earlier. But what I'm really looking > for is does MySQL provide synchrosisation of data. If so, can > someone point me in the right direction Yes it does. It is described in the Replication

MySQL OLEDB

2001-08-20 Thread Roy, Steeve
Hello, I us emysql oledb driver to connect on my database. When I use that localy on the computer where mysql run, I can connect correctly on any of my database. When I try from another computer (where I have installed the MySQL oledb driver) I get this message. Why ? Test connection

Re: compile error - ld: cannot find -lrt

2001-08-20 Thread Sinisa Milivojevic
Faine, Mark writes: > Ok, so I've downgraded my compiler (gcc) to 2.95.3 since mysql seems to be > incompatible with 3.0, yet I'm still getting an error during the make: > > /usr/local/sparc-sun-solaris2.8/bin/ld: cannot find -lrt > collect2: ld returned 1 exit status > make[3]: *** [mysqld] Err

Re: Speaking of tree searches

2001-08-20 Thread Rene Churchill
Definitely pull the data out into an array with one large query. It'll be much faster than the thousands/millions of queries you'd be generating otherwise. Graph-theory problems like this go exponential really fast. Rene At 02:05 PM 8/20/01, you wrote: >Hans Zaunere wrote: >>Maybe it'

Corrupt key file

2001-08-20 Thread Robinson, Mike
Greetings, Had a problem with a mysql table. About a dozen columns, one of them being a text column. I had earlier had a fulltext index on this text column but removed it. Later on, with 104 records in the table, whenever anyone tried to update info in the text column portion of a row, mysql wou

compile error - ld: cannot find -lrt

2001-08-20 Thread Faine, Mark
Ok, so I've downgraded my compiler (gcc) to 2.95.3 since mysql seems to be incompatible with 3.0, yet I'm still getting an error during the make: /usr/local/sparc-sun-solaris2.8/bin/ld: cannot find -lrt collect2: ld returned 1 exit status make[3]: *** [mysqld] Error 1 make[3]: Leaving directory

Re: Documentation says DECIMAL is floating-point but it is fixed-point

2001-08-20 Thread Kloppenburg Ernst (FV/FLI) *
On Mon, Aug 20, 2001 at 06:39:55 -0600, Benjamin David Hildred wrote: > On Mon, Aug 20, 2001 at 02:00:29PM +0200, Kloppenburg Ernst (FV/FLI) * wrote: > > On Mon, Aug 20, 2001 at 06:06:22 -0600, Benjamin David Hildred wrote: > > > On Mon, Aug 20, 2001 at 11:08:47AM +0200, Ernst Kloppenburg wrote:

RE: mysql becomes slow

2001-08-20 Thread Michael Widenius
Hi! > "Sinisa" == Sinisa Milivojevic <[EMAIL PROTECTED]> writes: Sinisa> Carsten H. Pedersen writes: >> >> ... >> >> > Having 27 indexes and using queries with LIKE "%...%" is a nice >> > recepee for slowness. >> >> Why should having 27 indexes slow down a SELECT? >> >> / Carsten >> --

RE: normalization question

2001-08-20 Thread Rene Churchill
You'll need a left join to do that query. Something like: select member.id, member.email, count(xref.email_id) as not_read from member left join xref on member.id = xref.member_id where not_read == 0 and xref.email_id = 283 group by member.id; where xref is the email/member cross reference tab

Re: Documentation says DECIMAL is floating-point but it is fixed-point

2001-08-20 Thread Benjamin David Hildred
On Mon, Aug 20, 2001 at 02:00:29PM +0200, Kloppenburg Ernst (FV/FLI) * wrote: > On Mon, Aug 20, 2001 at 06:06:22 -0600, Benjamin David Hildred wrote: > > On Mon, Aug 20, 2001 at 11:08:47AM +0200, Ernst Kloppenburg wrote: > > > >Description: > > > with DECIMAL the number of digits before and aft

RE: Any good book

2001-08-20 Thread Simon Green
My SQL By Paul DuBois ISBN 0-7357-0921-1 Very good book and mostly upto date. Also spend some time on mysql.com as the on line stuff is very good and fre Simon -Original Message- From: Jaitly, Rajiv (Contractor) [mailto:[EMAIL PROTECTED]] Sent: 20 August 2001 10:45 To: '[EMAIL PR

Re: Speaking of tree searches

2001-08-20 Thread Frank Fisher
Hans Zaunere wrote: > Maybe it's just me, but it sounds like you need to > reconsider you're database structure. I can't think > of any reason that such a schema would be required. It's simply a database of locations on the globe, and I need to calculate how to get to one place from another u

Re: Documentation says DECIMAL is floating-point but it is fixed-point

2001-08-20 Thread Kloppenburg Ernst (FV/FLI) *
On Mon, Aug 20, 2001 at 06:06:22 -0600, Benjamin David Hildred wrote: > On Mon, Aug 20, 2001 at 11:08:47AM +0200, Ernst Kloppenburg wrote: > > >Description: > > with DECIMAL the number of digits before and after the decimal > > point is fixed. Thus it should be described in the documentation a

Re: Documentation says DECIMAL is floating-point but it is fixed-point

2001-08-20 Thread Benjamin David Hildred
On Mon, Aug 20, 2001 at 11:08:47AM +0200, Ernst Kloppenburg wrote: > >Description: > with DECIMAL the number of digits before and after the decimal > point is fixed. Thus it should be described in the documentation as a > fixed point number > >How-To-Repeat: the manual is correct. the number

Re: Speaking of tree searches

2001-08-20 Thread Hans Zaunere
--- Frank Fisher <[EMAIL PROTECTED]> wrote: > I have an upcoming project which will require me > doing a recursive > function in PHP, doing a tree calculating optimum > route between defined > points in the database. Maybe it's just me, but it sounds like you need to reconsider you're databa

mySQL memory leaks !!! (?)

2001-08-20 Thread Jakub Trzetrzelewski
Hi I have a mysql server: mysqld Ver 3.23.33 for pc-linux-gnu on i686 I use C API to communicate with database, a simple connection could look like this: -- test.c -- #include #include int main() { MYSQL *conn; conn = mysql_init(NULL); if (!m

Re: how to create a table and a column..?

2001-08-20 Thread Gerald R. Jensen
You have to create a database first, then tell MySQL to use that databases. mysql>CREATE DATABASE myfirstdb; mysql>USE myfirstdb; mysql>CREATE TABLE tableone - Original Message - From: "B. van Ouwerkerk" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, August 20, 200

Re: Problem with Win32 MySQLGUI 1.7.5

2001-08-20 Thread Sinisa Milivojevic
Shu Xiao writes: > > Hi, > > I notice a problem with Win32 MySQLGUI 1.7.5. When I get the > result for the query. I see the escape character \ was not removed > in the result table window. Anybody notice the same problem? > > Thanks, > > Shu > Yes, all cells are escaped in order to display a

Re: ANNOUNCE: MyVCC-0.3.2.pre-alpha released

2001-08-20 Thread John Dean
Hi At 02:12 20/08/2001 -0700, Shu Xiao wrote: >Hi John, > >I can understand what you are explaining. But I am puzzled by the fact that >the other GUI client works but MySQL VCC doesn't, although I don't like the >other one much (it is somewhat slow). You can see from the first snapshot that >I s

Re: are MySQL Queries limited to they ahdere to Ansi SQL?

2001-08-20 Thread Ian Barwick
On Saturday 18 August 2001 14:37, Darragh Duffy wrote: > > Hi Folks > > below is a seltion of queries all doing very similar things I have run all > on Oracle 7 and 8i and all work fine. but only number 2 works in MySQL. So > does this suggest that MySQL is not fully compliant with Ansi SQL? > >

Re: how to create a table and a column..?

2001-08-20 Thread chikhing
good and easy tutorial http://devshed.com/Server_Side/MySQL/Intro/ At 10:25 AM 8/20/2001 +0800, louie miranda wrote: >i know this is easy for some of you guys, >im just starting making some tables and column.. > >and can't figure out how, ive read the manual and can't seem >to understand it yet

Any good book

2001-08-20 Thread Jaitly, Rajiv (Contractor)
Hi, Could you please recommend any good book that explain MySQL (installation, maintenance, SQL and stored procedure) also JDBC (from Servlet and EJB) Thanks Raj - Before posting, please check: http://www.mysql.com/manual.p

Documentation says DECIMAL is floating-point but it is fixed-point

2001-08-20 Thread Ernst Kloppenburg
>Description: with DECIMAL the number of digits before and after the decimal point is fixed. Thus it should be described in the documentation as a fixed point number >How-To-Repeat: >Fix: >Submitter-Id: >Originator: >Organization: Dr. Ernst Kloppenburg Robert B

Re: ANNOUNCE: MyVCC-0.3.2.pre-alpha released

2001-08-20 Thread Shu Xiao
Hi John, I can understand what you are explaining. But I am puzzled by the fact that the other GUI client works but MySQL VCC doesn't, although I don't like the other one much (it is somewhat slow). You can see from the first snapshot that I specified database name as "samp_db". In what sense wa

REPLACE or UPDATE/INSERT ?

2001-08-20 Thread Stephan
Hi all, my situation: I generate 300 rows at a time - they should be stored in the a mysql table. 99 % of the keys of these rows already exist in the table, so these rows need an update. The remaining 1 % have to be inserted in the table. I was wondering if it is a good idea to to this with 30

Re: ANNOUNCE: MyVCC-0.3.2.pre-alpha released

2001-08-20 Thread John Dean
Hi This error dialog is based on what is returned from the MySQL server. The mysql driver QMYDQL3 does nothing more than pass your log on parameters to libmysql.dll which in turn interacts with the MySQL server. If there is a problem connecting the server returns the appropriate error and all M

Porting database

2001-08-20 Thread Frank Fisher
I just got a W2K-based server up and put the database on it. Now that machine's suddenly gone and I've been given a new Linux server with MySQL on it (okay, I'm happy about that part). But I only have a backup of the MySQL folder from the old machine. And I've been told I can't have the data

Data Security

2001-08-20 Thread Elizabeth Alderton
Hi everyone Does anyone know if a secure socket is automatically established when: 1.The server running my-sql (a unix box) is secure and 2.You use Delphi, via Zeus components, to connect to it and upload/download data ? Thanks everyone! Regards Elizabeth

Speaking of tree searches

2001-08-20 Thread Frank Fisher
I have an upcoming project which will require me doing a recursive function in PHP, doing a tree calculating optimum route between defined points in the database. The function is going to have to do a SELECT on the MySQL database on each iteration. It could concievably do thousands of iterat

Using MySql with Database

2001-08-20 Thread Rohit Pandey
Hi, Any pointers as to how can mysql database can be used with Weblogic. If it can be... TIA, Rohit

Re: Replication

2001-08-20 Thread Jeremy Zawodny
On Sun, Aug 19, 2001 at 10:50:58PM +0200, Michael Großegesse wrote: > Hi > > I'd like to know if it is possible to scp the database files to a > backup server while mysql is still running on both machines? As long as you are careful to flush and lock tables when you do it, yes. > Alternatively,

Re: Explanation: Problems with MYSQL-D-MAX for win 98 DROP TABLE

2001-08-20 Thread Luciano Pulvirenti
I have tried to install Mysql 3.23.40 again. The problem also persists using the program directly mysql.exe of the directory mysql/bin and with an access ODBC performing the same commands. To the attempt to perform the command DROP TABLE the error it is always 1051. Thanks Regards Subject: Re

RE: Nesting Problem for Multilevel Marketing

2001-08-20 Thread Andres Berger
Hi For performance reasons, the best way to deal with the network is to separate it from your "clients" table because you would be searching the network heavily and if the table is short, that would be much faster. So, create a new table called "network" with only two integer fields, where you