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;
+--
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
>
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 TINYTEXT
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
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 writ
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%'))
i
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 '%telec
>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 a
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 presen
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 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 error
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
> featu
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
-
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 que
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 tab3
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 t
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 in
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
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 attentio
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
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 non-U
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 appr
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
(fo
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 r
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 disr
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 Message-
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
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 tim
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
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 WH
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
>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
0x81
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
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:
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 be
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
>
> ---
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
'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 of
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:
http:
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:
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 see
[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
r
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
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:
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 die
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, in
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 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 JavaScript-Calen
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
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 nee
-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 no
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
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 wh
-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,
jdbc:mysq
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
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
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
>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:
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 configura
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 [mailto:[EM
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 for
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 eigen
-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
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
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,
> >
>
> 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 /opt/gcc-3.2.1/
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
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
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, CONC
69 matches
Mail list logo
