Brad, what user are you running the mysql server as? Have you created a
mysql user and group (or another user and group) to run the server and
set a user= option in the cnf file?
Are you absolutely sure all necessary files and directories are owned
and readable/writable only by the mysql user?
Brad Heintz wrote:
Thanks for responding.
The CREATE TABLE docs for 5.1 say that DATA DIRECTORY and INDEX
DIRECTORY take absolute paths (not relative), and will in fact reject
paths containing
the MySQL data dir. Because I'm out of other ideas, I did try
creating the directories under
John -
I've seen people confuse MySQL users with OS users, too. I'm not doing
that, and I understand the difference between MySQL privs and filesystem
permissions. MySQL is running as the mysql user. I'm running the query as
MySQL's root.
I am able to create partitioned or non-partitioned
your MySQL user will need to have GRANT FILE (as earlier suggested)
Thanks
Martin
__
Disclaimer and confidentiality note
Everything in this e-mail and any attachments relates to the official business
of Sender. This transmission is of a
That's covered, Martin. Thanks for your input.
On Sat, Dec 6, 2008 at 10:45 AM, Martin Gainty [EMAIL PROTECTED] wrote:
your MySQL user will need to have GRANT FILE (as earlier suggested)
Thanks
Martin
__
Disclaimer and confidentiality note
That's because RAND() is a decimal (0.37689672). Try score*RAND().
Brent Baisley
On Nov 30, 2008, at 2:03 AM, sangprabv wrote:
Hi,
Thans for the reply, I have tried it but I don't see the RAND() to be
work. This list is always the same. TIA
Willy
-Original Message-
From: mos
Going back to the OP's problem - the original issue I believe was he was
using old instead of OLD (case-sensitive) - now that's sorted, MySQL
is complaining about a syntax error toward the end of the function
declaration.
I'm surprised by the case sensitivity of OLD though, it works fine on
If I have a table like this:
CREATE TABLE `Test` (
`TestId` bigint(20) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1
Does using --safe-updates mean that it's impossible for me to ever delete
from it, since it doesn't have a key? For example:
If I have a table like this:
CREATE TABLE `Test` (
`TestId` bigint(20) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1
Does using --safe-updates mean that it's impossible for me to ever delete
from it, since it doesn't have a key? For example:
Hi,
I am using Spreadsheet::ParseExcel, DBI DBD::mysql to capture and
insert data into mysql tables. That's working out very well but I am
having issues with one datatype. When I capture percentages out of excel
97 the captured value might be 0.76324095 but when I attempt to select
that same
Hello Hagen,
Hagen Finley wrote:
Should I be using a different datatype for these kind of numerical
values?
Yes. INT is by definition a whole number (0, 1, 2 etc.)
You will want to change the fmarg column to DOUBLE or DECIMAL.
Regards,
Andy
--
MySQL General Mailing List
For list
11 matches
Mail list logo