Re: 2-Questions: Starting MySQL and Shutting Down on OS X
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 Corporation http://www.cfmc.com/ From: Santino [EMAIL PROTECTED] Date: Fri, 5 Sep 2003 19:22:12 +0200 To: [EMAIL PROTECTED] Subject: Re: 2-Questions: Starting MySQL and Shutting Down on OS X You have to make a script and put it in a folder (sorry I don't remember the name but it is on /System/startup) Try to locate a shell script like cron in a cron directory and modify it creating a script mysql in a mysql directory. To start: cd /user/local/mysql/data ./bin/mysqld_safe To stop mysqladmin shutdown Santino At 8:47 -0400 5-09-2003, Fortuno, Adam wrote: All: (1) I've got /user/local/mysql/data in my path, but when I attempt to run mysqld_safe I get a message reading: Please do a cd to the mysql installation directory and restart this script from there as follows: ./bin/mysqld_safe Do I really need to be in the installation directory to kick-off the MySQL server? If so, why? (2) Anyone running OS X have a good way to automatically shut MySQL server before shutdown. Currently, I've got to do it manually. If someone else sits at my workstation, they may or may not restart/shutdown without shutting down the server. Before I invest time in trying to resolve, let me know if there is something quick and easy out there. Regards, Adam Adam Fortuno (E-mail).vcf -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: What is a good benchmark?
On my 1Ghz Mac PowerBook with 1GB RAM using version 4.0.13 with OS 10.2.6 mysql SELECT BENCHMARK(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,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 [EMAIL PROTECTED] Date: Wed, 23 Jul 2003 08:39:01 -0700 To: [EMAIL PROTECTED] Subject: RE: What is a good benchmark? On my 2 * 2.8Ghz 2GB RAM, Redhat 8: mysql SELECT BENCHMARK(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,ENCODE(hello,goodbye)) | +--+ |0 | +--+ 1 row in set (0.66 sec) -Original Message- From: John Griffin [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 8:02 AM To: Bryan Koenig; [EMAIL PROTECTED] Subject: RE: What is a good benchmark? On my 1.8GHz p4 with 512Gig of RAM I get: mysql SELECT BENCHMARK(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,ENCODE(hello,goodbye)) | +--+ |0 | +--+ 1 row in set (0.91 sec) mysql John -Original Message- From: Bryan Koenig [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 10:46 AM To: [EMAIL PROTECTED] Subject: RE: What is a good benchmark? On my p4 2gig mysql SELECT BENCHMARK(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,ENCODE(hello,goodbye)) | +--+ |0 | +--+ 1 row in set (0.86 sec) -Original Message- From: Jake Johnson [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 8:34 AM To: Mysql Subject: What is a good benchmark? I ran this benchmark on my pIII 500 and was wondering what everyone else was getting? mysql SELECT BENCHMARK(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,ENCODE(hello,goodbye)) | +--+ |0 | +--+ 1 row in set (2.59 sec) Regards, Jake Johnson [EMAIL PROTECTED] __ Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on Rims, Car Audio, and Performance Parts. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: os X install mySQL help
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 - Broomfield United States [EMAIL PROTECTED] Date: Thu, 5 Jun 2003 13:18:29 -0600 (MDT) To: [EMAIL PROTECTED] Subject: os X install mySQL help This is a mac os X installation problem: When I download/install the pkg version of mysql 4.0.13, two directories seem to be missing in /usr/local/bin/mysql: var/ and run/. So, when I try to run mysqld_safe (or safe_mysqld), I get errors like: touch: /usr/local/mysql/var/myhostname.err: No such file or directory Starting mysqld daemon with databases from /usr/local/mysql/var... followed by alot more errors which basically say, you don't have a var/ directory or a run/ directory. Is this addressed anywhere in the manual? If I run sudo ./bin/mysqld_safe, I get the mysqld ended error, and this is what my .err file says about it: Can't start server : Bind on unix socket: No such file or directory 030605 10:59:08 Do you already have another mysqld server running on socket: /usr/local/mysql/run/mysql_socket ? 030605 10:59:08 Aborting what's going on here, I've been trying to install this for 10 hours??? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
A small change
I would like to purpose a change to MyODBC's cursor.c starting around line 441. /* @type: myodbc3 internal @purpose : checks for the float comparison in where clause */ static my_bool if_float_field(STMT FAR *stmt, MYSQL_FIELD *field) { if (field-type == FIELD_TYPE_FLOAT || field-type == FIELD_TYPE_DOUBLE || ((field-type == FIELD_TYPE_DECIMAL) (field-decimals != 0)) ) { set_error(stmt,MYERR_S1000, Invalid use of floating point comparison in positioned operations,0); return 1; } return 0; } For the life of me I do not know why more people are not upset with the way MySQL can not compare equality for floating point numbers. If the program allowed one to set some variance that they would allow for equality compares then the software could use this to check that the values were within this variance and consider the compare as true. For sure a field declared as decimal(3,0) should be able to be used in a where clause without problems. This is a whole number and should not cause a problem. As MyODBC constructs a where clause that includes all fields in the table, how can anyone use MyODBC to 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? -- Jim Dickenson mailto:[EMAIL PROTECTED] - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL Decimal Column Types Question
From: Michael She [EMAIL PROTECTED] Date: Fri, 20 Dec 2002 21:18:44 -0500 To: Paul DuBois [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: MySQL Decimal Column Types Question At 06:17 PM 12/20/2002 -0600, Paul DuBois wrote: At 17:21 -0500 12/20/02, Michael She wrote: Hi all, What does a 10,2 decimal definition mean. Is it 10 Digits in total with 2 decimal places OR 10 integer digits with 2 decimal places? The former. For a 10,2 decimal column, should this be a valid number: 1234567890.12? It's easy to test: mysql CREATE TABLE t (d DECIMAL(10,2)); Query OK, 0 rows affected (0.01 sec) mysql INSERT INTO t SET d = 1234567890.12; Query OK, 1 row affected (0.01 sec) mysql SELECT * FROM t; +--+ | d| +--+ | 9.99 | +--+ 1 row in set (0.00 sec) The value's been clipped to the upper end of the range. Your next question should be why that value has 9 digits to the left of the decimal point. :-) How did you guess! This behaviour is why I asked the question in the first place. Why does it get clipped for a 10 digit number. Without the decimal value I believe it inserts correctly, but with the 2 decimal places it get clipped... -- Michael She : [EMAIL PROTECTED] Mobile : (519) 589-7309 WWW Homepage : http://www.binaryio.com/ 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 behavior than many other databases. -- 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Granting access to MySQL via OS X
Mac OS 10.2 has a firewall built in and the default, as I recall, is to block access to most ports. Look at the Sharing pane of the System Preferences application. There is a Firewall tab where you can control the various aspects of the firewall. As mentioned, if you have a router, it might need 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 13:23:32 + To: [EMAIL PROTECTED] Subject: Re: Granting access to MySQL via OS X On Tuesday, November 5, 2002, at 10:40 am, Mark S Lowe wrote: So I have a beautiful installation of mySQL. I now need to open the pipe to my 3306 port to the outside world directly. When I have people ping my IP, they get a restricted bounce error message. I assume there is a configuration file that needs to be backed off, but I can't seem to find anything anywhere. A failed ping does not necessarily mean a MySQL client cannot connect. What happens when you try to connect using the MySQL command-line client from another computer inside your network? If that works, and connecting from outside the network does not work, then probably something else is blocking access to port 3306 for the outside world. And if your router is doing NAT, have you mapped your external public:3306 to the private internal:3306 ? David B. - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: about hostnames after setup of MySQL
On 9/30/2002 12:14 AM, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Mac OS XS 10.2 when you install the OS you have the oppt'y to put in a machine name (not the AppleTalk, Sharing name). i almost always put in a name. that name (mbase), it is also my default web host; that name also shows up at my terminal prompt (instead of the usual localhost). if i look under Machines in NetInfoMgr., it will only show localhost, but fine, everything works fine. This section of NetInfo Manager is like the hosts file found in many other Unix flavors. It is used by DNS to find the IP address of a given host. If you want to add mbase you can. You can add any entry that you would normally add to the /etc/hosts file. however, when i setup MySQL, if i select browse, using phpMyAdmin, on the mysql db, user table, (see link), i can see localhost and mbase once each for each instance. while i believe this isn't hurting anything, i'd like to understand it and i'd also like to know if some of them can be deleted (using the the 'delete' link shown)? that is, how they got created [why]? and are any redundant? I am guessing that when the database was setup the software uses the hostname command to find the name of your system and adds an entry for this, as well as localhost. From a terminal prompt you can use the hostname command to see what the hostname has been set to. The hostname for an OS X system is set in the file /etc/hostconfig. As to if you need both entries, this depends on how you connect to the database. If you are connecting from localhost (127.0.0.1) only then you do not need the other entries. If you are going to connect from the IP address your system has, then you will need the other entry. you can see an image of what i refer to at: http://mbase.shacknet.nu the image is exactly as it was created by my system/mysql. thanks in advance, Ted 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] Computers for Marketing Corporation http://www.cfmc.com/ eFax: 1-419-791-8924 - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: restarting MySQL on OS X
There is a link for mysql-startupitem.pkg.tar.gz on http://www.entropy.ch/software/macosx/mysql/ This will install the startup stuff needed to do what you want. On 5/21/2002 5:43 AM, Alex Pilson [EMAIL PROTECTED] wrote: I was wondering if anyone knew the proper 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Automatic Startup of mysqld in Mac OS X
Here is a link to an installer that will install the needed parts to cause MySQL to start on restarts of the computers. http://www2.entropy.ch/download/mysql-startupitem.pkg.tar.gz On 4/18/2002 2:33 PM, Russell E Glaue [EMAIL PROTECTED] wrote: Yes. Look in this months digest. There is a thread about this. -RG On Thu, 18 Apr 2002, Jimi Oleksiak wrote: I am having real trouble trying to get mysqld to start automatically when I restart my Mac OS X or Mac OS X Server systems. I am reading the MySQL document, chapter 2.4.3, and have tried many different approaches. I can get mysqld to start manually from the terminal window, as follows su safe_mysqld But not from startup. Does anyone have any experience with this? Thank You, Jimi Oleksiak - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 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 - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: load data infile file location???
Did you try load data local? That way, as I understand things, the server is not reading the data the client is. On 4/12/2002 1:26 PM, BJ Phillips [EMAIL PROTECTED] wrote: I can load files from '/home/mysql' but when trying to do it from any other user ('/home/user/directory'), I get an error 13 about cannot get stat on file such and such. The files are located on the server and are owned by the user, both mysql user and the system user. I specify the full path to the files, but still no good. Like I said, the only difference is the location of the files/home/mysql versus /home/user. What is the deal? Thanks for you time, -=BJ=- - 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 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 - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problems with Mac OS X
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 http://www.entropy.ch/software/macosx/mysql/ and found that a change was made in verion 3.23.49 as related to the use of local files. I added --local-infile=1 when I run mysql and the command was accepted. The problem I was then having is that if I issued the following command load data local infile 'mt2308.dat' into table mt2308 ; mt2308.dat was not found. I had to specify the fully qualified file name for the command to work. This is a change from the way it used to work as I recall. It was the case that at one time this command would find the file if the file was in the current working directory. I don't have any problem with unqualified filenames under Mac OS X. Still works like it used to. Perhaps --local-infiile=1 isn't actually having any effect, so the server is still really reading the file. Do you have the FILE privilege? If so, that might be the case. You can test that by making the file mode 600 so it's readable only to you, and then loading the file with the full pathname. If that's what's happening, the server will no longer be able to read it. (Assuming it doesn't run as you.) I suppose another possibility is that you're not really running mysql in the same directory where the file is located, although that seems unlikely -- unless maybe mysql is actually aliases to something weird. I had some other version of mysql executables in /usr/local/bin so I was not running the application I thought I was. Thanks for making me look at what really got executed when I said mysql. I then went to www.mysql.com and looked at what binary distributions were there for Mac OS X. First I downloaded version 3.23.49 but when I tried to run that version /usr/lib/libpthread.A.dylib was not found. I could not find where I could get this library. I then picked up version 3.23.47 and although I did not need to use --local-infile=1 the file was not find unless I specified the fully qualified file name. Two questions. First, what can I do to get the MySQL version 3.23.49 working on my system so I have the current version of the software? Second, what can be done so I do not need to specify the fully qualified file name? This still leaves the question as to when version 3.23.49a will be compiled for Mac OS X, instead of version 3.23.47. Thanks for any help with these items. -- 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 (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 for Marketing Corporation http://www.cfmc.com/ eFax: 1-419-791-8924 - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problems with Mac OS X
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 OS X 10.1.3 build 5Q110 with all available updates installed. I had installed version 3.23.49 from http://www.entropy.ch/software/macosx/mysql/ and found that a change was made in verion 3.23.49 as related to the use of local files. I added --local-infile=1 when I run mysql and the command was accepted. The problem I was then having is that if I issued the following command load data local infile 'mt2308.dat' into table mt2308 ; mt2308.dat was not found. I had to specify the fully qualified file name for the command to work. This is a change from the way it used to work as I recall. It was the case that at one time this command would find the file if the file was in the current working directory. I don't have any problem with unqualified filenames under Mac OS X. Still works like it used to. Perhaps --local-infiile=1 isn't actually having any effect, so the server is still really reading the file. Do you have the FILE privilege? If so, that might be the case. You can test that by making the file mode 600 so it's readable only to you, and then loading the file with the full pathname. If that's what's happening, the server will no longer be able to read it. (Assuming it doesn't run as you.) I suppose another possibility is that you're not really running mysql in the same directory where the file is located, although that seems unlikely -- unless maybe mysql is actually aliases to something weird. I had some other version of mysql executables in /usr/local/bin so I was not running the application I thought I was. Thanks for making me look at what really got executed when I said mysql. Heh. Wait until you start running about 10 different versions. :-) I then went to www.mysql.com and looked at what binary distributions were there for Mac OS X. First I downloaded version 3.23.49 but when I tried to run that version /usr/lib/libpthread.A.dylib was not found. I could not find where I could get this library. I then picked up version 3.23.47 and although I did not need to use --local-infile=1 the file was not find unless I specified the fully qualified file name. Two questions. First, what can I do to get the MySQL version 3.23.49 working on my system so I have the current version of the software? Second, what can be done so I do not need to specify the fully qualified file name? This still leaves the question as to when version 3.23.49a will be compiled for Mac OS X, instead of version 3.23.47. I always compile my own. Is there some reason you don't do that? There are many messages on this list that say use the binary from MySQL. It makes since to me to use official binaries so I do not end up with unique problems because of some option or compiler difference. I was just wondering why there is a version 3.23.49 that maybe runs on Mac OS X server but not one that runs on regular Mac OS X. I reported the missing library if I try to use the 3.23.49 version intended for server. -- 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 (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
Problems with Mac OS X
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 http://www.entropy.ch/software/macosx/mysql/ and found that a change was made in verion 3.23.49 as related to the use of local files. I added --local-infile=1 when I run mysql and the command was accepted. The problem I was then having is that if I issued the following command load data local infile 'mt2308.dat' into table mt2308 ; mt2308.dat was not found. I had to specify the fully qualified file name for the command to work. This is a change from the way it used to work as I recall. It was the case that at one time this command would find the file if the file was in the current working directory. I then went to www.mysql.com and looked at what binary distributions were there for Mac OS X. First I downloaded version 3.23.49 but when I tried to run that version /usr/lib/libpthread.A.dylib was not found. I could not find where I could get this library. I then picked up version 3.23.47 and although I did not need to use --local-infile=1 the file was not find unless I specified the fully qualified file name. Two questions. First, what can I do to get the MySQL version 3.23.49 working on my system so I have the current version of the software? Second, what can be done so I do not need to specify the fully qualified file name? I am a software developer and to facilitate 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 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 (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
Problem with where clause
I am running mysql Ver 11.15 Distrib 3.23.47, for pc-linux-gnu (i686) installed from a binary RPM file. This is using RedHat Linux 7.2. I have a table described as: mysql describe junk; ++---+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | ++---+--+-+-+---+ | record | decimal(3,0) | YES | | NULL| | | title | varchar(250) | YES | | NULL| | | num1 | float | YES | | NULL| | | num2 | decimal(6,0) | YES | | NULL| | | num3 | decimal(10,3) | YES | | NULL| | | code | char(3) | YES | | NULL| | | sdate | date | YES | | NULL| | | stime | time | YES | | NULL| | ++---+--+-+-+---+ 8 rows in set (0.00 sec) It has the following data: mysql select record,num1 from junk; ++--+ | record | num1 | ++--+ | 1 | 12.3 | | 2 | 17.785 | | 3 | 138.981 | | 4 | -34.12 | | 5 | -12.7365 | | 6 |-0.34 | ++--+ 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, -- 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 (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
Re: Problem with where clause
Am I to assume that based on your response that one should never use a float field type if you ever want to select the data? This causes a big problem for the way MyODBC 3.51 has been implemented. I was actually debugging a problem I had in MyODBC when I ran across this. The way MyODBC works is that is generates a native SQL statement. In my case the statement was: UPDATE `junk` SET `record`= 91 WHERE record=1 AND title='This is item one' AND num1=12.3 AND num2=134 AND num3=0.100 AND code='abc' AND sdate='1991-11-30' AND stime='17:45:00' LIMIT 1 Since the float compare did not work (field num1), the record I wanted changed did not get changed. The way our software works is that it fixes the variable number (num1) to the number of decimals in the constant number before the compare is done. There are ways for compares to be programmed so they 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. Use a decimal type instead. Jim Dickenson wrote: I am running mysql Ver 11.15 Distrib 3.23.47, for pc-linux-gnu (i686) installed from a binary RPM file. This is using RedHat Linux 7.2. I have a table described as: mysql describe junk; ++---+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | ++---+--+-+-+---+ | record | decimal(3,0) | YES | | NULL| | | title | varchar(250) | YES | | NULL| | | num1 | float | YES | | NULL| | | num2 | decimal(6,0) | YES | | NULL| | | num3 | decimal(10,3) | YES | | NULL| | | code | char(3) | YES | | NULL| | | sdate | date | YES | | NULL| | | stime | time | YES | | NULL| | ++---+--+-+-+---+ 8 rows in set (0.00 sec) It has the following data: mysql select record,num1 from junk; ++--+ | record | num1 | ++--+ | 1 | 12.3 | | 2 | 17.785 | | 3 | 138.981 | | 4 | -34.12 | | 5 | -12.7365 | | 6 |-0.34 | ++--+ 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, -- 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 (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
Problem with SQLSetPos(SQL_DELETE)
I have an application that works with EasySoft's OOB driver but not with MyODBC. I have compiled version 2.50.39 under RedHat 7.2 and I think there is a problem in the code. In cursor.c on line 217 there is a test to see if irow is being passed correctly. I think the test is wrong. I fetch one record at a time so irow can only be 1. As best as I can tell the test is checking against which row in the whole result set we are currently on. This is not the test that should be done as best as I can figure. Although I did select 6 records from my datasource I am only reading one at a time. If I want to delete the current record I want to delete the only record in my fetch set which is record 1, not the specific record in the result set, which in my case is record 6. Looking at the code for SQLSetPos it looks like irow is taken as a row in the result set 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, please check: http://www.mysql.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
Re: Auto-starting mySQL on a Macintosh
There is a link at http://www.entropy.ch/software/macosx/mysql/ for a startup items package. This will cause MySQL to start when you restart the Mac OS X system. On 1/19/2002 3:07 PM, Antonio Flores Aldama [EMAIL PROTECTED] wrote: Hello I need help to startup My SQL in my OS X Server 10.1 box.. Some idea of what can I do? Greetings Antonio - 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 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 - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: [PHP] Mac OSX !?!?!?
There is a link at http://www.entropy.ch/software/macosx/mysql/ for a startup items package. This will cause MySQL to start when you restart the Mac OS X system. On 1/17/2002 8:30 AM, Erik Price [EMAIL PROTECTED] wrote: There is a utility called daemonic which is designed to deal with this as well, but works for more than just MySQL -- it's intended to be used for all server daemons. http://daemonic.sourceforge.net/ It is Mac OS X-specific at this time, but according to the web site is designed for future compatibility with any operating system. It can be installed via Fink (http://fink.sourceforge.net) very easily, and is in fact required by many Fink packages. I must confess that I do not know much about it. Erik On Wednesday, January 16, 2002, at 08:01 PM, Richard Baskett wrote: Although the MySQL warnings, I got those because MySQL does not automatically start in OSX, if you know it's started then Im not sure, but if not.. go here to get the autostart utility: http://www.entropy.ch/software/macosx/mysql/ - 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 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 - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: NUMERIC field contents
On 9/18/01 11:25 AM, Dana Powers at [EMAIL PROTECTED] wrote: The problem is that a number that is in the MySQL database might be a magnitude of 10 times larger than a number that is in the PostgreSQL database. Could you explain this? dpk - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php I create a table in PostgreSQL as a single field with numeric(10,2). I create the same table in MySQL. I then run an ODBC application that calls SQLDescribeCol to find out what items are returned from select * from table. After getting a fix for MyODBC both data sources return a precision of 10 and a scale of 2. This is as I would expect. I then know to add room for the decimal point and the sign character. Even though I have room for a 12 digit number I expect the leftmost position to be used only for the sign. In PostgreSQL 7.1.3, using psql, if I try to put 123456789.12 into the table I get an error that the number is too big to fit. This is as expected. If I use mysql, Ver 11.15 Distrib 3.23.42 for pc-linux-gnu (i686), to put the same number into the table I do not get an error and the data is put into the database. This is not as expected. The reason I see this as a problem is that numeric(10,2) says that there are 10 digits in the number and two of them are decimal digits. The valid range is -99,999,999.99 through 99,999,999.99 but MySQL 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. -- 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 (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
Re: NUMERIC field contents
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 PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, September 18, 2001 1:35 PM Subject: Re: NUMERIC field contents On 9/18/01 11:25 AM, Dana Powers at [EMAIL PROTECTED] wrote: The problem is that a number that is in the MySQL database might be a magnitude of 10 times larger than a number that is in the PostgreSQL database. Could you explain this? dpk - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php I create a table in PostgreSQL as a single field with numeric(10,2). I create the same table in MySQL. I then run an ODBC application that calls SQLDescribeCol to find out what items are returned from select * from table. After getting a fix for MyODBC both data sources return a precision of 10 and a scale of 2. This is as I would expect. I then know to add room for the decimal point and the sign character. Even though I have room for a 12 digit number I expect the leftmost position to be used only for the sign. In PostgreSQL 7.1.3, using psql, if I try to put 123456789.12 into the table I get an error that the number is too big to fit. This is as expected. If I use mysql, Ver 11.15 Distrib 3.23.42 for pc-linux-gnu (i686), to put the same number into the table I do not get an error and the data is put into the database. This is not as expected. The reason I see this as a problem is that numeric(10,2) says that there are 10 digits in the number and two of them are decimal digits. The valid range is -99,999,999.99 through 99,999,999.99 but MySQL 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. -- Jim Dickenson mailto:[EMAIL PROTECTED] Computers for Marketing Corporation http://www.cfmc.com/ eFax: 1-419-791-8924 Maybe because I test the software I run to make sure that it is working the way I think it should. I am learning ODBC and have run into various problems interacting with different ODBC drivers. Additionally the person doing the entry may or may not know all the parameters defined in the table and I would hope that the database would not allow illegal data to be put into the database. -- 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 (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
NUMERIC field contents
Does anyone have an opinion about the following? Are people using decimal type fields? Is it important for the database to allow only allowed data? From http://www.mysql.com/doc/N/u/Numeric_types.html The NUMERIC and DECIMAL types are implemented as the same type by MySQL, as permitted by the SQL92 standard. They are used for values for which it is important to preserve exact precision, for example with monetary data. When declaring a column of one of these types the precision and scale can be (and usually is) specified; for example: salary DECIMAL(9,2) In this example, 9 (precision) represents the number of significant decimal digits that will be stored for values, and 2 (scale) represents the number of digits that will be stored following the decimal point. In this case, therefore, the range of values that can be stored in the salary column is from -999.99 to 999.99. (MySQL can actually store numbers up to 999.99 in this column because it doesn't have to store the sign for positive numbers) First I am not sure if you intended 999.99 to be .99 in (MySQL can actually store numbers up to 999.99 in this column because it doesn't have to store the sign for positive numbers) If so then I do not think this is correct. I think that decimal(9,2) means there is an optional sign character, up to 7 whole digits, a decimal point and up to two decimal digits. I think the whole parenthetical statement should be removed. Red Hat Linux 7.1 2.96-85 mysql-3.23.42 (Official MySQL RPM) Configure command: ./configure --disable-shared --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --without-berkeley-db --without-innodb --enable-assembler --with-mysqld-user=mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/ --with-extra-charsets=complex --exec-prefix=/usr --libexecdir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/mysql --infodir=/usr/info --includedir=/usr/include --mandir=/usr/man '--with-comment=Official MySQL RPM' This shows the problem: mysql -p dickensn Enter password: Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 18 to server version: 3.23.42 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql create table t1 (num1 numeric(9,2)); Query OK, 0 rows affected (0.00 sec) mysql insert into t1 values (1234567.12); Query OK, 1 row affected (0.00 sec) mysql select * from t1; ++ | num1 | ++ | 1234567.12 | ++ 1 row in set (0.00 sec) mysql update t1 set num1=12345678.12; Query OK, 1 row affected (0.00 sec) Rows matched: 1 Changed: 1 Warnings: 0 mysql select * from t1; +-+ | num1| +-+ | 12345678.12 | +-+ 1 row in set (0.00 sec) mysql update t1 set num1=-1234567.12; Query OK, 1 row affected (0.00 sec) Rows matched: 1 Changed: 1 Warnings: 0 mysql select * from t1; +-+ | num1| +-+ | -1234567.12 | +-+ 1 row in set (0.00 sec) mysql update t1 set num1=-12345678.12; Query OK, 1 row affected (0.00 sec) Rows matched: 1 Changed: 1 Warnings: 1 mysql select * from t1; +-+ | num1| +-+ | -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 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 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
NUMERIC field contents
From http://www.mysql.com/doc/N/u/Numeric_types.html The NUMERIC and DECIMAL types are implemented as the same type by MySQL, as permitted by the SQL92 standard. They are used for values for which it is important to preserve exact precision, for example with monetary data. When declaring a column of one of these types the precision and scale can be (and usually is) specified; for example: salary DECIMAL(9,2) In this example, 9 (precision) represents the number of significant decimal digits that will be stored for values, and 2 (scale) represents the number of digits that will be stored following the decimal point. In this case, therefore, the range of values that can be stored in the salary column is from -999.99 to 999.99. (MySQL can actually store numbers up to 999.99 in this column because it doesn't have to store the sign for positive numbers) First I am not sure if you intended 999.99 to be .99 in (MySQL can actually store numbers up to 999.99 in this column because it doesn't have to store the sign for positive numbers) If so then I do not think this is correct. I think that decimal(9,2) means there is an optional sign character, up to 7 whole digits, a decimal point and up to two decimal digits. I think the whole parenthetical statement should be removed. Red Hat Linux 7.1 2.96-85 mysql-3.23.42 (Official MySQL RPM) Configure command: ./configure --disable-shared --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --without-berkeley-db --without-innodb --enable-assembler --with-mysqld-user=mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/ --with-extra-charsets=complex --exec-prefix=/usr --libexecdir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/mysql --infodir=/usr/info --includedir=/usr/include --mandir=/usr/man '--with-comment=Official MySQL RPM' This shows the problem: mysql -p dickensn Enter password: Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 18 to server version: 3.23.42 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql create table t1 (num1 numeric(9,2)); Query OK, 0 rows affected (0.00 sec) mysql insert into t1 values (1234567.12); Query OK, 1 row affected (0.00 sec) mysql select * from t1; ++ | num1 | ++ | 1234567.12 | ++ 1 row in set (0.00 sec) mysql update t1 set num1=12345678.12; Query OK, 1 row affected (0.00 sec) Rows matched: 1 Changed: 1 Warnings: 0 mysql select * from t1; +-+ | num1| +-+ | 12345678.12 | +-+ 1 row in set (0.00 sec) mysql update t1 set num1=-1234567.12; Query OK, 1 row affected (0.00 sec) Rows matched: 1 Changed: 1 Warnings: 0 mysql select * from t1; +-+ | num1| +-+ | -1234567.12 | +-+ 1 row in set (0.00 sec) mysql update t1 set num1=-12345678.12; Query OK, 1 row affected (0.00 sec) Rows matched: 1 Changed: 1 Warnings: 1 mysql select * from t1; +-+ | num1| +-+ | -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 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 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
NUMERIC field contents
From http://www.mysql.com/doc/N/u/Numeric_types.html The NUMERIC and DECIMAL types are implemented as the same type by MySQL, as permitted by the SQL92 standard. They are used for values for which it is important to preserve exact precision, for example with monetary data. When declaring a column of one of these types the precision and scale can be (and usually is) specified; for example: salary DECIMAL(9,2) In this example, 9 (precision) represents the number of significant decimal digits that will be stored for values, and 2 (scale) represents the number of digits that will be stored following the decimal point. In this case, therefore, the range of values that can be stored in the salary column is from -999.99 to 999.99. (MySQL can actually store numbers up to 999.99 in this column because it doesn't have to store the sign for positive numbers) First I am not sure if you intended 999.99 to be .99 in (MySQL can actually store numbers up to 999.99 in this column because it doesn't have to store the sign for positive numbers) If so then I do not think this is correct. I think that decimal(9,2) means there is an optional sign character, up to 7 whole digits, a decimal point and up to two decimal digits. I think the whole parenthetical statement should be removed. Red Hat Linux 7.1 2.96-85 mysql-3.23.42 (Official MySQL RPM) Configure command: ./configure --disable-shared --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --without-berkeley-db --without-innodb --enable-assembler --with-mysqld-user=mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/ --with-extra-charsets=complex --exec-prefix=/usr --libexecdir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/mysql --infodir=/usr/info --includedir=/usr/include --mandir=/usr/man '--with-comment=Official MySQL RPM' This shows the problem: mysql -p dickensn Enter password: Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 18 to server version: 3.23.42 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql create table t1 (num1 numeric(9,2)); Query OK, 0 rows affected (0.00 sec) mysql insert into t1 values (1234567.12); Query OK, 1 row affected (0.00 sec) mysql select * from t1; ++ | num1 | ++ | 1234567.12 | ++ 1 row in set (0.00 sec) mysql update t1 set num1=12345678.12; Query OK, 1 row affected (0.00 sec) Rows matched: 1 Changed: 1 Warnings: 0 mysql select * from t1; +-+ | num1| +-+ | 12345678.12 | +-+ 1 row in set (0.00 sec) mysql update t1 set num1=-1234567.12; Query OK, 1 row affected (0.00 sec) Rows matched: 1 Changed: 1 Warnings: 0 mysql select * from t1; +-+ | num1| +-+ | -1234567.12 | +-+ 1 row in set (0.00 sec) mysql update t1 set num1=-12345678.12; Query OK, 1 row affected (0.00 sec) Rows matched: 1 Changed: 1 Warnings: 1 mysql select * from t1; +-+ | num1| +-+ | -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 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 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php