Keith,
Thanks for your comments.
KCI> It looks like the min and max are rounded to integers. Try
KCI> "SELECT 2 BETWEEN 2.1 AND 5" or "SELECT 3 BETWEEN 2 AND 2.8".
KCI> Also, the exponential numbers are converted to integers, not
KCI> truncated at the "e". It's just that your 1e30 is too big fo
>>mysql> select 798 between 75.2 and 999.1;
>>++
>>| 1 |
>>++
>>
>>mysql> select 798 between 75.2 and 1e30;
>>+---+
>>| 0 |<<< Really?
>>+---
MySQL,
I'd have expected all three of the following to give the same result,
but even if there's a type-conversion problem from INT, then I
certainly wouldn't expect it to be different for 798.1 and 1e30 for
example...
mysql> select 798 between 75.2 and 999.1;
++
| 7
MySQL,
This is a bug, isn't it?
mysql> select 798 between 75.2 and 999.1;
++
| 798 between 75.2 and 999.1 |
++
| 1 |
++
1 row in set (0.01 sec)
mysql> select 798 between 75.2 and 1e30;
+
Galen,
GWW> There is definitely something wrong with the parser. The '--'
GWW> should not be interpreted as a single line comment, causing the
GWW> first '*/' to be ignored, so the the entry for the 'id' column is
GWW> considered to be part of the multi-line comment until the '*/' at
GWW> the e
Hi,
I tried something like the following (MySQL 3.23.36 on RH7.1) and got
the error indicated below.
create table product ( /* The main table -- see below... */
id int not null auto_increment,/* some text here */
parid int not null,/* and here */
Benjamin,
In response to your mail of Friday, May 31, 2002 1:24:17 AM:
BP> Hello.
Thanks for the feedback.
BP> 3.23.36 is a bit outdated by now
Sure -- actually that's why I was vague about the side-issue (below)
and why I checked the changelogs for an explicit fix to my main
problem.
BP>
Hi,
(FYI: "mysql Ver 11.13 Distrib 3.23.36, for redhat-linux-gnu (i386)")
After extensive testing, I have found that: -
(a) [SIDE ISSUE]
Logged-in as a user (using password) and modifying privileges in
another MySQL (root) session, even with "flush privileges", the
privileges do not
Egor,
EE> Yeah, "Access denied" error means that user doesn't have necessary
EE> permissions. Can you provide some more info? i.e. full error
EE> message, how did you set up file_priv using GRANT statement or
EE> updated privilege tables manually? What version MySQL client and
EE> server do you u
So, why do I keep getting the following? What does it mean? Has my
mail been delivered to the mailing list or not?
This is a forwarded message
From: Mailer-Daemon <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Date: Thursday, May 30, 2002, 11:20:03 AM
===8<==Original message text==
Hi,
I have a user for doing a select-to-outfile, and I've granted both the
file privilege and also (just for the table in question) the select
privilege to that user.
Trying it at the command-line gives me "Access denied..." which seems
like it can't be the case having granted the correct privil
Hi,
I have a user for doing a select-to-outfile, and I've granted both the
file privilege and also (just for the table in question) the select
privilege to that user.
Trying it at the command-line gives me "Access denied..." which seems
like it can't be the case having granted the correct privil
HN> How can I set a datasource name (DSN) for a database in MySQL?
Get MyODBC for the platform where you want the DSN available, then
enter the MySQL server & database details for a "machine DSN" using
your ODBC administration facilities on the platform where you want the
DSN to be available.
Ho
KB> Doesn't mysql support begin and rollback transactions?
I *believe* it went like this -- syntax supported and returned success
without doing anything in older versions, then functionality was
actually *implemented* more recently -- maybe only most recent stable
release? (v3.23)
L> Ok i'm still a little bit lost. I have a database in MySQL called "irm"
L> In the ODBC Data Source 32 bit I went in user dsn and added user data source
L> called irm the driver is mysql
L> not this is were i dont understand .
L> In the field that says Windwos DSN name I put "irm"
L> MySQL I
HHG> You must go to control panel of windows in Data Sources(ODBC) section and add
your DSN of you new MySQL database and then you can explor the database by browsing
your ODBC avilable databases .
HHG> You can check MyODBC manual for this .
Yes, this worked for me too.
However ... I can only
U> Hi,
U> I did the binary installation. Yes, I restarted and checked again,
U> it shows same.
The other thing to check is permissions on the directory / sock file
for the user that you're logged-in as. Are you logged-in as the same
user as yesterday?
U> Regds
U> Ujwol
U> - Original Messa
17 matches
Mail list logo
