Those of you using MRTG to monitor your servers,
routers, etc. may be interested in knowing that a
MySQL extension for MRTG is now available.
This extension will allow you to monitor the number
of questions and the number of slow queries
the server is handling over time.
Links to the extension
Something like
SELECT Tactic.teamCode
FROM Tactic t, Game g, Turn r
WHERE t.teamCode <> g.teamCode1
AND t.teamCode <> g.teamCode2
AND g.gameTurn = r.code;
...and even the table "Turn" may not be necessary, depending on the values
in your tables and what you want to do with it.
- Original M
AFAIK MySQL does not yet support sub-selects.
--zak
- Original Message -
From: "Lefebvre, Cedric" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, May 28, 2001 12:41 AM
Subject: SQL Problem
> I have a problem adapting a multiple select to MySQL.
> Can someone help me ?
>
> Her
I have a problem adapting a multiple select to MySQL.
Can someone help me ?
Here is my request (Oracle format)
SELECT Tactic.teamCode FROM Tactic WHERE
Tactic.teamCode NOT IN (SELECT Game.teamCode1 FROM Game, Turn WHERE
Game.gameTurn = Turn.code)
AND Tactic.teamCode NOT IN (SELECT Game.teamCode2
I am using mysql 3.23.xx on linux 6.2. I have been use gcc 2.91. I can
use show database and show table in mysql prompt. I wonder that why did
you cannot use these function and must upgrade gcc.
Sommai Fongnamthip.
At 11:10 26/5/2001 +, Greg Cope wrote:
>Daniel wrote:
> >
> > Scratch t
At 8:46 PM -0400 5/26/01, Nicu Popovici wrote:
>Hello Sinisa,
>
> I managed to get a connection to a database but now when I want to
>try to make a query on that
>database I have to use strmov() function defined in m_string.h but
>at compilation time I get the
>following errors.
>JUST BECAUSE
At 9:44 AM +0200 5/26/01, [EMAIL PROTECTED] wrote:
>hi list,
>I have mysql installed on SuSE 7.0 box with 2 network interfaces and I want
>port 3306 to be opened only on one of them (internal). Is there any options
>in mysql configuration to achieve this?
Run mysqld --help to see mysqld's options
At 8:04 PM +0100 5/27/01, David Ayliffe wrote:
>
>I'm following the exmple in the book MySQL by Paul DeBous (chapter 6 The
>MySQl C API page 225). I am getting an error about "Too many types in
>declaration"
>
You show your program below, but it would probably be good to give us
some idea where
At 8:26 PM +0530 5/27/01, T.E.Devarajan wrote:
>Hi,
>I need some help. I downloaded mysql and when I tried to
>work ,
>C:\>c:\mysql\bin\mysqld
>the foll message appears.
>"Can't initialize InnoDB as 'innodb_data_file_path' is not set"
>
>
> Pl help to get going. I need
> advise right from the st
At 12:55 AM +0100 5/27/01, Gordon Stewart wrote:
>hi List
>
>I have a database in mysql that has to be used as root user.
>
>When I try and use it as normal user (gordon) it complains.
>
>I have inserted the user gordon into the mysql database and it has all privs
>but it still has the problem.
W
By setting the correct file permissions. Usually mysql for both user &
group and chmod 660. Also, RTFM, especially the security sections.
- Original Message -
From: "Sofiane Sakhri" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, May 26, 2001 19:11
Subject: Please How can I
And how did you create the user? What was you command?
- Original Message -
From: "Gordon Stewart" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, May 27, 2001 7:55
Subject: User privs in mysql
> hi List
>
> I have a database in mysql that has to be used as root user.
>
> Whe
On Sun, 27 May 2001 16:27:00 -0700, Nicole Lallande <[EMAIL PROTECTED]>
wrote:
Appreciate all the responses, thanks to all :)
>>Mike - if you are familiar try Fishcart - http://fishcart.org/ - here's
>>what I like about it:
>>
>>ease of implementation
>>documentation
>>mailing list support
>>
>
>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator: jack garivaldis
>Organization: FTID Australia
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity:
>Priority:
>Category: mysql
>Clas
Besides providing us with samples of your code, did you try viewing the
source code? Error messages aren't always displayed on the web page itself
and you'll have to view the source code to find the error.
- Original Message -
From: "Stephanie Deville" <[EMAIL PROTECTED]>
To: <[EMAIL PRO
Mike - if you are familiar try Fishcart - http://fishcart.org/ - here's
what I like about it:
ease of implementation
documentation
mailing list support
for a very robust PERL shopping cart program go to http://akopia.com/ -
this is what minivend finally morphed to - after being purchased by
RedH
I am testing mysql for merge tables and symbolic links
on NT4. But it seems not working.
First I tried doing exactly what is there in the
manual, then searched mailing list and added
use-symbolic-link in my.cnf file in C:\ directory.
Mysql recognise that there is a database but can't
read content
Hello All,
I hoping someone on the list maybe able to offer some recommendations on a good
MySQL backend database shopping cart with advance search features. One of our
client's has "out-grown" their current cart, which using DBM data files. And it
would cost too much to port it MySQL. They prefe
[EMAIL PROTECTED] wrote:
>Your message cannot be posted because it appears to be either spam or
>simply off topic to our filter. To bypass the filter you must include
>one of the following words in your message:
>
>database,sql,query
>
>If you just reply to this message, and include the entire te
Hi,
We've recently upgraded our 2 mysql servers from 3.22 to 3.23.36,
and since then we occasionally get errors like the following in
the servers' error logs:
010527 21:01:26 Aborted connection 461457 to db: 'clantsf' user: 'tsf' host:
`pride.gamepoint.net' (Got an error reading communication
On 27 May 2001 18:10:11 +0800, Wong Yew Peng wrote:
> Dear Sir,
>
> The Create Table function is not working. Any steps that I need to
> take besides creating a database first.
No. Give the error messages to get help.
--
MySQL Security Administrator
__ ___ ___ __
/ |/ /_
I'm following the exmple in the book MySQL by Paul DeBous (chapter 6 The
MySQl C API page 225). I am getting an error about "Too many types in
declaration"
Do I need to download any special libraries - currently I am using the
ones in the mysql-3.23.38a-win-src.zip file (mysql.h, mysql_com.
Hi David,
#include
#include "somethingelse.h"
as you see, < >and " are used.
Use <> when the file you want to include is not in the same directory your
project is in AND is available thought the compilers include path
configuration. Use " when the file you want to include is in the same
direc
Welcome and thanks for the time in reading this. I have a simple
proggie below. When I try and compile it I get the error above
(subject) the error points to this part of mysql.h - the part
specifically is highlighted in red.
I am compiling it on Win2K SP2 with Borland C++ v4.52
I can't see an
Hi,
I need some help. I downloaded mysql and when I tried to
work ,
C:\>c:\mysql\bin\mysqld
the foll message appears.
"Can't initialize InnoDB as 'innodb_data_file_path' is not set"
Pl help to get going. I need
advise right from the stage where I have got the Windows version of
mysql download
Its been a while since i've last touched c++ and i'm trying to include
two files
stdio.h
and mysql.h
I know that to include stdio.h I enclose it in <> but mysql.h is in the
same folder as the project I know I can't use <> but what do I use
instead?
Thanks lots
David Ayliffe ([EMAIL PROTECTED])
I had the same error - but the socket didn't appear to exist.. (I'm using RH7 with
the defualt setup)
<<< "Moax Tech List" <[EMAIL PROTECTED]> 5/26 6:08a >>>
You most likely don't have your permissions set right on your socket, make
sure it is readable / writeable by the php user (nobody?) an
Hi,
Move the conditions b.tag = 1 and b.day = 11323
into the ON clause of the outer join.
In your present query, the result of the outer join gets filtered
with the two conditions, and those are not true for the records in T1
that have no matching rows in b.
Jan
Roger Karnouk wrote:
>
> I
On Sun, 27 May 2001, David Loszewski wrote:
>
> when you first install mysql server does it assign a default password
> becuase it tells me to enter these in to make a password for my server,
> but I don't know what the heck to do with them, but when I try them it
> says access denied
>
> /u
On Fri, 25 May 2001, Stephanie Deville wrote:
> I'm running FreeBSD 3.4, Apache 1.3.9 w/ php4 and mysql 3.22.32. The
> problem I'm having is that my php scripts work fine, mysql works fine. When
> I run a php script, everthing in the script works up to the point were I try
> mysql_connect. I
On Fri, 25 May 2001, Andrey Kotrekhov wrote:
> I don't agree.
> If mysql install in other directory then /usr/local
> you need use --with-mysql=mysqldir
> and sometimes --with-mysql-include and --with-mysql-lib
> options.
>
> > Do you need to specify a directory? I just did --with-mysql
> >
>
Nicu Popovici writes:
> Hello Sinisa,
>
> I managed to get a connection to a database but now when I want to try to make a
>query on that
> database I have to use strmov() function defined in m_string.h but at compilation
>time I get the
> following errors.
> JUST BECAUSE I INCLUDED m_string.
Dear Sir,
The Create Table function is not working. Any steps that I need to
take besides creating a database first.
Yew Peng
Singapore
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
htt
33 matches
Mail list logo