LATEST N RECORDS from a table without date field

2005-08-24 Thread Praveen KS
Can anyone help with a query to retrieve latest N records. No auto_increment field. No date field. Primary key exists and is populated with random unique values. Eg: slno int(10) primary key (populated with random unique values) name char(20) Thanks in advance. PraveenKumarKS http://www.geoci

MyISAM vs InnoDB ----- Incorrect key file for table error

2005-07-08 Thread Praveen KS
4.18-14smp ([EMAIL PROTECTED]) (gcc version 3.2 20020903 (Red Hat Linux 8.0 3.2-7)) Regards, Praveen. http://travel.indiainfo.com/img/banner-coolwaters.gif"; width="600" height="40" alt="" border="0" usemap="#banner">

Problem with Connecting remote MySQL (RH8.0)

2003-03-28 Thread praveen
to MySQL server during query in /var/www/html/helpdesk/common/mysql.class.php on line 41 2013 : Lost connection to MySQL server during query System details: OS: RedHat 8.0 PHP version: 4.2.2 MySQL Version: 3.23.52 Please help me out. Thanks & Regards Praveen -- MySQL General Mailing Lis

Problem while accessing remote database

2003-03-28 Thread praveen
to MySQL server during query in /var/www/html/helpdesk/common/mysql.class.php on line 41 2013 : Lost connection to MySQL server during query System details: OS: RedHat 8.0 PHP version: 4.2.2 MySQL Version: 3.23.52 Please help me out. Thanks & Regards Praveen -- MySQL General Mailing Lis

Re: Problem with moving database using mysqldump

2002-10-03 Thread Praveen kumar
have done this procedure many times for the same versions, but never tried with different versions. regards, Praveen --- Mike Hillyer <[EMAIL PROTECTED]> wrote: > Hello All; > > I am having a problem using the mysqldump > application. I have an old server > that I am trying t

Re: RPM Install appears to have failed

2002-10-03 Thread Praveen kumar
Hi, Where is the Mysql-server version. you have installed only client and mysql-max, but no mysql-server. Use rpm -Uvh for your installations, so that you can easily know the progress of installation. regards, Praveen --- Chris Becker <[EMAIL PROTECTED]> wrote: > > RedHa

Regarding disk accesses and main memory ussage

2002-02-12 Thread Praveen Sirupa - Roll No.98029
Dear Members, How can I know the no. disk acesses and the main memory used to execute a particular query in mysql ? Plz mail me asap. in anticipation Praveen Sirupa - Before posting, please check: http://www.mysql.com

Regarding Disk Accesses & Main Memory ussage.

2002-02-12 Thread Praveen Sirupa - Roll No.98029
Dear members, 1) How can we know the no. of disk accesses & main memory used to execute a particular query in mysql ? 2) Is any one familier with mysql source code for windows. Plz help me in this as I desparately need this information at the earliest. Plz reply asap. Thanx in advance.. Pra

Regarding Disk Accesses & Main Memory ussage.

2002-02-06 Thread Praveen Sirupa - Roll No.98029
Dear members, 1) How can we know the no. of disk accesses & main memory used to execute a particular query in mysql ? 2) Is any one familier with mysql source code for windows. Plz help me in this as I desparately need this information at the earliest. Plz reply asap. Thanx in advance.. Pra

Regarding Disk Accesses & Main memory ussage in mysql

2002-02-05 Thread Praveen Sirupa - Roll No.98029
Dear Members, How can I get the no. of disk accesses & main memory used to execute a particular query in mysql ? Plz reply asap. Thanx in advance. Praveen Sirupa - Before posting, please check: http://www.mysql

Regarding disk accesses and main memory ussage

2002-02-05 Thread Praveen Sirupa - Roll No.98029
Dear Members, How can I know the no. disk acesses and the main memory used to execute a particular query in mysql ? Plz mail me asap. in anticipation Praveen Sirupa - Before posting, please check: http://www.mysql.com

error in selecting database.

2001-07-03 Thread Praveen
follows: $ ./db Connected to database! Unknown database 'test' $ What is happening? Is it because the client machine does not have mysql installed? I compiled the program and ftp ed the binary to the other machine. What should I do now? Please help me. Thanks, Praveen.

turn of column headings

2001-03-05 Thread Praveen Kallakuri
hello there, i am a novice, so bear with this rather trivial question. how do i turn off the column-headers for select statements in mysql?? couldn't find any help with the online manual. waiting..... pr