Re: startup in OS-X

2006-10-06 Thread Rahul S. Johari
. but when I try to invoke it from >> Term I get a 'cmd not found' message. >> >> trying to figure out what I'm doing wrong: >> chris. >> Rahul S. Johari Supervisor, Internet & Administration Informed Marketing Services Inc. 500 Federal Street, Suite

Re: Country codes

2005-11-22 Thread Rahul S. Johari
Ave, You can use the attached SQL file to create a table with all Country names, ISO codes, and easily write up a code to fill in the values from the table. If you have any problems filing up the combo box with the values from the table, let me know. Dominor, Rahul S. Johari Coordinator

Re: Deleting Duplicate Records

2005-11-08 Thread Rahul S. Johari
That worked Perfect!!! Thanks a ton! On 11/8/05 11:27 AM, "Shen139" <[EMAIL PROTECTED]> wrote: > ALTER IGNORE TABLE mytbl ADD UNIQUE KEY ( Name, email, sex, country ) ; Rahul S. Johari Coordinator, Internet & Administration Informed Marketing Services Inc. 251 River Str

Re: Deleting Duplicate Records

2005-11-08 Thread Rahul S. Johari
0 AM, "Shen139" <[EMAIL PROTECTED]> wrote: > ALTER IGNORE TABLE mytbl ADD UNIQUE KEY ( field1, field2,... ) ; > > On 11/8/05, Rahul S. Johari <[EMAIL PROTECTED] > <mailto:[EMAIL PROTECTED]> > wrote: >> >> Hi, >> >> I used the following S

Deleting Duplicate Records

2005-11-08 Thread Rahul S. Johari
Hi, I used the following SQL Query to determine Duplicate Records with same Name & Email in the row: SELECT email, COUNT(email) AS NumOccur1, name, COUNT(name) AS NumOccur2 FROM mytbl GROUP BY name, email HAVING ( COUNT(email) > 1 ) AND ( COUNT(name) > 1 ) I want to delete all the records whi

Migrating from IBM Universe to mySQL

2005-06-14 Thread Rahul Bollampally
Hi, Has any body migrated an IBM's Universe database to mySQL if so could you guys please help me out, I need to migrate a huge dataset in Universe to mySQL to generate an analysis report. Rahul :-\ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mys

Re: Hashmysql.org 0wn3d?

2005-05-20 Thread Rahul S. Johari
Ave, I was wondering the same. Looks like hacked to me. Something's up. Rahul S. Johari Coordinator, Internet & Administration Informed Marketing Services Inc. 251 River Street Troy, NY 12180 Tel: (518) 266-0909 x154 Fax: (518) 266-0909 Email: [EMAIL PROTECTED] http://www.informed-so

Re: OS X and MySQL table corruption...

2005-04-04 Thread Rahul S. Johari
onder why. Rahul S. Johari Coordinator, Internet & Administration Informed Marketing Services Inc. 251 River Street Troy, NY 12180 Tel: (518) 266-0909 x154 Fax: (518) 266-0909 Email: [EMAIL PROTECTED] http://www.informed-sources.com On 4/4/05 12:59 PM, "Brent Baisley" <[E

Create table

2004-11-15 Thread rahul pathak
Hi, I am using the "Create table select * into ..." query to create a table using two exsisting tables But the table is created with only 1000 rows, which should not be the case.Is there a config setting which defaults the rowcount to 1000? I am using the MySQL control center. thanks, r --

time complexity

2004-09-06 Thread Rahul Thathoo
. -- Cheers! RAHUL THATHOO B.TECH(IT), 5th SEMESTER IIIT - ALLAHABAD PHONE: +91+532 2552505(ask for room 201) eHome: http://profile.iiita.ac.in/rthathoo_02 RYZE home: http://www.ryze.com/go/thathoo -- MySQL General Mailing List For list archives: http

Two Instances

2004-09-06 Thread Rahul Thathoo
tance of a sub-query can be created. Is there a way around this problem. I would not like to make this sub-query again to get another instance of it. I need it very much, and if anyone can give me a way to do it, i would be highly grateful. Thanks in advance. Rahul Thathoo -- If real is characteriz

table across multiple files

2004-06-24 Thread Rahul Sood
have this feature ? Will it be necessary to get mysql 4.0 Max version ? The website said this version has some extra features such as Berkeley DBM and support for splitting a table across multiple files. -Thanks, Rahul Sood [EMAIL PROTECTED] - Do

What is SAP R/3 Ver 4.6c installation procedure on PC?

2004-04-26 Thread Rahul Mandle
Sir, What is SAP R/3 Ver 4.6c installation procedure on PC? What is Partiontion requirement?RAM?HardDisk total requirement? C Can any help me for this installtion procedure? Regards Rahul - Do you Yahoo!? Win a $20,000 Career Makeover at Yahoo

Re: Innodb running out of disk space for relatively low number of rows!

2004-04-26 Thread Rahul Mandle
Sir, What is SAP R/3 Ver 4.6c installation procedure on PC? What is Partiontion requirement?RAM?HardDisk total requirement? C Can any help me for this installtion procedure? Regards Rahul "Sp.Raja" <[EMAIL PROTECTED]> wrote: Hi list, I have 5 Databases, out of which 2 have on

Bugreport

2003-01-18 Thread Rahul Jaising
rence)] >Description: >How-To-Repeat: >Fix: >Submitter-Id: >Originator:Rahul Jaising >Organization: >MySQL support: [none | licence | email support | extended email support ] >Synopsis: >Severity: <[ non-critical | serious | cri

Fw: error in HP-UX

2003-01-13 Thread Rahul
Hello all, Since there is no reply still, i'm forwarding it again. Hope someone will help to proceed further. Mysql compiles fine, but make test fails. OS: HP-UX I tried with hp-ux default thread and gnupthread. 1)while trying with default systems pthread, i got following error messages. gma

Fw: error in HP-UX

2003-01-08 Thread Rahul
Hello all, I've compiled Mysql-3.23.54a in HP-UX-11.11 using gcc. It compiles ok and while running "make test", i got following error. Can't create interrupt-thread (error 251, errno: 22) mysqld ended how to overcome this? plz help me asap. Advance Thanks and Regards, -sadha

accessing mysql from C

2002-11-08 Thread Rahul Amaram-RollNo.2000086
f any extra rpms other than server, client, shared and devel are necessary for using mysql from C. Rahul. - Before posting, please check: http://www.mysql.com/manual.php

Packet is larger than max_allowed_packet

2002-08-16 Thread Rahul Torvi
Hi All, I m getting this error (i knew this is very common error)when i try to insert a record into a table. --- java.sql.SQLException: Error during query: Unexpected Exception: java.lang.IllegalArgumentException message given: Packet is larger

RE: Error code 28

2002-05-12 Thread Rahul Torvi
you can use perror 28 to see what does that error code mean Rahul T -Original Message- From: Kittiphum Worachat [mailto:[EMAIL PROTECTED]] Sent: Monday, May 13, 2002 10:50 AM To: [EMAIL PROTECTED] Subject: Error code 28 Hello, mysql, In select field list if they have some field that

Loaddata in file ?

2001-12-25 Thread Rahul Torvi
Hi, Can I insert the data in database that is residing at remote server using loaddata in file query ? If yes then please give me the syntax for same. Kind Regards Rahul Torvi - Before posting, please check: http

Some weird Linking errors :)

2001-04-16 Thread Rahul Gauba
xt+0x12b): undefined reference to `compress' collect2: ld returned 1 exit status make: *** [all] Error 1 Am i suppossed to link some other file apart from libmysqlclient.a?? If possible, Pl. help me out. Thanks and Regards, Rahul Gauba

Linking errors

2001-04-09 Thread Rahul Gauba
for all functions defined in dblib.o. If i link them as seperate files i.e. 'libmysqlclient.a' and dblib.o rather than having both of them in a single archive file, it works. Can somebody tell me the reason why that happens?? If possible let me know how can i