http://www.serverlogistics.com/mysql.php has a link to a Preference Pane
item that can be used to start and stop MySQL. You will need to modify the
/Library/StartupItems/MySQL/MySQL file to point to the correct location.
--
Jim Dickenson
mailto:[EMAIL PROTECTED]
Computers for Marketing
ENCODE("hello","goodbye")) |
+--+
|0 |
+------+
1 row in set (1.07 sec)
--
Jim Dickenson
mailto:[EMAIL PROTECTED]
Computers for Marketing Corporation
http://www.cfmc.com/
> From: "Hubbard, Dan" <[EMA
Go to the /usr/local/mysql directory and rename (mv) data to var.
--
Jim Dickenson
mailto:[EMAIL PROTECTED]
Computers for Marketing Corporation
http://www.cfmc.com/
> From: gerald jones - Sun Microsystems - Broomfield United States
> <[EMAIL PROTECTED]>
> Reply-To: ger
o do updates to their database?
In previous versions I was not able to get any table with a float to update.
Now, before my change, I could not even get a table with any numeric data to
update. How are others able to use software that prevents them from updating
a table that has numeric data?
--
Ji
>
>> mysql> INSERT INTO t SET d = 1234567890.12;
>> Query OK, 1 row affected (0.01 sec)
A different question would be why does MySQL not generate an error or
warning on the insert when it mangled the value?
Also decimal(10,2) will store -12345678.90 as well.
This is different be
to be configured to allow
access to the Mac. Many routers have an option to not respond to ping
requests as well.
--
Jim Dickenson
mailto:dickenson@;cfmc.com
Computers for Marketing Corporation
http://www.cfmc.com/
eFax: 1-419-791-8924
> From: David Buxton <[EMAIL PROTECTED]>
> Date
p.s. i could (and have to some degree) read and read the documentation
> for MySQL and phpMyAdmin (and Apache) and it seems to be taking me
> YEARS to understand what many of you must realize as fairly simple (no
> offense ;)
> :(
>
>
--
Jim Dickenson
mailto:[EMAIL PROTECTED]
Comput
quot; way to restart MySQL on OS X?
>
> I did mysqladmin -p shutdown then safe_mysqld...is this the same as
> if the machine started up?
--
Jim Dickenson
mailto:[EMAIL PROTECTED]
Computers for Marketing Corporation
http://www.cfmc.com/
--
--
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PRO
ql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
Jim
On 4/9/2002 9:41 AM, "Paul DuBois" <[EMAIL PROTECTED]> wrote:
> At 9:31 -0700 4/9/02, Jim Dickenson wrote:
>> On 4/8/2002 7:25 PM, "Paul DuBois" <[EMAIL PROTECTED]> wrote:
>>
>>> At 17:52 -0700 4/8/02, Jim Dickenson wrote:
>>>>
On 4/8/2002 7:25 PM, "Paul DuBois" <[EMAIL PROTECTED]> wrote:
> At 17:52 -0700 4/8/02, Jim Dickenson wrote:
>> I am having problems getting the "load data local infile" working.
>>
>> I am running Mac OS X 10.1.3 build 5Q110 with all availab
tate the exchange of setups it would
be nice not to have to specify the fully qualified name. As I mentioned this
is the way it used to work in some recent version. I do not know what
version made it necessary to specify the full name.
Thanks for any help with these items.
--
Jim Dickenson
mai
ey do work. We are using
computers after all.
On 2/1/2002 2:06 PM, "Gerald Clark" <[EMAIL PROTECTED]>
wrote:
> A floating point number can never be equal to 12.3.
> It can be close, and with rounding display as 12.3, but it
> won't actually be equal to 12.3.
> Us
---+
6 rows in set (0.00 sec)
The following command does not update the row I would like it to:
mysql> update junk set num1=12.4 where num1=12.3;
Query OK, 0 rows affected (0.01 sec)
Rows matched: 0 Changed: 0 Warnings: 0
Can I get some insight as to what the problem might be?
Thanks,
t" not in the "fetched set". I do not think that this is
correct.
--
Jim Dickenson
mailto:[EMAIL PROTECTED]
Computers for Marketing Corporation
http://www.cfmc.com/
eFax: 1-419-791-8924
-
Before posting, ple
ql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
Jim Dickenson
mailto:[EMAIL PROTECTED]
Co
request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
Jim Dickenson
mailto:[EMAIL PROTECTED]
Computers for Marketing Corporation
http://www.cfmc.com/
On 9/18/01 1:45 PM, Dana Powers at [EMAIL PROTECTED] wrote:
> And my question is, if you've defined your column to have (10,2) precision,
> why would you try to insert a higher precision number?
> dpk
>
> - Original Message -
> From: "Jim Dickenson"
SQL is allowing 11 digits to
be put into the database.
If my ODBC application expects data in a certain range based on the
information returned from SQLDescribeCol then it will not be expecting to
see a number with 11 digits in it.
This is what I think is wrong with the behavior of MySQL.
--
Ji
On 9/18/01 8:01 AM, Chris Johnson at [EMAIL PROTECTED] wrote:
> On Sun, Sep 16, 2001 at 02:11:20PM -0700, Jim Dickenson wrote:
>> Does anyone have an opinion about the following? Are people using decimal
>> type fields? Is it important for the database to allow only allowed d
r as I specified a maximum of 9
digits. Per your description of numeric() the value should be set to
999.99. The fact that there is room for a sign character should not
increase the number of digits allowed in the field.
--
Ji
m1|
+-+
| -999.99 |
+-+
1 row in set (0.00 sec)
mysql> quit
Bye
I think the first update should get an error as I specified a maximum of 9
digits. Per your description of numeric() the value should be set to
999.99. The fact that there is room for a sig
m1|
+-+
| -999.99 |
+-+
1 row in set (0.00 sec)
mysql> quit
Bye
I think the first update should get an error as I specified a maximum of 9
digits. Per your description of numeric() the value should be set to
999.99. The fact that there is room for a sig
24 matches
Mail list logo
