Re: Migration from Oracle to MySQL

2007-07-29 Thread Mark Kirkwood
Grant Allen wrote: Storage engines are unique to MySQL? yes. Is that good? YMMV. Most of the purported benefits can be achieved with Oracle's features without the compromises of balkanised storage engines. You're right, they're not offered by Oracle, or anyone else ... there's a reason no

question about data partitioning in application level.

2007-07-29 Thread Hiroyuki Yamada
I have a question about data partitioning. I'm currently runnning a database server having too many writes, so trying to partition data in application level. What I'm trying to do is partitioning data by user, for example, doing like the following. user_id 1-10 => to server1 user_id 11-2

Log Files

2007-07-29 Thread krishna chandra prajapati
Hi All, Please tell my how to activate the general log, mysql log and slow query log. Regards, Krishna

Re: Returning All Rows That Repeat

2007-07-29 Thread Gary Josack
John Kopanas wrote: Does it makes sense that on a table of 100,000 rows that my DB is crapping out with the following query? SELECT * FROM jobs GROUP BY customer_number, job_number HAVING count(*) > 1 ORDER BY customer_number; :-) On 7/29/07, John Trammell <[EMAIL PROTECTED]> wrote: From:

Re: Returning All Rows That Repeat

2007-07-29 Thread John Kopanas
Does it makes sense that on a table of 100,000 rows that my DB is crapping out with the following query? SELECT * FROM jobs GROUP BY customer_number, job_number HAVING count(*) > 1 ORDER BY customer_number; :-) On 7/29/07, John Trammell <[EMAIL PROTECTED]> wrote: > >> From: John Kopanas [EMAIL P

RE: Returning All Rows That Repeat

2007-07-29 Thread John Trammell
>> From: John Kopanas [EMAIL PROTECTED] >> Subject: Returning All Rows That Repeat >> >> I want to be able to return all rows that have one or more other rows >> with the same customer_number and job_number. >> >> So for instance. If their are two jobs in my jobs table with a >> customer_number =

Re: Returning All Rows That Repeat

2007-07-29 Thread Gary Josack
John Kopanas wrote: I want to be able to return all rows that have one or more other rows with the same customer_number and job_number. So for instance. If their are two jobs in my jobs table with a customer_number = '0123' and job_number ='12' then I want both of those jobs to return one right

Returning All Rows That Repeat

2007-07-29 Thread John Kopanas
I want to be able to return all rows that have one or more other rows with the same customer_number and job_number. So for instance. If their are two jobs in my jobs table with a customer_number = '0123' and job_number ='12' then I want both of those jobs to return one right after another so I ca

Re: To see Asian Characters in mysql

2007-07-29 Thread Michael Monaghan
I can't speak to your GUI tool, but here's some general pointers: 1. You have to be absolutely sure that your system can in fact render Myanmar. - so ensure that at least your browser can view proper Myanmar characters - see http://www.columbia.edu/kermit/utf8.html. This page has a sample Burmese

To see Asian Characters in mysql

2007-07-29 Thread zar purple
Hello! I use MySQL server 5.0 and GUI tool for it. Although i changed utf 8 charset and utf8_unicode_ci collation and also changed Application fonts ( Tools, Options, General Options) to our language, Myanmar, in MySQL query browser, i can\'t type our fonts. Alternatively, i input our fonts to a