RE: InnoDB
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| | have_symlink | YES | | have_openssl | NO| | have_query_cache | YES | ++---+ 8 rows in set (0.03 sec) You might find the following helpful http://www.codeant.com/tutorials/mysql/MySQLTutorial.html Matt -Original Message- From: Chen, Jenny [mailto:[EMAIL PROTECTED] Sent: Thursday, April 15, 2004 10:23 AM To: '[EMAIL PROTECTED]' Subject: InnoDB MySQL Experts: I am new for MySQL database. We have a 4.0.18 MySQL sit on Linux box. I am reading on InnoDB. And having a question. How do I know the table is configured by InnoDB instead of normal table ? Should I at least see some entry in the /etc/my.cnf to indicate that InnoDB is configured? Thanks in advance. Jenny -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.656 / Virus Database: 421 - Release Date: 4/9/2004 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.656 / Virus Database: 421 - Release Date: 4/9/2004 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Advice
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 shell (in Linux) 2. type mysql and press enter. Regards, Matt -Original Message- From: Alexander Pfingstl [mailto:[EMAIL PROTECTED] Sent: Saturday, February 07, 2004 4:29 AM To: [EMAIL PROTECTED] Subject: Advice Hi, I am a blind user and for me it would be very helpful if I could use this GUI. At the moment I have got the problem, that you have to click on every item. There are no short cuts and it is not posible to navigate using the tab-key or context-menue. Or the arror-keys. Perhapts you can include this in future versions. It would make it much easier for blind people to use this GUI under windows. If you need more help or info about special problems of blind people or the screenreaders, than feal free to contact me. Best regards, Alexander -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.576 / Virus Database: 365 - Release Date: 1/30/2004 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.576 / Virus Database: 365 - Release Date: 1/30/2004 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySQL and Coldfusion
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 Coldfusion MX with MySql? It's just I've hit a problem I've been hitting my head against for a week or so. The coldfusion people I know have hit a blank (but they are using SQL Server). I'm stretching now in an attempt to find someone with experience of both sides? Thanks in advance. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.576 / Virus Database: 365 - Release Date: 1/30/2004 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.576 / Virus Database: 365 - Release Date: 1/30/2004 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Odd Rounding?
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 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(5,2) Regards, Matt -- That's how floating-point numbers work generally, not just in MySQL. Why are you so concerned about it? Presumably your 0.012345 isn't an exact number but a measurement of some sort, so it could just as well be 0.0123449 or 0.0123451, and 0.01234 is perfectly fine as a rounded value. If you do have exact numbers with six decimal places, you're probably better off storing them as some sort of integer and adding the decimal point when necessary for display. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.562 / Virus Database: 354 - Release Date: 1/16/2004 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Convert MS Access to MySql
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: Sunday, December 21, 2003 11:00 AM To: [EMAIL PROTECTED] Subject: Convert MS Access to MySql I need to convert an MS Access database to MySql. I would like to know the best way to do this. I was going to write an asp or php script that would read the MS Access db row by row and insert into the MySql db row by row. Is that the only way to move the data from the one db to the other? Many thanks Arthur --- Incoming 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 --- 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 archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Binaries for PocketPC
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 archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Spatial Extension in MySQL 4.1.1-alpha
Hi Steve and Paul, Thanks - the comma did get me! Paul, no the mistake isn't in the manual - I managed it all on my own. For anyone following, the correct sequence was: mysql CREATE TABLE geom ( g GEOMETRY ); Query OK, 0 rows affected (0.05 sec) mysql INSERT INTO geom VALUES ( GeomFromText('POINT(1 1)') ); Query OK, 1 row affected (0.00 sec) mysql SELECT AsText(g) FROM geom; ++ | AsText(g) | ++ | POINT(1 1) | ++ 1 row in set (0.00 sec) mysql Thanks again, Matt -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: 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 this way: mysql select AsText(g) from geom; +---+ | AsText(g) | +---+ | Point(1 1)| +---+ 1 row in set (0.00 sec) The formatting of the POINT coordinates are different. I think you should be inserting POINT (1 1) not POINT(1,1). It is the comma. -steve- That's exactly right. Was there an example like this in the manual that incorrectly included the comma? -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] --- Incoming 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 --- 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 archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Spatial Extension in MySQL 4.1.1-alpha
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 OK, 0 rows affected (0.06 sec) mysql insert into geom values(GeomFromText('POINT(1,1)')); Query OK, 1 row affected (0.00 sec) mysql select * from geom; +--+ | g| +--+ | NULL | +--+ 1 row in set (0.00 sec) mysql select AsText(g) from geom; +---+ | AsText(g) | +---+ | NULL | +---+ 1 row in set (0.00 sec) mysql - Notice that the select statement at the end gives me NULL for the value of g. I was expecting the following: mysql select AsText(g) from geom; +---+ | AsText(g) | +---+ | Point(1 1)| +---+ 1 row in set (0.00 sec) Does anyone know what I am missing? 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 archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]