Given that even spacing is important, it's a safe bet that it takes comments
into consideration, too.
Easily tested, though: grab one of the heaviest queries you have from your
slowlog, and execute with identical and different comments.
On Thu, Nov 18, 2010 at 8:31 AM, Daevid Vincent wrote:
>
Like most developers, I have a wrapper that all of my SQL queries go
through in PHP.
We have a dedicated "NOC" screen that shows the "mytop" status of each
DEV/TEST/PROD master/slave pair.
http://daevid.com/content/examples/snippets.php (Automatic Monitoring of
remote servers)
We sometimes see s
You can try using Oracle SQL Developer Tool which got the data import
function from MySql.
On 11/17/2010 4:14 AM, Sydney Puente wrote:
Hello,
How can I export a mysql 5.0.45 db to Oracle? mysql is going to stau but I need
to pass the data to oracle, just so the data can be transfered.
I have c
Some discussion of causes for this is at:
http://dev.mysql.com/doc/refman/5.0/en/join.html
Look for the part beginning:
"Join Processing Changes in MySQL 5.0.12"
On Nov 16, 2010, at 10:09 AM, Tompkins Neil wrote:
> Hi
>
> I've the following query :
>
> SELECT players_bids.players_bids_id, pla
Hello,
It should be possible to connect Oracle to the MySQL (or other) database
using a DBlink (using a MySQL ODBC driver)
the tables could then be copied using PLSQL.
Maybe you could link directly to Oracle and copy the code using MySQL
procedures or scripts (I have more experienc of Oracle w
On Wed, Nov 17, 2010 at 2:26 PM, who.cat wrote:
> Maybe you can dump as a csv format,then create table all tables in oracle
> .After that you can write a script program format the csv to oracle which
> can be recognized.
>
MySQL's select into outfile may well be good enough to manage to output
o
On Wed, Nov 17, 2010 at 1:43 AM, Shawn Green (MySQL) <
shawn.l.gr...@oracle.com> wrote:
> On 11/16/2010 15:14, Sydney Puente wrote:
>
>> Hello,
>>
>> How can I export a mysql 5.0.45 db to Oracle? mysql is going to stau but I
>> need
>> to pass the data to oracle, just so the data can be transfered