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 archiv
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 dat
>
> 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:
>>
>
>
> http://dev.mysql.
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:
http://dev.mysql.com/doc/refman/5.0/en/mys
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
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 <[EMA
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 no
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 confidential
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 tabl
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 un
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? Set
11 matches
Mail list logo
