RE: InnoDB

2004-04-15 Thread Matt Lynch
Hi Jenny, mysql SHOW VARIABLES LIKE '%have%'; ++---+ | Variable_name | Value | ++---+ | have_bdb | YES | | have_crypt | NO| | have_innodb| YES | | have_isam | YES | | have_raid | NO| |

RE: Advice

2004-02-09 Thread Matt Lynch
Hi Alexander, Perhaps the console application would be better suited for you. That way the response is always ASCII text, and you only need to type the commands. In case you haven't tried the console before ... To start the console application: 1. Open a DOS prompt (in windows) or a command

RE: MySQL and Coldfusion

2004-02-09 Thread Matt Lynch
Hi Ian, What is the problem you are hitting? I have been successfully using MX with MySQL. Matt -Original Message- From: Ian O'Rourke [mailto:[EMAIL PROTECTED] Sent: Sunday, February 08, 2004 10:52 AM To: [EMAIL PROTECTED] Subject: MySQL and Coldfusion Is anyone on the list using

RE: Odd Rounding?

2004-01-23 Thread Matt Lynch
Hi Andrew Consider using NUMERIC or DECIMAL to maintain precision. From the manual: The NUMERIC and DECIMAL types are implemented as the same type by MySQL, as permitted by the SQL-92 standard. They are used for values for which it is important to preserve exact precision, for example with

RE: Convert MS Access to MySql

2003-12-22 Thread Matt Lynch
Hi Arthur, Dbtools is a free product and it will do the conversion for you. http://www.dbtools.com.br/EN/index.php We have had success converting from MSAccess to MySQL in the past with it. Regards, Matt -Original Message- From: Arthur Klimowicz [mailto:[EMAIL PROTECTED] Sent:

Binaries for PocketPC

2003-12-18 Thread Matt Lynch
Hi, Does anyone know of a MySQL distribution for the PocketPC? Thanks, Matt --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.543 / Virus Database: 337 - Release Date: 11/21/2003 -- MySQL General Mailing List For list

RE: Spatial Extension in MySQL 4.1.1-alpha

2003-12-17 Thread Matt Lynch
: Tuesday, December 16, 2003 5:48 PM To: Steven Roussey; [EMAIL PROTECTED] Cc: 'Matt Lynch' Subject: Re: Spatial Extension in MySQL 4.1.1-alpha At 16:03 -0800 12/16/03, Steven Roussey wrote: You did an insert this way: mysql insert into geom values(GeomFromText('POINT(1,1)')); and expected results

Spatial Extension in MySQL 4.1.1-alpha

2003-12-16 Thread Matt Lynch
Hi, I am trying out the new GIS capabilities in MySQL 4.1.1-alpha (windows) and I am trying to follow some of the examples from chapter 10 in the manual. Here is a snap shot of my run mysql create table geom(g geometry); Query