Brian Menke wrote:
Sorry about the last post, I hope this one comes over better.
This is a bit embarrassing because I think this should be a simple WHERE
clause, but it escapes me at the moment.
I have a table with data:
module_id emailscore date_time
1 [EMAIL PROTECTED] 8
Hi,
i've noticed similar behaviour as we upgraded to mysql 5.0.
The query optimizer seems to been "optimized" a little too much :-\
-Original Message-
From: Szymon Kosok [mailto:[EMAIL PROTECTED]
Sent: Saturday, May 27, 2006 5:42 PM
Cc: mysql@lists.mysql.com
Subject: Re: MySQL 5 prob
Sorry about the last post, I hope this one comes over better.
This is a bit embarrassing because I think this should be a simple WHERE
clause, but it escapes me at the moment.
I have a table with data:
module_id email score date_time
1
This is a bit embarrassing because I think this should be a simple WHERE
clause, but it escapes me at the moment.
I have a table with data:
module_id
email
score
date_time
1
[EMAIL PROTECTED]
8
5/27/2006 12:07 AM
1
[EMAIL PROTECTED]
9
5/27/2006 12:11 AM
1
[EMAIL PROTECTED]
Dilipkumar wrote:
Dude listen,
You can given file privileges to existing users for all the Db's as
if you specify as
grant file on database.* to [EMAIL PROTECTED] identified by 'passwd'; [
*Error* ]
If you mention to all the DB for a user as:
grant file on *.* to [EMAIL PROTECTED] identifie
Dude listen,
You can given file privileges to existing users for all the Db's as
if you specify as
grant file on database.* to [EMAIL PROTECTED] identified by 'passwd'; [
*Error* ]
If you mention to all the DB for a user as:
grant file on *.* to [EMAIL PROTECTED] identified by 'passwd';
Try
Gilles MISSONNIER wrote:
> Hello
> How to set "FILE privilege enable" to an already defined user ?
>
> It seems that I have to read the all manual for that.
> I cannot find an example in the on line manual.
sheeri kritzer wrote:
> GRANT FILE ON dr4.* to 'wr'@'localhost' IDENTIFIED BY 'the_passw
Hi,
You can try this option by
grant file on *.* to [EMAIL PROTECTED] identified by 'db123';
Query OK, 0 rows affected (0.03 sec)
For all the Databases.
Gilles MISSONNIER wrote:
Thank you Sheeri for answering,
I guess this syntax works for you, but
for me NO, this DO NOT work ( I run MySQL
Hello again,
SELECT shout_avatar, shout_own, timestamp, tekst, imie, pseudo, wiek,
City, Country, plec, wlosy_kol, gra_gwiazdy.id, gra_gm.gid AS gm FROM
gra_shoutbox INNER JOIN (gra_gwiazdy) ON (gra_gwiazdy.id =
gra_shoutbox.gid) INNER JOIN (swiat_miasta) ON (swiat_miasta.CityId =
gra_gwiazdy.mi
Hi,
thank you for this hint. That worked excellent! Now the overall query
time is about 0.1 s on average.
Best regards,
Merlin
On Sat, 27 May 2006 02:14:34 -0700, "Merlin" <[EMAIL PROTECTED]> said:
> Well this is exactly the problem. The OR statement. Do you think there
> is
> another way aroun
Hi all,
I have to create a database for Chinese, Japanese and Korean Language
support and a vb.net application for same.
Well I did couple of thing for this
1. created new database with Unicode CharacterSet
2. tables are also created with Unicode Cha
Hello,
I've posted this on Gentoo forums, but I'll try here too. :)
I've made upgrade of MySQL to latest 5.0.x version. Now, when I access my
site MySQL CPU usage is about 100%, and site is unaccessible. :( I've
checked SHOW PROCESSLIST and this query take lng time to execute:
SELECT shout_a
Well this is exactly the problem. The OR statement. Do you think there
is
another way around the tmp table. I did not make the best experiances
with tmp tables.
regards,
merlin
On Sat, 27 May 2006 00:26:09 -0500, "mos" <[EMAIL PROTECTED]> said:
> Merlin,
> Lose the "OR" part of the Where
13 matches
Mail list logo
