Re: Query Pls

2007-04-17 Thread Renish koshy
> I guess it is nothing to do with the query as it was working perfectly > fine be4 installing the Navicat enterprise version 7.0.9 .thanks a lot > > On 4/17/07, Ananda Kumar <[EMAIL PROTECTED]> wrote: > > > > Hi Renish, > > What is the query that you ran,

Query Pls

2007-04-17 Thread Renish koshy
rks..Is it somethng related to memory? Thanks Renish Koshy

Re: Simple doubt

2006-11-27 Thread Renish
How abt to return the distinct rows? - Original Message - From: "Peter Brawley" <[EMAIL PROTECTED]> To: "Renish" <[EMAIL PROTECTED]>; Sent: Tuesday, November 28, 2006 11:48 AM Subject: Re: Simple doubt >But if I do like this.. >select dist

Re: Simple doubt

2006-11-27 Thread Renish
Smart. and simple .I should have thought for a while:-( - Original Message - From: "ViSolve DB Team" <[EMAIL PROTECTED]> To: "Renish" <[EMAIL PROTECTED]>; "Hal Wigoda" <[EMAIL PROTECTED]> Cc: Sent: Tuesday, November 28, 2006 11:58 AM Subj

Re: Simple doubt

2006-11-27 Thread Renish
Dupes - Original Message - From: "Peter Brawley" <[EMAIL PROTECTED]> To: "Renish" <[EMAIL PROTECTED]>; Sent: Tuesday, November 28, 2006 11:48 AM Subject: Re: Simple doubt >But if I do like this.. >select distinct store, price from Item >wi

Re: Simple doubt

2006-11-27 Thread Renish
Message - From: "Hal Wigoda" <[EMAIL PROTECTED]> To: "Renish" <[EMAIL PROTECTED]> Sent: Tuesday, November 28, 2006 11:11 AM Subject: Re: Simple doubt select unique On Nov 27, 2006, at 8:45 PM, Renish wrote: Gurus, How do I go about to selecting an item whic

Re: Simple doubt

2006-11-27 Thread Renish
But if I do like this.. select distinct store, price from Item will both become distinct? How can I make only one distinct ie "store" distinct regards, - Original Message - From: "Peter Brawley" <[EMAIL PROTECTED]> To: "Renish" <[EMAIL PROT

Simple doubt

2006-11-27 Thread Renish
Gurus, How do I go about to selecting an item which is repeated more than one in a field in a table. For example Item table Mango Orange Carrot Papaya Mango Mango -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAI

Re: MySql doubt.

2006-11-27 Thread Renish
Great Thanks,, - Original Message - From: "ViSolve DB Team" <[EMAIL PROTECTED]> To: "Renish" <[EMAIL PROTECTED]>; Sent: Monday, November 27, 2006 4:57 PM Subject: Re: MySql doubt. Hi Renish, In case if you dont have the Item field in the Table B.

Re: MySql doubt.

2006-11-26 Thread Renish
Thanks if in case if we dont have the Item field in the Table B. wat to do..I know the primary key to connect both the tables/ - Original Message - From: ViSolve DB Team To: Renish ; mysql@lists.mysql.com Sent: Monday, November 27, 2006 12:48 PM Subject: Re: MySql doubt

MySql doubt.

2006-11-26 Thread Renish
Pencil-2 dollar Please reply me asap. I hope it should be v. easy enough to tackle. Cheers, Renish koshy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

MySql doubt.

2006-11-26 Thread Renish
Pencil-2 dollar Please reply me asap. I hope it should be v. easy enough to tackle. Cheers, Renish koshy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Urgent please..

2006-11-15 Thread Renish
Thank you very much..excellent support - Original Message - From: "Logan, David (SST - Adelaide)" <[EMAIL PROTECTED]> To: "Renish" <[EMAIL PROTECTED]> Cc: ; "Joshua J. Kugler" <[EMAIL PROTECTED]> Sent: Thursday, November 16, 2006 1

Re: Urgent please..

2006-11-15 Thread Renish
Ocourse i read the manual . I was unable to do so..ie the reason I asked...I also knew this location mysql@lists.mysql.com - Original Message - From: "Joshua J. Kugler" <[EMAIL PROTECTED]> To: Cc: "Renish" <[EMAIL PROTECTED]> Sent: Thursday, Novemb

Urgent please..

2006-11-15 Thread Renish
All, Can anyone tell me..how to install PHP php-5.2.0-Win32 . i click on php.exe and nothing seems to happen. I have intalled 1) webserver-Apache2 2) MySql-41.1 I want to use PHP as sever side scripting. Cheers, Renish. -- MySQL General Mailing List For list archives: http

Re: administrtor-user

2006-10-22 Thread Renish
in windows.. Pls explain me as though I am a beginner. - Original Message - From: "Visolve DB Team" <[EMAIL PROTECTED]> To: "Renish" <[EMAIL PROTECTED]>; Sent: Monday, October 23, 2006 12:49 PM Subject: Re: administrtor-user Hi, On which platfo

Re: administrtor-user

2006-10-22 Thread Renish
I am using sql 4.1.21. useradd mysql itself is not working Regards - Original Message - From: Visolve DB Team To: Renish ; mysql@lists.mysql.com Sent: Monday, October 23, 2006 12:17 PM Subject: Re: administrtor-user Hi First, shell> useradd mysql Chang

administrtor-user

2006-10-22 Thread Renish
Can u guys tell me.. How can I be the administrator for the mysql and thenI I need to create users x, y,z and assign them a password. and give them privilages.. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTE

Re: Oracle query..

2006-10-20 Thread Renish
Thanks dear. i thought u could be of some use in Oracle aswelll - Original Message - From: "Daniel Kasak" <[EMAIL PROTECTED]> To: "Renish" <[EMAIL PROTECTED]>; Sent: Friday, October 20, 2006 1:59 PM Subject: Re: Oracle query.. Renish wrote: Hello,

Re: Oracle query..

2006-10-19 Thread Renish
Thank u for ur speedy reply. - Original Message - From: "Chris" <[EMAIL PROTECTED]> To: "Renish" <[EMAIL PROTECTED]> Cc: "Daniel Kasak" <[EMAIL PROTECTED]>; Sent: Friday, October 20, 2006 1:51 PM Subject: Re: Oracle query.. Renish wr

Re: Oracle query..

2006-10-19 Thread Renish
Hello, Sorry. Again u r wrong.. Thers no connection with MYSQL here. Lets imagine I only have Oracle 7.3 data and then import the same data into Oracle 10g I hope this helps Renisn - Original Message - From: "Daniel Kasak" <[EMAIL PROTECTED]> To: "Reni

Re: Oracle query..

2006-10-19 Thread Renish
matter. Cheers, Renish Koshy - Original Message - From: "Daniel Kasak" <[EMAIL PROTECTED]> To: "Renish" <[EMAIL PROTECTED]>; Sent: Friday, October 20, 2006 11:50 AM Subject: Re: Oracle query.. Renish wrote: Hi All, I have oracle 7.3 data available

Oracle query..

2006-10-19 Thread Renish
see all the tables. For eample..when I have an SQl file(*.sdl) I used to import it in dos mode like Mysql4.1> bin>mysql ..< .sql -p -u root; Thank you very much. Regards, Renish -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To un

Fw: Import oracle

2006-10-18 Thread Renish
- Original Message - From: "Renish" <[EMAIL PROTECTED]> To: Sent: Thursday, October 19, 2006 1:08 PM Subject: Fw: Import oracle - Original Message - From: "Renish" <[EMAIL PROTECTED]> To: Sent: Thursday, October 19, 2006 10:28 AM Subject:

Fw: Import oracle

2006-10-18 Thread Renish
- Original Message - From: "Renish" <[EMAIL PROTECTED]> To: Sent: Thursday, October 19, 2006 10:28 AM Subject: Import oracle Can anyone tell me how can I import the *.gra (oracle db file) files to Navicat or Acess. Pls let me know in steps as I am v new to this fie

Import oracle

2006-10-18 Thread Renish
Can anyone tell me how can I import the *.gra (oracle db file) files to Navicat or Acess. Pls let me know in steps as I am v new to this field. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Query Help plss

2006-10-11 Thread Renish
Thank u so much. It woked now! - Original Message - From: "Visolve DB Team" <[EMAIL PROTECTED]> To: "Visolve DB Team" <[EMAIL PROTECTED]>; "Renish" <[EMAIL PROTECTED]>; Sent: Tuesday, October 10, 2006 1:42 PM Subject: Re: Query

Urgent plsss

2006-10-11 Thread Renish
Can anyone tell me how can I import the *.gra (oracle db file) files to Navicat or Acess. Pls let me know in steps as I am v new to this field. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Fw: Query Help plss

2006-10-09 Thread Renish
- Original Message - From: Renish To: Visolve DB Team ; mysql@lists.mysql.com Sent: Tuesday, October 10, 2006 12:35 PM Subject: Fw: Query Help plss - Original Message - From: Renish To: mysql@lists.mysql.com ; Visolve DB Team Sent: Tuesday, October 10, 2006 12:34 PM

Re: Query Help plss

2006-10-09 Thread Renish
Xp - Original Message - From: "Visolve DB Team" <[EMAIL PROTECTED]> To: "Renish koshy" <[EMAIL PROTECTED]> Sent: Tuesday, October 10, 2006 11:42 AM Subject: Re: Query Help plss Hi, On which platform? Thanks ViSolve DB Team. - Original Message ---

Query Help plss

2006-10-09 Thread Renish koshy
Hi all, I have installed MySql 4.1 in my system. when I tried to run Mysql , I always gets this error. Could not start MySql service on a local computer Error 1067: the process terminated unexpectedly. Any help is highly appreciated. Regards, Renish

Query...Urgent

2006-10-09 Thread Renish
Hi all, I have installed MySql 4.1 in my system. when I tried to run Mysql , I always gets this error. Could not start MySql service on a local computer Error 1067: the process terminated unexpectedly. Any help is highly appreciated. Regards, Renish -- MySQL General Mailing List For

Fw: simple database query

2006-10-09 Thread Renish
- Original Message - From: "Renish" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Monday, October 09, 2006 4:56 PM Subject: Fw: simple database query - Original Message - From: "Renish" <[EMAIL PROTECTED]

Fw: simple database query

2006-10-09 Thread Renish
- Original Message - From: "Renish" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, October 09, 2006 5:02 PM Subject: Fw: simple database query - Original Message - From: "Renish" <[EMAIL PROTECTED]> To: <[EMAIL PROTECT

Query. Urgent!

2006-10-09 Thread Renish
Hi all, I have installed MySql 4.1 in my system. when I tried to run Mysql , I always gets this error. Could not start MySql service on a local computer Error 1067: the process terminated unexpectedly. Any help is highly appreciated. Regards, Renish -- MySQL General Mailing List For

Re: Self References & Indexes

2006-10-09 Thread Renish
Hi all, I have installed MySql 4.1 in my system. when I tried to run Mysql , I always gets this error. Could not start MySql service on a local computer Error 1067: the process terminated unexpectedly. Any help is highly appreciated. Regards, Renish - Original Message - From

Re: multiple primary keys on one table?

2006-10-06 Thread Renish
right... - Original Message - From: "Gabriel PREDA" <[EMAIL PROTECTED]> To: "Ferindo Middleton" <[EMAIL PROTECTED]> Cc: "Dan Buettner" <[EMAIL PROTECTED]>; Sent: Friday, October 06, 2006 6:31 PM Subject: Re: multiple primary keys on one table? You will have to UPDATE to NULL those fi