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
)) |
+--+
|0 |
+--+
1 row in set (1.07 sec)
--
Jim Dickenson
mailto:[EMAIL PROTECTED]
Computers for Marketing Corporation
http://www.cfmc.com/
From: Hubbard, Dan [EMAIL PROTECTED]
Date: Wed, 23 Jul 2003 08:39:01 -0700
To: [EMAIL PROTECTED
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: gerald jones - Sun Microsystems
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?
--
Jim Dickenson
mailto:[EMAIL PROTECTED
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 behavior than many other databases.
--
Jim Dickenson
mailto:[EMAIL PROTECTED]
Computers for Marketing Corporation
http://www.cfmc.com
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: Tue, 5 Nov 2002
as fairly simple (no
offense ;)
:(
--
Jim Dickenson
mailto:[EMAIL PROTECTED]
Computers for Marketing Corporation
http://www.cfmc.com/
eFax: 1-419-791-8924
-
Before posting, please check:
http://www.mysql.com/manual.php
?
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
? Try: http://lists.mysql.com/php/unsubscribe.php
--
Jim Dickenson
mailto:[EMAIL PROTECTED]
Computers for Marketing Corporation
http://www.cfmc.com/
eFax: 1-419-791-8924
-
Before posting, please check:
http://www.mysql.com
, 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/
eFax: 1-419-791-8924
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 available updates
installed.
I had installed version 3.23.49 from
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:
I am having problems getting the load data local infile working.
I am running Mac
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
mailto:[EMAIL PROTECTED
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,
--
Jim Dickenson
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.
Use a decimal type instead.
Jim Dickenson wrote:
I am running mysql Ver 11.15
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, please check:
http://www.mysql.com/manual.php
[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/
eFax: 1-419-791-8924
/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 Dickenson
mailto:[EMAIL PROTECTED]
Computers
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.
--
Jim Dickenson
mailto:[EMAIL PROTECTED]
Computers for Marketing Corporation
http://www.cfmc.com/
eFax: 1-419-791
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 [EMAIL PROTECTED]
To: Dana Powers [EMAIL
to
999.99. The fact that there is room for a sign character should not
increase the number of digits allowed in the field.
--
Jim Dickenson
mailto:[EMAIL PROTECTED]
Computers for Marketing Corporation
http://www.cfmc.com/
-
Before
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 sign character should not
increase the number of digits allowed in the field.
--
Jim Dickenson
mailto:[EMAIL
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 sign character should not
increase the number of digits allowed in the field.
--
Jim Dickenson
mailto:[EMAIL
23 matches
Mail list logo