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
Hi,
Try with mysql -u root first, the installation process doesn't create a
password.
You can then use mysqladmin -u root password 'newpassword' to set it.
You can find out all about the security/permissions system here :
http://dev.mysql.com/doc/refman/5.0/en/privilege-system.html
Regards
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
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
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
You need to do a join ...
SELECT T.*
FROM transport AS T, acl AS A
WHERE T.id=A.id AND
A.adminId='1'
--Joe
--
Joe Stump [EMAIL PROTECTED]
http://www.joestump.net
-Original Message-
From: news [mailto:[EMAIL PROTECTED]]On Behalf Of Max Clark
Sent: Wednesday, December 11, 2002
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
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
Make sure you use the complete line of syntax
mysqladmin -u username -p -h hostname create databasename
password: (enter the password to that userid here)
Oh yeah sql query .
~Kelly W. Black
-Original Message-
From: john [mailto:john;cllug.org]
Sent: Monday, November 04, 2002 3:53
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
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
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
Are you trying to load data FROM a text file, or are you trying to load data
INTO a textfile?
You said I just created a database and tried to LOAD 1 line of data from a
text file. but then you stated i need to INTO OUTFILE ...
If you wanna load data from a text file into a table, look at:
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
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'
If all the databases are running in the same mysqld then it might be
possible, if you have select permission on all of them and you preface the
table names with the database name. (select * from database.table...) You
will have to use a JOIN clause to get them all into a single statement which
23 matches
Mail list logo