Convertion ORACLE query to MYSQL

2006-11-09 Thread ViSolve DB Team
Hi Experts, We are in the process of converting Oracle administration commands into MySQL for some purposes. We dont know how to convert the following Oracle commands to MySQL. How to do that..? 1. ALTER USER spec TEMPORARY TABLESPACE temp_ts; 2. DROP USER jbossjms1 CASCADE; 3. DROP

Re: Convertion ORACLE query to MYSQL

2006-11-09 Thread Anders Karlsson
These commands are Oracle specific or contains Oracle specific extensions. Nothing wrong with that, but in some cases there just is no corresponding command in MySQL, as the concepts are different. ViSolve DB Team wrote: Hi Experts, We are in the process of converting Oracle administration

Re: Convertion ORACLE query to MYSQL

2006-11-09 Thread Grant Allen
On 11/9/06, ViSolve DB Team [EMAIL PROTECTED] wrote: Hi Experts, We are in the process of converting Oracle administration commands into MySQL for some purposes. We dont know how to convert the following Oracle commands to MySQL. How to do that..? 1. ALTER USER spec TEMPORARY TABLESPACE

Oracle query to mysql

2004-09-28 Thread martin fasani
Hi guys, I'm working in a telecom company that has Oracle for the call statistics. Now we export the daily stats to a remote mySql. The daily resume table looks like this: ++---+-++--+ --+++ | IMRFLL |

Re: Oracle query to mysql

2004-09-28 Thread SGreen
Your original Oracle(R) query (slightly reformatted): SELECT IMRTAB.IMR906 AS NUM906 , IMRTAB.IMRFLL AS FLL , SUM(IMRTAB.IMRCLL) AS CLL , ROUND(SUM(IMRTAB.IMRDSC),2) AS DUR , ROUND(SUM(IMRTAB.IMRDSC)/SUM(IMRTAB.IMRCLL),2) AS PRO , SUM(IMRTAB1.IMRCLL) AS