Re: Decimal - Maximum is 30

Postgres has PostGIS Oracle has OracleSpatial MySQL has ? OpenGis. PB Martin Gainty wrote: Michael- I can certainly understand the upgrade based on the performance advantages of MySQL What would NASA use for its mapping GIS/Mapping software? Postgres has PostGIS Oracle has OracleSpatial MySQ

Re: can't find ft-min_word_len in /etc/my.conf ?

Thanks. Though, I added, repair table, restarted mysql - and the same :( -ll --- Warren Young <[EMAIL PROTECTED]> wrote: > Lamp Lists wrote: > > I need to change ft_min_word_len fro 4 to 3. the > > proces is very well explained on mysql.com > > though, when open /etc/my.conf can't find the > >

Re: Decimal - Maximum is 30

Michael Cole wrote: I think you missed something in your formula, You just have a 1 dimension dealt with here. That would be every grain in that line. Yes...so you use three columns to describe normal space. Call them x, y, and z. Or elevation, azimuth and range. Or... -- MySQL General

Re: Decimal - Maximum is 30

Michael- I can certainly understand the upgrade based on the performance advantages of MySQL What would NASA use for its mapping GIS/Mapping software? Postgres has PostGIS Oracle has OracleSpatial MySQL has ? Many Thanks for the link Martin-- - Original Message - From: "Michael Cole" <[EM

Re: Decimal - Maximum is 30

On Friday 01 February 2008 7:32:33 am Warren Young wrote: > The average grain of sand is a bit smaller than a millimeter.  There are > a million millimeters per kilometer. > > 10^11 * 10^13 * 10^6 = 10^30 > > In other words, the current system is sufficient for establishing the > location of every

Disk Benchmark Tool

Dear List, I am after a tool which benchmarks a file system in the same way that a MySql InnoDB system is likely to access it. That is, small random reads and writes in a very large file. For instance, the tool 'bonnie++' is no good for this as is concentrates too much on sequential read and

Re: Decimal - Maximum is 30

Eli Shemer wrote: Actually I'm not in liberty to reveal but it is essential to the project. In that case, I am awe-struck, even astounded, at the possibilities suggested by this hint. You must be working on a project that is literally astronomical in scope. Please, let me explain how I came

Re: can't find ft-min_word_len in /etc/my.conf ?

Lamp Lists wrote: I need to change ft_min_word_len fro 4 to 3. the proces is very well explained on mysql.com though, when open /etc/my.conf can't find the ft_min_word_len line? If a value for a configurable isn't given in my.cnf, it takes the default value. So, add the line, restart the serv

can't find ft-min_word_len in /etc/my.conf ?

hi, I need to change ft_min_word_len fro 4 to 3. the proces is very well explained on mysql.com though, when open /etc/my.conf can't find the ft_min_word_len line? when check is there: mysql> show variables like 'ft_min_word_len' ft_min_word_len4 am I looking at the wrong file or something?

Re: Spontaneous corrupted tables on MyISAM with 5.0.x release

Hi Gerald, Michael, Gerald L. Clark wrote: Never put MySQl data files on an NFS exported share. Michael Dykman wrote: > This is a bit of a generalization, but file locks are known to be > pretty flakey and unreliable under NFS.. any kind of serious load > begs races conditions which file lock

Re: Decimal - Maximum is 30

On Jan 31, 2008 2:56 PM, Eli Shemer <[EMAIL PROTECTED]> wrote: > Actually I'm not in liberty to reveal but it is essential to the project. > I will look for a workaround in code space when I find the time. > This first thing which springs to my mind is: what langauge are you using that can make us

DISABLE TRIGGER alternative

Hi All, I want to disable a trigger on a table for the statements that run within a stored procedure. As DISABLE TRIGGER is not an option I was wondering if any body has any alternatives/ideas on how to achieve this Thanks Olaf - Confidentiality Notice: Th

Re: Statement for a date range

> I have a report that contains a WHERE statement to report on a date range in > Pentaho. > > WHERE > InOut.MOVEMENTDATE >= (CURRENT_DATE - 7) > > I want to show on the report what the first date of this range is. Can > someone help me with this statement? So if the last seven days is January >

RE: Decimal - Maximum is 30

Actually I'm not in liberty to reveal but it is essential to the project. I will look for a workaround in code space when I find the time. -Original Message- From: Warren Young [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 30, 2008 5:49 PM To: MySQL List Subject: Re: Decimal - Maximu

Re: GROUP question

On Jan 31, 2008 1:30 PM, Jerry Schwartz <[EMAIL PROTECTED]> wrote: > That's rather what I feared. I'm trying to avoid code, mostly because this > should be a one-off run. If it's a one-shot deal and you don't mind it taking a little time, I think something like this would work: SELECT customers.e

Statement for a date range

I have a report that contains a WHERE statement to report on a date range in Pentaho. WHERE InOut.MOVEMENTDATE >= (CURRENT_DATE - 7) I want to show on the report what the first date of this range is. Can someone help me with this statement? So if the last seven days is January 24, 2008 to Janu

RE: GROUP question

That's rather what I feared. I'm trying to avoid code, mostly because this should be a one-off run. I could strangle the designer who didn't make email a unique key (with appropriate coding in the input application). Thanks. Regards, Jerry Schwartz The Infoshop by Global Information Incorporated

Question regarding innodb tables

I have a question regarding the innodb_file_per_table configuration option. We currently do not have this enabled, so our ibdata1 file is huge. Is it recommended that we have this configured to store the tables in their own files? What are the performance implications of doing this, especial

Re: Looking for a more efficient way to achieve the same result -> Found solution but would still like some advice :)

Richard a écrit : Richard a écrit : Hello, I'm in the process of programming a customer area with a list of subscriptions : Reference | Title | Type | Date of first subscription | Expires Each item in this list will have a link to it's details with will show a list like this : Subscribed o

Re: GROUP question

On Jan 30, 2008 5:25 PM, Jerry Schwartz <[EMAIL PROTECTED]> wrote: > The problem starts when I try to fetch the memos. I want one email address, > two or more customer_ids (so I can tell them apart), and all of the memos > for each customer_id (preferably using GROUP_CONCAT(). In other words, this

Re: a multi-order question

Hi ! zhihuali wrote: Hi netters, Suppose I have a table X: NameSalary Tom1000 Jack 3000 Mike 1000 Mike 3500 Tom 4000 I want to do the following thing: First, order by Salary; Second, starting from the highest salary down, group by

Re: Looking for a more efficient way to achieve the same result

Richard a écrit : Hello, I'm in the process of programming a customer area with a list of subscriptions : Reference | Title | Type | Date of first subscription | Expires Each item in this list will have a link to it's details with will show a list like this : Subscribed on : date of first s

Re: Data folder copying problem

Hi Martin, You are correct. That's the same error that I got. Looks like this article is the solution => http://dev.mysql.com/doc/refman/5.1/en/innodb-backup.html Thanks ! Feris On 1/31/08, Martijn Tonies <[EMAIL PROTECTED]> wrote: > Hi, > > > > By default, InnoDB tables aren't stored in the d

Re: Data folder copying problem

Hi Rick, Thanks... I think I found the answer from your direction. This article seems the solution to my problem : http://dev.mysql.com/doc/refman/5.1/en/innodb-backup.html Thanks ! Feris On 1/31/08, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > moving an innodb table is trickier than moving

SQL_LOG_OFF / super priv question

Hi All, I would like for my regular database users to be able to turn logging off for certain sessions. This would work by allowing them to set SQL_LOG_OFF and SQL_LOG_BIN. This requires the user to have the SUPER privilege. Is there any reason why regular users should not have this privilege? Or,

Re: Data folder copying problem

Hi, > > By default, InnoDB tables aren't stored in the database folder, but rather > > in it's own table space files. > > > > In fact when I try to drop the database, the server "recognizes" > innodb tables. For example, T1 and T2 are INNODB tables in database > DB1. Then when I try to drop DB1, i

Re: Data folder copying problem

Hi Martin, On 1/31/08, Martijn Tonies <[EMAIL PROTECTED]> wrote: > Hi, > > By default, InnoDB tables aren't stored in the database folder, but rather > in it's own table space files. > In fact when I try to drop the database, the server "recognizes" innodb tables. For example, T1 and T2 are INNOD

Re: Data folder copying problem

Hi, > I have 2 database folder that being copied directly from a remote > server and sent to me. That databases contains both MYISAM and INNODB > tables. > > After I received the data, I try to restored it by copying that > folders to my server. The problem is, only MYISAM tables are being > recog

Data folder copying problem

Hi all, I have 2 database folder that being copied directly from a remote server and sent to me. That databases contains both MYISAM and INNODB tables. After I received the data, I try to restored it by copying that folders to my server. The problem is, only MYISAM tables are being recognized. Ho

mysql training/seminar in the philippines

hi to all, does anybody knows if there is any mysql training or seminar to be held in the philippines? thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Linq support

Hi, Did latest Mysql .net provider (5.1.4) support Linq? -- Sharique uddin Ahmed Farooqui (C++/C# Developer, IT Consultant) A revolution is about to begin. A world is about to change. And you and I are "the initiator".