Re: Looking for a bona fide distributed database that is open source

2003-03-17 Thread Gelu Gogancea
Hi Bruce, - Original Message - From: Bruce Feist [EMAIL PROTECTED] To: MySQL List [EMAIL PROTECTED] Sent: Sunday, March 16, 2003 7:03 AM Subject: Re: Looking for a bona fide distributed database that is open source Gelu Gogancea wrote: You make confusion between terms, CONCEPTS and

mysql and asp web hosting

2003-03-17 Thread Ivan Paul
dear all, i'm looking for a good service/performance for web hosting which support mysql for database and asp for web programming. would you give me some suggestions to choose the web hosting? thanks a lot cheers, Ivan Paul MySQL, Query

Locating Duplicate records always results in Error 127

2003-03-17 Thread mySQL list
I am locating 'duplicate entries in a table and updating a status field accordingly. The idea is to locate rows which have a matching 'Name' field, and mark them for subsequent processing. However, my update query *ALWAYS* returns Error 127, even on a newly created table if the matching name field

[Fwd: MySql++ compilation error on Aix with gcc3.2.1 (default argument given]

2003-03-17 Thread Olivier HARDOUIN
I tried to integrate, MySql++-1.7.9 with mysql-max-3.23.55-ibm-aix4.3.2.0-powerpc. I compiled with gcc3.2.1, and i passed the 2 patches for gcc3.0 and gcc3.2, on Aix4.3.2 How-To-Repeat: My configure contains: setenv CC /opt/gcc-3.2.1/usr/local/bin/gcc setenv CXX

Re: Foreign Key and default action/RESTRICT behaviour?

2003-03-17 Thread Heikki Tuuri
Paul, - Original Message - From: Paul DuBois [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, March 17, 2003 1:05 AM Subject: Re: Foreign Key and default action/RESTRICT behaviour? At 23:12 +0200 3/16/03, Heikki Tuuri wrote: Tor, - Original

Mysql and processor utilization

2003-03-17 Thread Sherif Diaa Mohamad
I installed mysql on Redhat Linux, I have a problem that it uses 85% of the processor making the idle time of the processor = 0 while I just hosted 1 site with php Is that normal or I have something wrong ? Best Regards Sherif Mohamad

Re: MySQL JDBC driver problem

2003-03-17 Thread Mark Matthews
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Shu-Ping Lin wrote: Hi, How are you? I have a problem to jdbc driver. My paltform is win2000 professional and MySQL Server's version is 3.23.55. I use jdbc driver of mysql-connector-java-3.0.6-stable.jar and i find some problems to this jdbc

SQL QUERY

2003-03-17 Thread maze . schaller
Problem with the following SQL Query: How do I combine DISTINCT with the SELECT * ? Is it SELECT DISTINCT * FROM...? This doesn´t work in my project. Best regards, Martin Schaller -- +++ GMX - Mail, Messaging more http://www.gmx.net +++ Bitte lächeln! Fotogalerie online mit GMX ohne

MySQL/InnoDB-3.23.56 is released

2003-03-17 Thread Heikki Tuuri
Hi! InnoDB is a MySQL table type which provides transactions, foreign key constraints, and a non-free Hot Backup tool. InnoDB is included in MySQL-Max-3.23.56 which you can download from http://www.mysql.com/downloads/mysql-3.23.html. MySQL-Max-3.23 is the stable version which is recommended

RE: mySQL activity logging on a dual prozessor maschine

2003-03-17 Thread Peter Stoehr
Hi Gelu, thanks for your message. But I'm not confused about the timeformat, I'm confused of the order the logs are. 1st: 19:31:18 2nd: 19:31:20 3rd: 19:31:18 (!) 4th: 19:31:20 (!) ... I don't know, what the problem is. Rgds, Peter -Original Message- From: Gelu Gogancea

problème d'install de mysql sur hp-ux

2003-03-17 Thread Jerome JAMET
Bonjour , J'essai d'installer Mysql sur un serveur HP-UX B.10.20 U 9000/800 unlimited-user license, et lors du lancement de celui ci , j'ai la creation d'un fichier core /scripts/mysql_install_db[292]: 22671 Memory fault(coredump) . Y a t'il une

synopsis of the problem (one line)

2003-03-17 Thread root
Description: How-To-Repeat: Fix: Submitter-Id: submitter ID Originator:root Organization: MySQL support: [none | licence | email support | extended email support ] Synopsis: Severity: Priority: Category: mysql Class: Release:

remote connection with JDBC

2003-03-17 Thread Erwin Adi
I can connect to MySQL through JDBC with the following URL without any problem: jdbc:mysql://localhost:3306/mydatabase However, when I simulate the above URL as though I'm calling from a remote machine using the following URL, jdbc:mysql://192.168.0.10:3306/mydatabase I got the following exception

Re: VB6 ODBC Memory problems

2003-03-17 Thread Bruce Lewis
My first recommendation is to switch to ADO. It is much faster. Bruce Lewis - Original Message - From: Thomas Bein [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, March 16, 2003 12:55 PM Subject: VB6 ODBC Memory problems Hello, I have been developing an application in VB60

column named force not allowed

2003-03-17 Thread Peter O
Description: When creating a table with a column named force an error is shown and the table is not created. How-To-Repeat: When trying to do this : CREATE TABLE testcase ( force int default NULL ) TYPE=MyISAM; I get this : ERROR 1064: You have an error in your SQL syntax. Check the

Re: remote connection with JDBC

2003-03-17 Thread Mark Matthews
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Erwin Adi wrote: I can connect to MySQL through JDBC with the following URL without any problem: jdbc:mysql://localhost:3306/mydatabase However, when I simulate the above URL as though I'm calling from a remote machine using the following URL,

Re: Update to one of three values.

2003-03-17 Thread gerald_clark
Maybe I am missing something, but why not: UPDATE T SET T.Data = 1 WHERE . . . With only 2 fields, what could be in your WHERE clause? Hu Qinan wrote: A table T contains two fields: T.ID, T.Data. I want to set its T.Data to one of three values: NULL, 0, 1 according to its T.ID. This is what I

Re: mySQL activity logging on a dual prozessor maschine

2003-03-17 Thread Gelu Gogancea
Hi Peter, - Original Message - From: Peter Stoehr [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: Gelu Gogancea [EMAIL PROTECTED] Sent: Monday, March 17, 2003 3:56 PM Subject: RE: mySQL activity logging on a dual prozessor maschine Hi Gelu, thanks for your message. But I'm not confused

MySQL 3.23.56 has been released

2003-03-17 Thread Lenz Grimmer
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, MySQL 3.23.56, a new version of the popular Open Source Database, has been released. It is now available in source and binary form for a number of platforms from our download pages at http://www.mysql.com/downloads/ and mirror sites. Note that

mySQL stops responding in the morning

2003-03-17 Thread amit . mehta
I have an app running on Tomcat 4.0.6. The app access mySQL Ver 11.18 Distrib 3.23.54, for sun-solaris2.9 (sparc) on Solaris 9. the app runs fine during the day, but when I come back to work in the morning, I see that the database connection has died and mySQL does not respond anymore. What

EMS MySQL Manager for Linux 1.15 released!

2003-03-17 Thread EMS HiTech Team
EMS HiTech company is very glad to announce MySQL Manager for Linux 1.15 -- the next version of our powerful MySQL administration and development tool! You can download the latest version and user's guide from http://www.mysqlmanager.com/download.phtml What's new in version 1.15? 1. Export Data

RE: mySQL activity logging on a dual prozessor maschine

2003-03-17 Thread Peter Stoehr
Hi again, I don't think, that there are longer or shorter processes. Since I installed the 2nd CPU (933MHz for Compaq ProLaint380), I have these logenties. For example, I have a site, which supports more languages (at this time english and german only). On one site, I installed a

AW: EMS MySQL Manager for Linux 1.15 released!

2003-03-17 Thread Rusch (ext) Reiner
Hi, is anyone interested in commercial use/spam of this list? If not, I would prefer to throw them out of the list. Regards, Reiner -Ursprungliche Nachricht- Von: EMS HiTech Team [mailto:[EMAIL PROTECTED] Gesendet: Montag, 17. Marz 2003 17:05 An: [EMAIL PROTECTED] Betreff: EMS

Re: Locating Duplicate records always results in Error 127

2003-03-17 Thread Sergei Golubchik
Hi! On Mar 17, mySQL list wrote: Below is a minimum script which always results in the error Got error 127 from table handler, with only two records in the table. Change the name fields from (8 chars) to AAA (7 chars) and no error. I tried it on both 4.0.11 and 4.0.12. It,

Re: mySQL stops responding in the morning

2003-03-17 Thread Paul DuBois
At 10:58 -0500 3/17/03, [EMAIL PROTECTED] wrote: I have an app running on Tomcat 4.0.6. The app access mySQL Ver 11.18 Distrib 3.23.54, for sun-solaris2.9 (sparc) on Solaris 9. the app runs fine during the day, but when I come back to work in the morning, I see that the database connection has

Re: AW: EMS MySQL Manager for Linux 1.15 released!

2003-03-17 Thread Barry Marler
I second that. Rusch (ext) Reiner wrote: Hi, is anyone interested in commercial use/spam of this list? If not, I would prefer to throw them out of the list. Regards, Reiner -Ursprungliche Nachricht- Von: EMS HiTech Team [mailto:[EMAIL PROTECTED] Gesendet: Montag, 17. Marz 2003 17:05 An:

Re: AW: EMS MySQL Manager for Linux 1.15 released!

2003-03-17 Thread [EMAIL PROTECTED]
Greetings: 1. They only post when it deals with new software or upgrades which is less than once per quarter (if that). 2. The information involves mySQL. 3. We find the posts helpful and not SPAM. Thank you. At 05:27 PM 3/17/2003 +0100, you wrote: Hi, is anyone interested in

Re: mySQL stops responding in the morning

2003-03-17 Thread Csongor Fagyal
[EMAIL PROTECTED] wrote: I have an app running on Tomcat 4.0.6. The app access mySQL Ver 11.18 Distrib 3.23.54, for sun-solaris2.9 (sparc) on Solaris 9. the app runs fine during the day, but when I come back to work in the morning, I see that the database connection has died and mySQL does not

Re: SQL QUERY

2003-03-17 Thread Paul DuBois
At 14:40 +0100 3/17/03, [EMAIL PROTECTED] wrote: Problem with the following SQL Query: How do I combine DISTINCT with the SELECT * ? Is it SELECT DISTINCT * FROM...? This doesn´t work in my project. SELECT DISTINCT * FROM ... should work. What is your exact query, and what error message do you

FW: Connect to mysql server fail!

2003-03-17 Thread Chien-Lung Wu
hi,experts: I installed mysql (3.23.56, server client) at my NT4.0 machine. As I unziped and set up mysql, everything seemed fine ( I used winmysqladmin to start mysqld-nt server). That mean that the mysql server is running. However, when I create 'root' with mysqladmin command as follows:

oracle.

2003-03-17 Thread Anil Garg
hi, m a frequent user of mysql. i was trying to use show tables on oracle(sql), but it dint work :( How do list tables in oracle? Thanks anil. p.s. sorry for the out of list question. - Before posting, please check:

RE: oracle.

2003-03-17 Thread Anthony Robins
'select table_name from user_tables' to see your own tables. To see all tables you have to select from dba_tables. -- anthony -Original Message- From: Anil Garg [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 9:35 AM To: [EMAIL PROTECTED] Subject: oracle. hi, m a frequent user

Re: Process Limit on Linux ?

2003-03-17 Thread walt
Philipp wrote: Hi there, i wrote several times to the list asking for help with a problem regarding process limits on linux, but never got an answer. today i found this story: http://www.mysql.com/press/user_stories/handy.de.html here are the relevant sentences: We had some

Re: Mysql and processor utilization

2003-03-17 Thread walt
Sherif Diaa Mohamad wrote: I installed mysql on Redhat Linux, I have a problem that it uses 85% of the processor making the idle time of the processor = 0 while I just hosted 1 site with php Is that normal or I have something wrong ? Best Regards Sherif Mohamad

RE: oracle.

2003-03-17 Thread Anil Garg
thanks, that helped anil :) -Original Message- From: Nestor Florez [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 12:51 PM To: Anil Garg Subject: Re: oracle. Anil, I do not remember correct but you need to look at the user_tables. 'desc user_tables' One of the fields mught

FW: Connect to mysql server fail!

2003-03-17 Thread Chien-Lung Wu
hi,experts: I installed mysql (3.23.49, server client) at my NT4.0 machine. As I unziped and set up mysql, everything seemed fine ( I used winmysqladmin to start mysqld-nt server). That mean that the mysql server is running. However, when I create 'root' with mysqladmin command as follows:

Re: FW: Connect to mysql server fail!

2003-03-17 Thread gerald_clark
You did not create 'root'. You set the root password to 'therootpassword' Did you enter the same password you set? Enter Password : therootpassword Chien-Lung Wu wrote: hi,experts: I installed mysql (3.23.49, server client) at my NT4.0 machine. As I unziped and set up mysql, everything seemed

Recent crash with 3.23.56

2003-03-17 Thread root
Description: I installed the most recent rpm for RedHat Linux 7.2. After running for no more than 10 minutes, it crashed. safe_mysqld failed to restart the daemon. How-To-Repeat: I don't know. Here is all the information I have on the problem: Stack Trace: 0x806fc04 char_val + 44

Re: problème d'install de mysql sur hp-ux

2003-03-17 Thread Ken Menzel
Bonjour Jérôme, En premier cette liste est en anglais pourtant j'ai plusieurs questions de te demander. As tu essayé de compiler MySQL sur HPUX ou utiliser l'édition precompilé sure le page de télécharger? Je te conseil de employer la version compiler par le groupe de mysql. En plus y-a-t'il

Re: oracle.

2003-03-17 Thread david.best
Some people have already mentioned the answer but forgot to mention one point. If you do a select owner, table_name from user_tables; It will show you all the tables you have access to, not necessarily ones owned by you. If you want to see tables you have created add a where clause

The error on compiling the MySQL source

2003-03-17 Thread Dyego Souza do Carmo
I'm trying to compile MySQl 4.0.12 from BK three... and the error is: Making all in libmysql make[2]: Entering directory `/temp/mysql-development/mysql-4.0/libmysql' source='libmysql.c' object='libmysql.lo' libtool=yes \ depfile='.deps/libmysql.Plo' tmpdepfile='.deps/libmysql.TPlo' \ depmode=gcc

Re: mySQL activity logging on a dual prozessor maschine

2003-03-17 Thread Gelu Gogancea
Hi again Peter, I talk about processes which running in milliseconds. I don't know what to say further.Anyhow, i guess(...in my opinion) this happened because of processing time(especially that you have to 2 CPU mounted in your system).I think is not other reason because MYSQL, purely read the

Re: AW: EMS MySQL Manager for Linux 1.15 released!

2003-03-17 Thread Peter Brawley
Absent a list for MySQL-centred products their support, I appreciate occasional product book announcements. PB - 1. They only post when it deals with new software or upgrades which is less than once per quarter (if that). 2. The information involves mySQL. 3. We find the

RE: EMS MySQL Manager for Linux 1.15 released!

2003-03-17 Thread Daevid Vincent
Why such a hater? This is not SPAM. It's totally relevant to this list, and I for one am glad to see all new mySQL related products announced here. In fact, I just set them color coded to green in my Outlook, so that EMS's post will be highlighted for me in the future. d -Original

odd user/permissions/table access problem

2003-03-17 Thread Mike Whybark
I just upgraded to mysqladmin Ver 8.23 Distrib 3.23.55, for apple-darwin6.3 on powerpc from 3.23.52. Both packages are via Marc Liyanage's binary distribution from http://www.entropy.ch/. following the upgrade, one (and only one) of the databases is affected such that its' user access is

Re: Recent crash with 3.23.56

2003-03-17 Thread gerald_clark
Linux systems normally run with file locking off. With NFS shares, this can allow the server to read the index file as it is being updated. This can cause the crash make sure you don't use --skip-locking. root wrote: Description: I installed the most recent rpm for RedHat Linux 7.2. After

Problems with the api c++

2003-03-17 Thread Tuomas Heroja
Hello! I have problems in compiling my program which uses the mysql++-library. I have red hat 8.0, gcc-3.2-7, gcc-c++-3.2-7 and mysql++-1.7.9-3.rh8x.i386.rpm. When I use the command g++ -I/usr/include/sqlplus myfirstdatabaseprogram.cpp, I get several basic errors concerning the include file

Re: AW: EMS MySQL Manager for Linux 1.15 released!

2003-03-17 Thread Patrick
Agreed... Pat... - Original Message - From: Peter Brawley [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, March 17, 2003 2:52 PM Subject: Re: AW: EMS MySQL Manager for Linux 1.15 released! Absent a list for MySQL-centred products their support, I appreciate

Problem matching on only part of a field

2003-03-17 Thread Hal Vaughan
I've been reading through documentation (including the O'Reilly book links on the mysql.com website), and I'm sure this is simple, but I can't seem to find it. I'm managing a mailing list for a client and I want to match on United States zip codes that correspond to different areas. (For

Re: odd user/permissions/table access problem

2003-03-17 Thread Paul DuBois
At 12:10 -0800 3/17/03, Mike Whybark wrote: I just upgraded to mysqladmin Ver 8.23 Distrib 3.23.55, for apple-darwin6.3 on powerpc from 3.23.52. Both packages are via Marc Liyanage's binary distribution from http://www.entropy.ch/. following the upgrade, one (and only one) of the databases is

Re: AW: EMS MySQL Manager for Linux 1.15 released!

2003-03-17 Thread Daniel Kasak
Rusch (ext) Reiner wrote: Hi, is anyone interested in commercial use/spam of this list? If not, I would prefer to throw them out of the list. Regards, Reiner If it offends you so then set up a filter to deal with it. MySQL-related software releases can't be considered spam. Focus your

Re: AW: EMS MySQL Manager for Linux 1.15 released!

2003-03-17 Thread Bruce Feist
Peter Brawley wrote: Absent a list for MySQL-centred products their support, I appreciate occasional product book announcements. I agree. Bruce Feist - Before posting, please check: http://www.mysql.com/manual.php

converting an existing column to auto increment

2003-03-17 Thread Liz Buckley-Geer
I have an table with a column numberINT NOT NULL PRIMARY KEY This table contains many records and there are gaps in the number sequence. I would like to modify this column to use the AUTO INCREMENT feature but I need to preserve the present numbering sequence (which is monotonically

Re: buffer overflows in MySQL error messages (e.g. in 4.0.10-gamma)

2003-03-17 Thread Maarten LITMAATH
Sergei Golubchik wrote: Ok, I took a look at this. (btw, this was not a diff at all, but rather tarball of new and old files. Having a real unified diff would make your changes MUCH easier to understand). Hi, I did not want to force a particular diff format on the reader; having the original and

InnoDB Problem

2003-03-17 Thread Custódio de Matos Lima
Hello, I´m having some troubles when creating the foreign key constraints in a InnoDB database. The problem is, i can create the InnoDB table, but i´m having a little difficult to make the connections with other tables. The error that apears is like that: Erro Comando SQL : alter table

Indices in querys using OR...

2003-03-17 Thread dreq jkj
I have trouble figuring out how the indices are used when making a query that uses OR-operator. If I have the following table: create table testing( id int unsigned not null primary key auto_increment, idx1 int unsigned not null, idx2 int unsigned not null, index(idx1), index(idx2)); In this

Help with Query

2003-03-17 Thread Daren Cotter
I have a table that keeps track of when members of my site are mailed. The important fields in the table are: member_id, mail_id I need to write a query that will return the # of members and # of mailings, like the table below: # of mailings sent # of members

Re: converting an existing column to auto increment

2003-03-17 Thread Benjamin Pflugmann
Hello. On Mon 2003-03-17 at 18:08:08 -0600, [EMAIL PROTECTED] wrote: I have an table with a column numberINT NOT NULL PRIMARY KEY This table contains many records and there are gaps in the number sequence. I would like to modify this column to use the AUTO INCREMENT feature but

Re: column named force not allowed

2003-03-17 Thread Paul DuBois
At 15:58 +0100 3/17/03, Peter O wrote: Description: When creating a table with a column named force an error is shown and the table is not created. How-To-Repeat: When trying to do this : CREATE TABLE testcase ( force int default NULL ) TYPE=MyISAM; I get this : ERROR 1064: You have an

store an array of double to mysql, How?

2003-03-17 Thread Lai
Hi. I am writing a program to do pattern recognition. I decide to use mysql to store the features calculated. The features are stored as an array of double in my c program. But now I do think about it, I don't know how. I've searched the internet, none really fit my problem. Is there a way to

Re: converting an existing column to auto increment

2003-03-17 Thread Paul DuBois
At 18:08 -0600 3/17/03, Liz Buckley-Geer wrote: I have an table with a column numberINT NOT NULL PRIMARY KEY This table contains many records and there are gaps in the number sequence. I would like to modify this column to use the AUTO INCREMENT feature but I need to preserve the

Modifying table causes insert delayed queries to fail

2003-03-17 Thread Shane Allen
Description This may be by design, but I figured I'd bring it up because it caused less-than-desirable behaviour for me. I executed an alter table query, designed to change the length of a fixed width char field to 128 from 255. The alter occured fine, with no problems, except that there were

subselect

2003-03-17 Thread geeta varu
does subselect work in mySQL 3.23 ...i'm trying to exceute the following query ... Select can_reg_no from candidate where (pres_org_curr_desig like '%sales%' or pres_org_curr_desig like '%marketing%') AND can_reg_no in ( Select can_reg_no from candidate where (pres_org_curr_desig like

subselect

2003-03-17 Thread geeta varu
does subselect work in mySQL 3.23 ...i'm trying to exceute the following query ... Select can_ID from TABLE1 where (designation like '%sales%' or designation like '%marketing%') AND can_ID in (Select can_ID from TABLE1 where (designation like '%telecom%' or designation like '%software%'))

Re: Help with Query

2003-03-17 Thread Jeff Shapiro
This should get you close: SELECT mail_id, count(member_id) AS `# of members` FROM yourtable GROUP BY mail_id; At 18:44 -0800 3/17/03, Daren Cotter wrote: I have a table that keeps track of when members of my site are mailed. The important fields in the table are: member_id, mail_id I need to

Re: Help with Query

2003-03-17 Thread Daren Cotter
Jeff, That query simply gives me each mailing ID, along with the # of members associated with that mailing ID. What I NEED is to return the # of mailings sent to a member, and the number of members associated with that number. I.e., if I do: SELECT count(*) FROM member_mailings WHERE member_id

Re: Help with Query

2003-03-17 Thread Zak Greant
On Mon, Mar 17, 2003 at 09:52:44PM -0800, Daren Cotter wrote: Jeff, That query simply gives me each mailing ID, along with the # of members associated with that mailing ID. What I NEED is to return the # of mailings sent to a member, and the number of members associated with that number.

Re: Help with Query

2003-03-17 Thread Daren Cotter
This seems to be doing the same thing as the previously mentioned query...simply listing all mailing IDs, along with the # of members it was sent to. I've included both queries with their results below. mysql SELECT COUNT(member_id), COUNT(mailing_id) FROM member_mailings GROUP BY mailing_id;

[MySQL] InnoDB - Updating a parent table won't update the child table

2003-03-17 Thread Paul Larue
Hi all, I created 2 tables in MySQl with the following statements == CREATE TABLE employees ( emp_id INT NOT NULL AUTO_INCREMENT, emp_last_name TINYTEXT NOT NULL, emp_first_name TINYTEXT NOT NULL, emp_nick_name