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
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
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
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
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
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
-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
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
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
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
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
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:
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
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
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
-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,
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
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
-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
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 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
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
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
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,
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
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:
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
[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
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
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:
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:
'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
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
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
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
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:
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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%'))
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
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
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.
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;
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
69 matches
Mail list logo