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;
++
|
mysql select 798 between 75.2 and 999.1;
++
| 1 |
++
mysql select 798 between 75.2 and 1e30;
+---+
| 0 | Really?
+---+
mysql
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 for an
KCI
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;
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 */
Galen,
snip detail - see previous post
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
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
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
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
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 use?
I
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
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
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.
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
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 put
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 Message
16 matches
Mail list logo