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
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 ?
Here is my
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
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
Hello,
I took out the m_string.h file from include directive and I get the following
error
gcc -g Bug_Report.c -O -o TEST1 -I/usr/include/mysql -L/usr/lib/mysql
-lmysqlclient -lnsl
/tmp/ccWyxVrf.o: In function `main':
/home/nicu/QA/Bug_Report.c:15: undefined reference to
Hi all,
How to use MySQL LOAD DATA command to load comma separated text data
but one of the field can contains comma character as part of of the string context.?
In other word, I want LOAD DATA insert string with comma characters inside it but
without
adding slash character ('\')to distinguish
Hi !
I'm using MySql 3.23.38-nt on a test machine.
I'd like to create a new user and I tried :
--
mysql connect mysql
Connection id:308
Current database: mysql
mysql set password for auser = password(anewpassword);
ERROR 1133: Can't find any matching row in
Subj.
Can I set it up on a cluster? I have so heavy load on my
MySQL server that I need to increase the power of my server.
I consider different ways of doing it and want to know if
somebody installed it successfully on a cluster.
Best regards,
Vinche mailto:[EMAIL
Hi,
I have used mm.mysql driver for jdbc connection. I've did all the neccessary
connection and the java application was able to load the driver, but there was this
problem. The java program was actually from the mm.mysql documentation.
Problem:
SQLException:Server
Did you
1. Use GRANT to create the user? If you didn't and inserted data
incorrectly into the grant tables, you could find problems later on.
2. Flush privileges after creating the user?
- Original Message -
From: Martin RODOT [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday,
I'm running RedHat 7.0 with mysql-server-3.23.22-6. When I try installin the rpm I get
the
following message MySQL-server is needed by mysqlgui-static-1.7.1-1
-
Before posting, please check:
I was so excited to see that the latest FileMaker Pro finally supports SQL
stuff built in, but was disheartened to see that I could only use it with
Oracle and a couple other commercial servers. Is anyone out there working
on a mysql plugin for 5.5? FileMaker would seemingly be an awesome way
The problem has been resolved. There is apparently an
undocumented option
(at least it's not documented in the HTML manual for 3.23.38)
required in
the my.cnf file - use-symbolic-links. I was using all
default values, so
I wasn't even using a my.cnf or a my.ini file.
Here's how I
Hello guys,
I managed to compile succesfully my C program but now when I run it I get
something like the following
---
TEST1
Failed in SELECT , Error: You have an error in your SQL syntax near ')' at
line 1
What I want to ask , I have to do
Hi !
I'm a novice mysql administrator and acording to my Web Hosting Provider, my mysql
daemon is loading the CPU too much. The web has currently two main php scripts
regarding the MySQL daemon.
The first one shows a banner using the PHPAdServer application ( no clicks are
registered, only
Hello mysql,
I've just upgraded my WEB-Server box (2xPIII-500Mhz, 1Gb mem) to
FreeBSD 4.3-RELEASE update mysql to 3.23.38.
(mysql Ver 11.15 Distrib 3.23.38, for -freebsd4.3 (i386))
Usually mysqld was taken 8-20% of CPU usage (top results).
But after some days i'am notice that mysql takes all
Hi all;
When I run the example in its original directory, I have no problems.
When I wrap the example in my source, the source compiles but fail to
link with a certain Library as shown in the output below. What I want is
to get out the query results and use them in normal C++ environment.
Your
Hi all;
When I run the example in its original directory, I have no problems.
When I wrap the example in my source, the source compiles but fail to
link with a certain Library as shown in the output below. What I want is
to get out the query results and use them in normal C++ environment.
Your
Hi all;
When I run the example in its original directory, I have no problems.
When I wrap the example in my source, the source compiles but fail to
link with a certain Library as shown in the output below. What I want is
to get out the query results and use them in normal C++ environment.
Your
Description:
How-To-Repeat:
Fix:
Submitter-Id: submitter ID
Originator:
Organization:
MySQL support: [none | licence | email support | extended email support ]
Synopsis:
Severity:
Priority:
Category: mysql
Class:
Release:
Hi,
regarding
http://ep33.tp4.ruhr-uni-bochum.de/mlists/MySQL/May.2000/index.html#2025 , I
had the same problem with MySQL 3.23.30.
The following statement Update Tree set left=left+2 where (left$right and
right=$right); sometimes (not reproducable) locked up MySQL completely.
The left value in
--- [EMAIL PROTECTED] wrote:
Hi,
I have a problem regarding Mysql database. how can
I insert more than 256 characters in a
field
of a table? Is it a limitation of Mysql database.
Actually I want to insert a large string
which consists of more than 256 characters in a
field.
Pl let me
hi
hope this is the correct list for questions...if not , sorry
i have a mysql server under linux, works fine but, if a user has an mysql
account eg: XYZ and connects then he can take a look into the other DB, of
other users ..he cant change any things. how i can set the permission for
read
Tiwonge Nathan Kawonga writes:
Hi all;
When I run the example in its original directory, I have no problems.
When I wrap the example in my source, the source compiles but fail to
link with a certain Library as shown in the output below. What I want is
to get out the query results and use
On Mon, 28 May 2001, Lefebvre, Cedric wrote:
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 =
Buyondo Charles writes:
I'm running RedHat 7.0 with mysql-server-3.23.22-6. When I try installin the rpm I
get the
following message MySQL-server is needed by mysqlgui-static-1.7.1-1
Hi!
Please use our latest 1.7.5 static binary for Linux instead of RPM.
Regards,
Sinisa
In fact this does not return me what I want :
If I have the tables
Tactic
teamCode 1
teamCode 2
teamCode 3
teamCode 4
Game
teamCode1 1 teamCode2 3 GameTurn 1
teamCode4 1 teamCode2 3 GameTurn 1
Turn
Code 1
My request would return me nothing
while your request would return me
different sets
Hello. I'm new to MySQL but I have a problem that appears serious, al least for me.
I can't create a table with a field named INFILE. I think mysql consider INFILE as a
keyword. Is there work around for this?
Shouldn't INFILE be used only within a LOAD statement? I think it is a bug in the
First, you need to REVOKE any existing priviledges for that user, then GRANT
the privileges you wish that user to have. This is detailed in the MySQL
Manual (http://www.mysql.com/doc/G/R/GRANT.html).
G. Jensen
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent:
Hi!
When I join 4 tables with about 3000 records in each mysql seems to work
forever on copying to tmp table.
I wonder what that could be. I have enough free space in the tmp-dir and
don't know what else could it be.
The database-model is normalized and on another machine it takes me about 1
Hi,
Excuse my english pleasei'll try to explain what i have to do.
I have two server running MySQL, at this time one is a master and the other a slave.
What I have to do is to make both master and slave together so if the master gows down
the system still work with the slavelike a
Please check the manual before sending a question to this list.. says every
messages.. So:
http://www.mysql.com/doc/R/e/Reserved_words.html
Workaround: give your table another name.
Bye,
B.
At 14:23 28-5-01 +0200, Alessandro Staltari wrote:
Hello. I'm new to MySQL but I have a problem
Paste EXPLAIN SELECT ... (your SELECT); from the mysql client.
Hi!
When I join 4 tables with about 3000 records in each mysql seems to work
forever on copying to tmp table.
I wonder what that could be. I have enough free space in the tmp-dir and
don't know what else could it be.
The
On Tue, 22 May 2001, Jeremy Zawodny wrote:
On Tue, May 22, 2001 at 10:37:20PM +0100, Nii Larnyoh wrote:
I have just loaded a MICROSOFT WORD document to be stored in a mySQL
blob column. I will like to know if the blob column that will be
indexed by the FULLTEXT indexer?
Given that
Please check the manual before sending a question to this list.. says
every
messages.. So:
http://www.mysql.com/doc/R/e/Reserved_words.html
I read it (please note the (*)):
A common problem stems from trying to create a table with column names that
use the names of datatypes or functions
$newgoalquery = mysql_query(select players.PLAYERID, players.FIRSTNAME,
players.LASTNAME, COUNT(goals.SCORER) as TG FROM players, goals where
(goals.SCORER = players.PLAYERID) AND players.TEAMID = '$TEAMID' GROUP BY
PLAYERID ORDER BY players.LASTNAME);
I'm trying to fetch out the number of goals
Hello,
Normally, MySQL maintains a flat log file to write all queries passed to it.
Is it possible (any module or whatever) to get it to put this log into a
specific database, in order to be
processed more efficiently?
Thanks for the reply.
Maxim Pavlov
[EMAIL PROTECTED]
I need a way to determine the size of a single database on mySQL via an SQL
command.
I am running an application on a service provider that gives me a limited
amount of database space for my application. I want to be able to gauge the
percentage of that space that I am using. The only access
If you are using only fixed-length (no VARCHARs, TEXTs or BLOBs) MyISAM
tables you can calculate it by finding the storage required for each row
(http://www.mysql.com/doc/S/t/Storage_requirements.html) and multiplying it
by the number of rows. If you are using variable-length MyISAM tables, you
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
I've (mostly) switched over from Win98 to Win2K on one of my home machines.
I have a Linux box sitting in a closet as a mail/web server, with Apache
logging its activity to a MySQL database. To browse the server logs, I
threw together a few lines of SQL in Access and had it use MyODBC to talk
From http://www.mysql.com/doc/F/u/Fulltext_Search.html:
mysql SELECT * FROM articles WHERE MATCH (title,body) AGAINST ('MySQL');
Empty set (0.00 sec)
Search for the word MySQL produces no results in the above example. Word
MySQL is present in more than half of rows, and as such, is effectively
I'm doing a school project for which I'm to write a PHP script with MySQL
that searches a dBase database.
I've got my code planned out, but the problem right now seems to be that
mySQL can't directly read dBase databases.
It's a fairly large database (9 megs), and so I ask: do I need to convert
Pat Suwalski wrote:
I'm doing a school project for which I'm to write a PHP script with MySQL
that searches a dBase database.
I've got my code planned out, but the problem right now seems to be that
mySQL can't directly read dBase databases.
It's a fairly large database (9 megs), and
No, MySQL will not read dBase files.
I can think of 3 ways to do it off the top of my head.
1: Use Visual FoxPro. It will read dBase files and you can use the DBC to
open a connection to a MySQL database through an ODBC connection. (Been
there, done that)
2: Use a dialect of *Base to create an
Hello,
I am running MySQL 3.23.37 on an OpenBSD 2.8 box. The db is working fine
and starts fine but I cannot seem to shut it down...
I do
mysql.server stop
and this is what I see in the logs:
010528 20:59:07 /usr/local/libexec/mysqld: Normal shutdown
but the command exits because it is
Martin,
You should try the following. It's work for me.
mysql connect mysql;
mysql update user set password=PASSWORD('newpassword') where user='auser';
mysqlFLUSH PRIVILEGES;
Regard,
Emanduel Chan
- Original Message -
From: Martin RODOT [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent:
I just converted a 48meg 90,000 row dbf file using dbf2mysql off of the
MySQL site. Worked very nice for me on Win2K.
Cheers
Mike
-Original Message-
From: Pat Suwalski [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 28, 2001 6:25 PM
To: [EMAIL PROTECTED]
Subject: Help! How to use dBase
- Original Message -
From: Daniele Iachini [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, May 28, 2001 6:50 PM
Subject: Help w/MySQL and Dreamweaver Ultradev
I'm not able to manage dates correctly in dreamweaver, expecially when a
form with dates is submitted to update a
i would like to convert my sql server data into
mysql, how can i do ??
/---\
Confidential and/ or privileged information may be contained in this
e-mail and any attachments transmitted with it ('Message'). If you are
not
What does this mean and how do I fix it, I just finished installing from
source tar.
[root@Precious /]# mysql -u root -p
Enter password:
ERROR 2002: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2)
Dave
At 10:22 AM -0400 5/28/01, Nicu Popovici wrote:
Hello,
I took out the m_string.h file from include directive and I get the following
error
Well, sure. You already know that you need that file; taking it out
won't help anything.
gcc -g Bug_Report.c -O -o TEST1
At 12:13 PM -0400 5/28/01, Nicu Popovici wrote:
Hello guys,
I managed to compile succesfully my C program but now when I run it I get
something like the following
---
TEST1
Failed in SELECT , Error: You have an error in your SQL syntax near ')' at
line 1
53 matches
Mail list logo
