on 12/29/03 9:54 AM, Dave G wrote:
$wsQuery = SELECT improvwsid FROM improvws WHERE wsdate ' . $today
. ' AND wsdate ' . $sevenDays . ' AND cancelled = 0;
$wsResult = mysql_query($wsQuery);
$wsid = mysql_result($wsResult, 0, improvwsid);
$emailQuery = SELECT members.email AS email,
on 12/29/03 12:00 PM, Bjoern Wuest wrote:
Hello
I have the following problem:
Table1 'pl':
+---+---+
| p | o |
+---+---+
Table2 'ln':
+---+--+---+
| p | l | v |
+---+--+---+
Now my problem: how to write a statement to select all 'p' and 'v' from 'pl'
and 'ln' where
One extra join will do it. You're looking for all improvws in
the next seven days that aren't cancelled, right?
Yes... thank you. I see where I was going wrong now. The extra joins I
needed were to match the wsid to the member.id by matching both to where
they appear in the attend table.
I see that in the prepared statements C API, I can specify to the bind
parameter that the value is supposed to be null using MYSQL_BIND.is_null. Is
there any support for the MYSQL_BIND object to use a column's default value?
- Yossie
--
MySQL General Mailing List
For list archives:
Dear all,
thank you very much for the fast and numerous responses. The idea of Roger
Baklund does exactly what I want. Thank you very much Roger.
I oversee the possibility to use IF conditions on MySQL server, this is what
I wanted to do programmatically but to do in the DB server is ok. Let's
Hi List,
Just a dumb question perhaps, but I am looking at upgrading to 5.0, and as
we are
happy with the performance and features on 4.1, can we expect the same
features
to have the same level of stability on 5.0? Also are the features of 4.1.1
also included?
I need to start looking at stored
I am working to port our database to mysql now. I work in PT. ADETEX.
Sorry for my english.
Regards,
Hendro
-Original Message-
From: Leo [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 30, 2003 1:25 PM
To: [EMAIL PROTECTED]
Subject: MySQL user in Indonesia
Hi All,
im sorry if this
I cant add a database.. I have Microsoft access installed. my webpage is
www.overclockers-layer.dontexist.com
http://www.overclockers-layer.dontexist.com/
go to the forum page and you will see another error
if you go to
www.crazymod.dyndns.org:8080/public/fm/upload/sm_install.php
my username
Hi Rick,
I have installed binary alpha 5.0 for Linux x86.
And I am able to create stored procs.
But I found couple problems with stored procs:
1. I have stored proc sp_GetData(param char(31)).
When I call stored proc first time (with any parameter) it works just fine,
but if I change parameter to
hendro,
We are (Sumitomo Wareghouse Indonesia) using mysql from version 3.5 - untill
5.0 (gamma version). As long as my experience there's no problem using these
free cost database.
Right now, we still believe mysql as our primary database engine for service
our site office at Karawang, Tg-Priok,
Hi Terence,
Just a dumb question perhaps, but I am looking at upgrading to 5.0, and as
we are
happy with the performance and features on 4.1, can we expect the same
features
to have the same level of stability on 5.0?
I wouldn't expect the same level of stability if you would like to use
I am trying to connect to mysql database.
getting error ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (111)
Can not shutdown as well as restart.
Please help me
Thanks for support.
-
Do you Yahoo!?
Free
Hello,
from the following Product-table
ProductId
MarketId
CustomerId
Type
Price
...
i would like to get the three highest and lowest prices
for each group of ProductId,MarketId Type.
How could i do that ???
Many thanks in advance
roland
Hi,
I am having responsibility to connect MySQL to COBOL. after such a long analysing I
found there
are some C API function to connect to MySQL provided by itself.
In COBOL I have the option to CALL external programs written in other languages. I
follow this way
to made connection to MySQL
Peter,
Thank you for respond and sorry...
It was my mistake. Today I have compared it once again:
on 4.0.14 ~11.5 min
on 5.0.0 ~13.0 min
Thank you,
Mikhail.
- Original Message -
From: Peter Zaitsev [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, December 29, 2003 8:46 PM
What is the syntax of your call to connect to the MySQL server?
It seems as though no server parameters are being passed, thereby defaulting
to the local machine which apparently has no mysql server running.
Pat...
CocoNet Corporation
SW Florida's First ISP
- Original Message -
Ramesh,
- Alkuperäinen viesti -
Lähettäjä: Ramesh Vadlapatla [EMAIL PROTECTED]
Vastaanottaja: Heikki Tuuri [EMAIL PROTECTED]
Lähetetty: Monday, December 29, 2003 10:48 PM
Aihe: Re: MySQL/InnoDB-5.0.0 is released
Hello Heikki,
This is excellent news. Stored Procedures support is
since it has been the holidays, I can understand this one failed to draw
attention of the people able to answer, so I'm sending it again:
Hi all,
if I try to defrag an InnoDB table (using alter table ...
type=innodb;) I see the
Michael,
- Alkuperäinen viesti -
Lähettäjä: [EMAIL PROTECTED]
Vastaanottaja: Heikki Tuuri [EMAIL PROTECTED]
Kopio: [EMAIL PROTECTED]
Lähetetty: Monday, December 29, 2003 11:53 PM
Aihe: Re: Foreign Keys in CREATE TABLEs produced by mysqldump
Heikki Tuuri [EMAIL PROTECTED] wrote on
* Roland Niederbrucker
from the following Product-table
ProductId
MarketId
CustomerId
Type
Price
...
i would like to get the three highest and lowest prices
for each group of ProductId,MarketId Type.
How could i do that ???
Do you use a programming language, or are you looking
Franky,
since MySQL performs
ALTER TABLE ... TYPE = InnoDB;
by totally rebuilding the table, it is very normal that the space usage
temporarily doubles in ibdata files.
But if it doubles also after an immediate SECOND rebuild, then that must be
a bug. If you can reproduce that phenomenon,
Using correlated subqueries on 4.1 you could do it all in sql:
SELECT ProductId, MarketId, Type, Price
FROM Products a
WHERE 3=(SELECT count(*) --finds highest prices
FROM Products b
where b.ProductId=a.ProductId
AND b.MarketId=a.MarketId
AND
Hi,
I am new to MySQL and old to MS Access (advanced skill level).
When building Access DBs, I write VB code, SQL, develop DBs using 3rd
N.F.
and build lovely forms for data entry, print outs, reports etc, etc.
After examing MySQL's material, I don't see any forms like I use in
Access.
[EMAIL PROTECTED] wrote:
I think I am confused. I have many bin index files, but I have not gotten rid of
them.
I read somewhere that I should not remove them...or I should not remove the entries
in the index file.
Since I am unsure of which one above is correct, I am posting to the
I have red hat 9.0, i don't to install mysql RPM appear:
erro: Failed dependencies:
libmysqlclient.so.10 is needed by perl-DBD-MySQL-2.1021-3
Please Help me!!
--
***
Carlos Andre Moura de Amorim
Hi
You need to install first rpm with dynamic client libraries
(including 3.23.x libraries). You can find them on
http://www.mysql.com/downloads/mysql-4.0.html
Best regards,
Mikhail.
- Original Message -
From: Carlos Andre Moura de Amorim [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent:
Thanks, I installed, but i don't to connect!!
bashmysql
bashERROR 2002: Can't connect to local MySQL server through socket
'var/lib/mysql.sock' (2)
On Tue, 30 Dec 2003, Mikhail Entaltsev wrote:
Hi
You need to install first rpm with dynamic client libraries
(including 3.23.x libraries).
I have an application that updated or inserted 26,000 records into a
MySQL INNODB table in about 12 minutes... A creditable performance as
far as I am concerned. However, the application failed on one of the
last insert/updates with a lock wait timeout. My script issues a
commit every 250
Currently running 4.0.17 InnoDB on XP/Apache 2.0.47; client wants to
investigate using capability for stored procs in v5, but doesn't have
another machine on which to experiment. Can these two be run on the same
machine (though not at the same time)?
Regards
Terry Riley
--
MySQL General
i have a follow problem, please, help-me
[EMAIL PROTECTED] db]# mysql --user=root --password=xx
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)
--
***
Carlos Andre Moura de Amorim
Being COBOL illiterate, I may not be able to help.
Two questions come to mind in reviewing the parameters you are passing.
Are the parameters by reference passed as char-like pointers and the
parameters by content passed as integers? If they are, then the only issue I
see as a possibility is
Try to change localhost in connection string to real IP address or
127.0.0.1.
Actually it is not the fix of the problem it is a workaround.
Best regards,
Mikhail.
- Original Message -
From: Carlos Andre Moura de Amorim [EMAIL PROTECTED]
To: Mikhail Entaltsev [EMAIL PROTECTED]
Cc: [EMAIL
* Terry Riley
Currently running 4.0.17 InnoDB on XP/Apache 2.0.47; client wants to
investigate using capability for stored procs in v5, but doesn't have
another machine on which to experiment. Can these two be run on the same
machine (though not at the same time)?
You can run them on the same
I'm doing just that right now. I built from source and put mysql4 in
/usr/local/mysql and mysql5 in /usr/local/mysql5 with the my.cnf is
/usr/l.ocal/mysqlX/var. In the my.cnf file I put the local sockets into
/usr/local/mysqlX/tmp and mysql5 is using port 3305 with mysql4 on 3306.
The
The mysql_install_db script shipped with 4.1.1-alpha seems to leave
the mysql/* (user,host,etc.) tables owned root.root on my Debian
system; this makes mysqld fail to start after the grant tables are
installed.
It looks like this is because mysql_install_db calls mysqld with
--bootstrap and
I've isolated this problem down to a single table and SQL script that
demonstrates the problem repeatably.
There are 4 SQLl scripts here - one to create remove the database, one
to create the database and user entries, one to create the table, and
one to access the table. It is the 3rd that
On 30 Dec 2003, at 16:22, Carlos Andre Moura de Amorim wrote:
i have a follow problem, please, help-me
[EMAIL PROTECTED] db]# mysql --user=root --password=xx
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password:
YES)
Wrong password or root does not have a password. (The
I think I am confused. I have many bin index files, but I have not gotten
rid of them.
I read somewhere that I should not remove them...or I should not remove
the entries in the index file.
Since I am unsure of which one above is correct, I am posting to the list.
Can someone let me
Well now, this is interesting. The agent mentione previously ran
flawlessly for a couple of weeks. The day I left for Christmas
vacation, I started getting the lock wait timeout error. The
difference? I altered the table to include a foreign key constraint.
Not sure how this could possibly be the
Hi,
I am currently using the replication function of my
mysql server (3.23.58) to replicate one database.
Since I host others I'd like to know if there is a way
to automatically replicate a database. I.e as soon as
a use issues a mysqladmin create it is propagated to
the slaves.
Any tips ?
The replication between two servers works. But I tried to disable
replication on one table. According to the MYSQL Documentation. I did the
following:
#1 stop Slave
#2 Modified my.cnf on slave
[mysqld]
server-id=3
master-host=192.168.1.129
master-user=aert12
master-password=password
Thanks, Bruce, Roger
Terry Riley
--Original Message-
Currently running 4.0.17 InnoDB on XP/Apache 2.0.47; client wants to
investigate using capability for stored procs in v5, but doesn't have
another machine on which to experiment. Can these two be run on the
same
Hi
Hi I want to query multiple tables and think I need a little help
Using this example I have 2 tables
Table1
Table Name: one
Field: Surname
Field: Setnumber
Table2
Table Name: two
Field: Surname
Field: Setnumber
Using:
SELECT COUNT(*) AS res, FROM one, two where one.surname like ('
I am trying to get some kind of friggin Quake 3 stat generator to work
on my Quake 3 servers that I have running.
Currently I am running a program called Q3Log, which is java based, but
it seems to have stopped working for some reason. (no log to show
errors). Anyhow, now my only option is to
Hello List:
Here comes a newbie's newbie!!
I want to install MySQL 5.0.0 on a machine with RAID. It has the following
hardware/Software configuration:
DISTRO: RH9
1-Disk which has all the software installed.
2-Disks, which are RAID1 format with one folder /data
I plan to use the RAID for data
The MySql 5.0 Windows binary is missing the file
scripts/mysql_fix_privilege_tables.sql, without which, it appears, there is no way to
enable the main new feature of 5.0, Stored Procs.
If Linux 5.0 builds include this script, could someone please post the script here so
we may have at MySql
hi everyone,
I made a mistake of not giving a name to an index.
alter table sometable add index ( field1, field2 )
I would like to remove this index but I can't figure it out.
I tried:
alter table sometable drop index (field1,field2)
How do I fix this?
Thank you.
-gohaku
--
MySQL General Mailing
I made a mistake of not giving a name to an index.
alter table sometable add index ( field1, field2 )
I would like to remove this index but I can't figure it out.
If you perform SHOW INDEX FROM tablename; what do you get as the key_name? Try
dropping it based on what you see.
--
MySQL
Hi, I have several simple questions regarding creating
tables in the MySQL.
1. For a variable of Java primitive int type, I should
use INT or INTEGER? Do I have to specify the length of
the field?
CREATE TABLE message_thread( thread_id INT or INTEGER
NOT NULL AUTO_INCREMENT PRIMARY KEY);
2. A
-Message d'origine-
De : Carlos Andre Moura de Amorim [mailto:[EMAIL PROTECTED]
Envoyé : Tuesday, December 30, 2003 10:43 AM
À : Mikhail Entaltsev
Cc : [EMAIL PROTECTED]
Objet : Re: Problem Installation
Thanks, I installed, but i don't to connect!!
bashmysql
bashERROR
-Message d'origine-
De : Carlos Andre Moura de Amorim [mailto:[EMAIL PROTECTED]
Envoyé : Tuesday, December 30, 2003 11:23 AM
À : [EMAIL PROTECTED]
Objet : problem
i have a follow problem, please, help-me
[EMAIL PROTECTED] db]# mysql --user=root --password=xx
ERROR
Hi,
Can somebody teach me how to do MySQL server backup? Any answer will be much
appreciated.
regards,
florence
Thank you very much.
regards,
florence
The New Yahoo! Search
- Now with image search!
-Message d'origine-
De : florence florence [mailto:[EMAIL PROTECTED]
Envoyé : Tuesday, December 30, 2003 1:46 PM
À : [EMAIL PROTECTED]
Objet : How to backup MySQL databasee?
Hi,
Can somebody teach me how to do MySQL server backup?
Any answer will be much
Carlos Andre Moura de Amorim wrote:
i have a follow problem, please, help-me
[EMAIL PROTECTED] db]# mysql --user=root --password=xx
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)
try to add -h hostname
--
54 matches
Mail list logo