What is ROWNUM of oracle in mysql

Hi, What is the alternative in mysql for ROWNUM of Oracle? Thanks, Rama Raju - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request

HEAP TABLES SUDDENLY DISAPPEARS****VERY URGENT**

Hi, Application uses Jboss server with mysql backend. IMDB tables (Heap tables) are created by the app. Things work on fine. Suddenly we miss Heap tables. We are not able to reproduce this at any particular event. It happens randomly. We could not make out the reason for this. We set max_heap_ta

Unexpected end of input stream-mm.mysql driver related problem*****URGENT*****

Hi, I am geeting an error Unexpected Exception: java.io.IOException message given: Unexpected end of input stream Is there any limitation on the length of the query string (In mm.mysql driver?)? Can any one help me out to avoid this error. LOG: SELECT PURCHASE_ORDERS.ORDER_ID,PURCHASE

RE: Unexpected end of input stream-mm.mysql driver related problem*****URGENT*****

Hi, I am geeting an error Unexpected Exception: java.io.IOException message given: Unexpected end of input stream Is there any limitation on the length of the query string (In mm.mysql driver?)? Can any one help me out to avoid this error. LOG: SELECT PURCHASE_ORDERS.ORDER_ID,PURCHAS

RE: Join Query Help

Hi, The better way of storage is to normalize it. Hope this way it will help you out. SQL> DESC EVENTS Name Null?Type - EVENTIDNUM

RE: LOCK TABLES issue

You are using InnoDB or MyISAM??? If u r going for InnoDB, Refer to InnoDB Engine manual for the version 3.23.47 at www.innodb.com. Here you details of different LOCK types. You can select the appropriate lock type at row level for different possibilities. Hope this works!! Cheers :) Rama Raju

RE: How to run commands written in a file

In the script file add the first statement as 'use db_name;' Mysql/bin>mysql < file_name.sql Thanks, Rama Raju -Original Message- From: D Bamud [mailto:[EMAIL PROTECTED]] Sent: Monday, January 07, 2002 4:01 PM To: [EMAIL PROTECTED] Subject: How to run commands written in a file I have

RE: Need very very Urgent help

Follow this procedure: 1. install mysql 3.23.47-win 2. go to c:\mysql\bin at dos prompt 3. run mysqld -install 4. go to services, and start mysql service 5. then at c:\mysql\bin>mysql This works! -Original Message- From: PARDHASARADHI VENKATA NARAPARAJU [mailto:[EMAIL PROTECTED]] Sent: