Hy thank you all, I'm getting the following err msg
- The table '#sql_2c52_0' is full
running a complex query (and only running that query) with three outer join
it is a simple db that stores mail msgs
my query is about mail msg-recipients-sender
the biggest table mail_archive has 90467
Adriano -
MySQL names temp tables like that (starting with # sign), in paticular
while storing a result set to be sorted. I would guess that your
query is returning a result set large enough to hit a filesystem limit
on your box. How big are you expecting the results to be? Perhaps
you are
before all thank you for your answer,
next
while waiting for an answ3er I backup the db then tried to convert tables
in Inno db format
everything run fine now, the same query execute ok
but i prefer myIsam format i use it as default,
then I'd like to understand what is the problem,
here are
Hi: My database is mysql 4.1.14-standard. I have a
blob type field in a table1 with mutlple attributes
together in the field as shown below
table1.field1 value for a record is abc=2 def=4
ghi=10
I have table2 which has fields abc, def and ghi. I
want to be able to parse the table1.field1 and
Hello there,
I am running MySQL 5 Community Edition on Mac OS X Tiger
Here's what I did:
1. Ran the MySQL server from System Preferences
2. Launched Terminal and typed in the following:
untz$ mysql -u root -p
3. Was prompted for my password, and after entering that in, I
received this
Subject: Newbie help with MySQL
Hello there,
I am running MySQL 5 Community Edition on Mac OS X Tiger
Here's what I did:
1. Ran the MySQL server from System Preferences
2. Launched Terminal and typed in the following:
untz$ mysql -u root -p
3. Was prompted for my password, and after
many thanks
that was exactly what I needed.
Building upon the initial question:
Is there a way to get Match statements to do partial word
searches...like %LIKE% ?
For example, if the below Match Against query with 'chris' does not
bring up anything...
AND MATCH (
media.name, media.product
Graham Anderson [EMAIL PROTECTED] wrote on 04/14/2005 11:51:58 AM:
many thanks
that was exactly what I needed.
Building upon the initial question:
Is there a way to get Match statements to do partial word
searches...like %LIKE% ?
For example, if the below Match Against query with
Hi
I am trying to set up my Match statements to filter the result of the
main query [which works]
If 'chris' does not exist in the first MATCH statement [AND MATCH
(media.name, media.product)], then the results get a bit screwed up :(
If the first match statement finds something, then the
Graham Anderson [EMAIL PROTECTED] wrote on 04/13/2005 01:46:35 PM:
Hi
I am trying to set up my Match statements to filter the result of the
main query [which works]
If 'chris' does not exist in the first MATCH statement [AND MATCH
(media.name, media.product)], then the results get a bit
Am new to mysql and have some difficulty in retrieveing data from 3 tables
using the Query Browser(version 1.0.8).
I have 3 tables (axkde, axuser,axdev). All 3 tables have
'id','sender','reply'fields. Id is unique in all 3 tables.
Now I want a query to extract data from the 3 tables.
On Thu, 2004-07-08 at 00:19, Paul DuBois wrote:
At 22:34 +0530 7/7/04, Sanjay Arora wrote:
I am using Mysql on RH Linux 9. I am getting the following error.
Command and result are given below alongwith \s output for diagnostic
purposes.
I have created a dns database and am trying to create
Sanjay Arora wrote:
On Thu, 2004-07-08 at 00:19, Paul DuBois wrote:
At 22:34 +0530 7/7/04, Sanjay Arora wrote:
I am using Mysql on RH Linux 9. I am getting the following error.
Command and result are given below alongwith \s output for diagnostic
purposes.
I have created a dns database and am
I am using Mysql on RH Linux 9. I am getting the following error.
Command and result are given below alongwith \s output for diagnostic
purposes.
I have created a dns database and am trying to create a user mysql user
dns with all privileges on it.
mysql use mysql
Reading table information for
Sanjay Arora mailto:[EMAIL PROTECTED]
on Wednesday, July 07, 2004 10:04 AM said:
I am using Mysql on RH Linux 9. I am getting the following error.
[snip]
Database changed
mysql GRANT ALL PRIVILEGES ON dns.* TO [EMAIL PROTECTED] IDENTIFIED BY
PASSWORD dns;
ERROR 1133: Password hash
At 22:34 +0530 7/7/04, Sanjay Arora wrote:
I am using Mysql on RH Linux 9. I am getting the following error.
Command and result are given below alongwith \s output for diagnostic
purposes.
I have created a dns database and am trying to create a user mysql user
dns with all privileges on it.
mysql
how can i change the data type of a table? I'm not sure if that is my
problem. If anyone is interested here is a link what I've been trying to
do:
http://www.phpbuilder.com/board/showthread.php?threadid=10248279goto=newpost
Thanks for any help given!
H
Sean Berry [EMAIL PROTECTED] wrote:
I need to know how to be able to read in data from to mysql from two different
places. For example from /usr/local/mysql and /usr/local/data
You can use symlinks:
http://www.mysql.com/doc/en/Symbolic_links.html
--
For technical support
I need to know how to be able to read in data from to mysql from two different places.
For example from /usr/local/mysql and /usr/local/data
Please help me if you have any answer. Thanks for your response.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
Help!
I am a new mysql user, I understand the basic syntax of the commands for
different sql queries.
I am trying to write a query and I can't seem to figure it out. I would
like to select all domain,transport fields from the transport table
where the transport id = a query agains the acl
:26 AM
To: [EMAIL PROTECTED]
Subject: Newbie- Help with query
Help!
I am a new mysql user, I understand the basic syntax of the commands for
different sql queries.
I am trying to write a query and I can't seem to figure it out. I would
like to select all domain,transport fields from
Well, not so much a newbie as scratcher of the surface :)
I've used MySQL on my desktop under windows for a while. Never had any
issues with it from the straight install. Am using 3.23.38 and MyOBDC
2.50-36.
Recently (I don't know if this is relevant) upgraded to win XP Pro SP1.
Now I've
Sorry should have made clear that is what phpMyAdmin gives me in the
browser.
WinMySQLadmin seems to be fine.
-Original Message-
From: Martin Wright [mailto:[EMAIL PROTECTED]]
Sent: 26 November 2002 11:19
To: '[EMAIL PROTECTED]'
Subject: Newbie Help! Can't connect to MySQL server
john,
Saturday, November 09, 2002, 9:45:15 PM, you wrote:
j Ok.. I got the /etc/my.cnf under control, but now when I do this:
j root@rock:/etc# mysqladmin -u root -h rock password *
j mysqladmin: connect to server at 'rock' failed
j error: 'Host 'rock.biohazard.org' is not allowed to connect
I dont have a my.cnf file, so I touched /etc/my.conf still doesnt
work. Where do
I find a .cnf file to copy over?
and
root@rock:/var/run/mysql# ls
mysql.sock= it exists.
What could my problem be..? I even upgraded. I am using Slackware 8.1
with 2.4.19 kernel. Maybe that will help.
Thanks so
Ok.. I got the /etc/my.cnf under control, but now when I do this:
root@rock:/etc# mysqladmin -u root -h rock password *
mysqladmin: connect to server at 'rock' failed
error: 'Host 'rock.biohazard.org' is not allowed to connect to this
MySQL server'
Then I tried this:
root@rock:/etc#
On Sat, 2002-11-09 at 14:45, john wrote:
Ok.. I got the /etc/my.cnf under control, but now when I do this:
root@rock:/etc# mysqladmin -u root -h rock password *
mysqladmin: connect to server at 'rock' failed
error: 'Host 'rock.biohazard.org' is not allowed to connect to this
MySQL
When I start safe_mysqld , I get a command prompt back again and ps aux
shows this:
mysql30269 0.0 0.1 10580 1024 pts/1S17:38 0:00
/usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql
--pid-file=/var/lib/mysql/rock.pid
mysql30271 0.0 0.1 10580 1024 pts/1
PM
To: [EMAIL PROTECTED]
Subject: Newbie help needed with mysql
When I start safe_mysqld , I get a command prompt back again and ps aux
shows this:
mysql30269 0.0 0.1 10580 1024 pts/1S17:38 0:00
/usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql
--pid-file=/var
On Mon, 2002-11-04 at 18:52, john wrote:
When I start safe_mysqld , I get a command prompt back again and ps aux
shows this:
mysql30269 0.0 0.1 10580 1024 pts/1S17:38 0:00
/usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql
On Friday 06 September 2002 05:50 pm, Marcelo Simon wrote:
Well, I'm not 100% certain since I don't know what environment you're working
in, but a typical example from perl might be something like
my $query = INSERT INTO foo
Hi,
First time here, hope someone can understand me and help me.
I have a field wich type that is int(4), and I'm updating it from a form. it
is working ok, unless the formfield is empty. When it's empty I'm receiving
an SQL error number 51().
In the db the field is setup to receive empty
Sorry for the confusion. I have not checked www.MySQL.org in such a
long time.
I was referring to the period of time when NuSphere (Progress) had owned
MySQL.org and appeared to be falsely representing themselves as the
MySQL developers.
I'm sure you now know what I intended.
Regards,
if it's an imposterer, its a fairly decent looking mirror :)
-bobby
- Original Message -
From: Ryan Hatch [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, May 09, 2002 10:31 PM
Subject: Re: newbie help
bd...
Two things here:
1.) Mysql.org
I just created a database and tried to LOAD 1 line of data from a text file.
I have only 9 coloums , most varchar, one char, one smallint (autoincrement)
when i load the data (tab de-limeted) it goes fine but i get one Warning.
I found on mysql.org that i need to INTO OUTFILE and look for
bd...
Two things here:
1.) Mysql.org is an IMPOSTER's site. www.MySQL.com is the real site.
and
2.) You haven't given us the warning / error message you received.
-Ryan Hatch
[EMAIL PROTECTED] wrote:
I just created a database and tried to LOAD 1 line of data from a text file.
I have
Mysql.org is an IMPOSTER's site. What?
They are one in the same.
-Original Message-
From: Ryan Hatch [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 09, 2002 1:31 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: newbie help
bd...
Two things here:
1.) Mysql.org
:[EMAIL PROTECTED]]
Sent: Thursday, May 09, 2002 1:31 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: newbie help
bd...
Two things here:
1.) Mysql.org is an IMPOSTER's site. www.MySQL.com is the real site.
and
2.) You haven't given us the warning / error message you received
Maybe the poster of the message is an imposter developer too?
MS
-Original Message-
From: Steve Buehler [EMAIL PROTECTED]
To: mysql [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED] [EMAIL PROTECTED]
Date: Thursday, May 09, 2002 3:01 PM
Subject: RE: newbie help
What makes you think
://www.mysql.com/doc/L/O/LOAD_DATA.html
If you wanna load data into a text file, look at:
http://www.mysql.com/doc/S/E/SELECT.html
Gurhan
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 09, 2002 3:34 PM
To: [EMAIL PROTECTED]
Subject: newbie help
Hi all,
I have a table that has data that looks something like this (fixed font on):
UserID MessageID MessageState
1 1 PENDING
1 2 PENDING
2 3 FAILED
3 4 DELIVERED
2
you can use:
select messagestate, count(*) from table where uid=1 group by messagestate;
for uid=1, if you want to do the same for all users with one query you
can use:
select uid, messagestate, count(*) from table group by uid, messagestate;
Regards,
Ben Holness wrote:
Hi all,
I have
I have a Redhat 7.1 box, I want it to connect to its own mysql db . Here is
my code
#include stdio.h;
#include mysql.h;
int main(char **args){
MYSQL_RES *result;
MYSQL_ROW row;
MYSQL *connection, mysql;
int state;
/* connect to the mysql db */
mysql_init(mysql);
jim and lois flaherty wrote:
gcc analysis.c
analysis.c:6:19: warning: extra tokens at end of #include directive
analysis.c:7:19: warning: extra tokens at end of #include directive
/tmp/ccsKk2GG.o: In function `main':
/tmp/ccsKk2GG.o(.text+0x14): undefined reference to `mysql_init'
Hi just ported a web site from one server
to my own. MySQL is running just fine.
When I run my page that talks to my
database however, I get this;
mySQL: table does not exist or has no columns
...then the rest of the page comes in just fine.
Any idea what I have missed here?
THX
Mike
I see most of you are experienced developers. Can someone point me in a
direction (tutorial..) to learn MySQL? I've successfully set up phpMyAdmin
on my site, but I'm afraid I'm still lost..
-
Before posting, please check:
On 10 May 2001, at 10:26, Scott Abbotts wrote:
I see most of you are experienced developers. Can someone point me in a
direction (tutorial..) to learn MySQL? ...
I'm not sure there's a better place to go than Paul Dubois's book on
MySQL. It's about $35 and more than worth every penny...
: general newbie help
I see most of you are experienced developers. Can someone point me in a
direction (tutorial..) to learn MySQL? I've successfully set up phpMyAdmin
on my site, but I'm afraid I'm still lost..
-
Before
Subject: Re: general newbie help
On 10 May 2001, at 10:26, Scott Abbotts wrote:
I see most of you are experienced developers. Can someone point me in a
direction (tutorial..) to learn MySQL? ...
I'm not sure there's a better place to go than Paul Dubois's book on
MySQL. It's about $35
At 5/10/01 10:37 AM, Bernie Cosell wrote:
On 10 May 2001, at 10:26, Scott Abbotts wrote:
I see most of you are experienced developers. Can someone point me in a
direction (tutorial..) to learn MySQL? ...
I'm not sure there's a better place to go than Paul Dubois's book on
MySQL. It's
At 10:37 AM -0400 5/10/01, Bernie Cosell wrote:
On 10 May 2001, at 10:26, Scott Abbotts wrote:
I see most of you are experienced developers. Can someone point me in a
direction (tutorial..) to learn MySQL? ...
I'm not sure there's a better place to go than Paul Dubois's book on
MySQL.
- booksellersolutions.com
[mailto:[EMAIL PROTECTED]]
Sent: Friday, March 09, 2001 11:19 AM
To: [EMAIL PROTECTED]
Subject: newbie help
I have several seperate databases which i would like to search using one sql
query.
All stores have varying field names:
store1.products - author,title,description ...and other
52 matches
Mail list logo