mysql installation problem

2003-08-06 Thread Anil Garg
Hi, I am trying to install myql on redhat. mysql package used: mysql-3.23.52-unknown-freebsdelf4.6-i386.tar.gz While following the instructions in install document..when i run the follwing command.. scripts/mysql_install_db following errors appear: - scripts/mysql_install_db:

oracle.

2003-03-17 Thread Anil Garg
hi, m a frequent user of mysql. i was trying to use show tables on oracle(sql), but it dint work :( How do list tables in oracle? Thanks anil. p.s. sorry for the out of list question. - Before posting, please check:

RE: oracle.

2003-03-17 Thread Anil Garg
thanks, that helped anil :) -Original Message- From: Nestor Florez [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 12:51 PM To: Anil Garg Subject: Re: oracle. Anil, I do not remember correct but you need to look at the user_tables. 'desc user_tables' One of the fields mught

date query.

2003-03-10 Thread Anil Garg
Hi, The date field in my database table looks as below: 07th of March 2003 10:14:29 PM I need to write a query which gets me all the rows which are entered in last to weeks. Any ideas!! Thanks and Regards Anil. - Before

RE: date query.

2003-03-10 Thread Anil Garg
Thanks..that helped. anil :) -Original Message- From: Roger Baklund [mailto:[EMAIL PROTECTED] Sent: Monday, March 10, 2003 10:52 AM To: [EMAIL PROTECTED] Cc: Anil Garg Subject: Re: date query. * Anil Garg The date field in my database table looks as below: 07th of March 2003 10:14:29

mysqldump

2003-03-06 Thread Anil Garg
Hi, I need to dump a database table in tab seperated or comma seperated format and then want to delete the entries in that table.(And then mail the dump to someone.) Can i get some pointers about this. (I was not able to use -T option in mysqldump, i am trying ./mysqldump -T awf_four false_info

command line exectution of query(newbie)

2003-03-06 Thread Anil Garg
Hi, What am i doing wrong: # ./mysql database name -e delete * from table name where id 5; I get the mysql help page on exectuting the above command. The mysql verison i am using is : 3.23.52. Thanks and regards anil. -

RE: command line exectution of query(newbie)

2003-03-06 Thread Anil Garg
To: Anil Garg; [EMAIL PROTECTED] Subject: Re: command line exectution of query(newbie) Hi, The right DELETE syntax is : delete from table name where id 5; Regards, Jocelyn - Original Message - From: Anil Garg [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, March 06, 2003 6:26

RE: command line exectution of query(newbie)

2003-03-06 Thread Anil Garg
thanks, that helped :) -Original Message- From: Jennifer Goodie [mailto:[EMAIL PROTECTED] Sent: Thursday, March 06, 2003 1:49 PM To: Anil Garg; [EMAIL PROTECTED] Subject: RE: command line exectution of query(newbie) Database name goes after options. It is showing you the help page

database query.

2003-02-28 Thread Anil Garg
Hi, I have a table as shown with approx 500 lines: --- Tndr| Detail| 34 | one | 47 | two | 34

RE: database query.

2003-02-28 Thread Anil Garg
hi, I appreciate the time you spared for my problem. Thanks, that helped :) Regards Anil -Original Message- From: Bruce Feist [mailto:[EMAIL PROTECTED] Sent: Friday, February 28, 2003 2:47 PM To: Anil Garg Subject: Re: database query. There really isn't enough information for me

cant connect to mysql

2002-10-10 Thread Anil Garg
hi i am facing a very strange problem.. when i say apachectl restart my web site works fine.. but, when i say #apachectl stop #apachectl start the web user is not able to connect to the mysql database. Now, when i reboot the machine, the things become fine agian. I would reaaly appreciate

users who can access a database

2002-10-10 Thread Anil Garg
hi, Is there some place where i can define the users who can access the database. If yes..plz help thanx and regards anil sql,query - Before posting, please check: http://www.mysql.com/manual.php (the manual)

which version to use?

2002-09-06 Thread Anil Garg
hi What version combinations of mysql and php should be used? regards anil - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request

Supplied argument is not a valid MySQL result resource!!

2002-08-15 Thread Anil Garg
Hi, in the piece of code given below --- $qid = mysql_query( SELECT * FROM 1_nodedata WHERE id = $edit_id ); $frm = mysql_fetch_array($qid); --- i get the follownig error: Warning: Supplied argument is not a valid MySQL result resource in

Re: Supplied argument is not a valid MySQL result resource!!

2002-08-15 Thread Anil Garg
hi, m sorry i dint mention that its just a part of code. i am able to delete entries from the database .so i think mysql_connect is not the reason. please tell if u have some more ideas regards anil - Original Message - From: SteveH [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday,

Re: Supplied argument is not a valid MySQL result resource!!

2002-08-15 Thread Anil Garg
yes..it echos $edit_id fine. i am also feeling strange why its not working! regards anil - Original Message - From: Jocelyn Fournier [EMAIL PROTECTED] To: Anil Garg [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, August 15, 2002 5:40 PM Subject: Re: Supplied argument is not a valid

Re: Supplied argument is not a valid MySQL result resource!!

2002-08-15 Thread Anil Garg
can u plz tell me how can i check that? regards anil - Original Message - From: Dan Nelson [EMAIL PROTECTED] To: Anil Garg [EMAIL PROTECTED] Cc: SteveH [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, August 15, 2002 5:41 PM Subject: Re: Supplied argument is not a valid MySQL result

Re: Lost root password

2002-07-22 Thread Anil Garg
c if this helps: 1.. Cold Reboot the machine and hit the SPACE bar to stop loading when this message appears: Hit[ENTER] to boot immediately or any other key for cmd prompt. Booting kernel in 9,8,7? 2.. Type: boot -s (machine now in single user mode.) You will see the following

mysql upgrade

2002-07-18 Thread Anil Garg
hi, I cant use some characters in my full text search (like * , , etc.) I found out that it was due to the old version of the mysql i am using. Now the problem is i want to switch from the older version(3.23.49) to 4.0.2 so that my full text search can be more efficient. Can some one tell me

mysql upgrade

2002-07-18 Thread Anil Garg
hi, I cant use some characters in my full text search (like * , , etc.) I found out that it was due to the old version of the mysql i am using. Now the problem is i want to switch from the older version(3.23.49) to 4.0.2 so that my full text search can be more efficient. Can some one tell me

Re: UPDATE command..

2002-07-16 Thread Anil Garg
update table name set id = replace(id, '1', '2'); hope this helps anil - Original Message - From: Patrick J Okui [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, July 16, 2002 9:47 AM Subject: UPDATE command.. I have two collumns in my mysql database like this

' giving problem while inserting in table.

2002-07-12 Thread Anil Garg
Hi, I am making a faq maintenance system using mysql and php. To insert a entry in to a faq table i am using the following query: - INSERT INTO faq_table_netvd (id,question, answer,netvcr,netdetector,add_date,mod_date,keyword,category,display,attach_ id) VALUES ('0','$frm[question]',

replace query

2002-07-10 Thread Anil Garg
Hi, i have a table with 2000 rows. One column (name answer)has a string (ok --) in all the rows.(e.g ok -- yes we support this.). now i want to remove all these 'ok --' in this column..leaving(e.g yes we support this) I tried to do it with the replace query but being a newbie to mysql i couldnt

changing coulmn

2002-07-02 Thread Anil Garg
in my table a column has enties my_1 my_4 my_5 i wnat to change it to my_file_1 my_file_4 my_file_5 can someone please tell me the query for that. thanx anil - Before posting, please check:

Re: changing coulmn

2002-07-02 Thread Anil Garg
thanx for ur mail, m sorry in dint mention that infact its a big table... Is there a way i can do it in all the columns using only one query ?? thanx anil - Original Message - From: nellA hciR [EMAIL PROTECTED] To: Anil Garg [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, July 02

Re: Lost Connection to mysql server during query

2002-07-01 Thread Anil Garg
Hi, Thanx for your mail You are rightin my case the mysqld is getting restarted. But, whey is mysqld getting restarted and giving the Lost Connection error. How can i avoid that?? Thanx anil - Original Message - From: Dicky Wahyu Purnomo [EMAIL PROTECTED] To: Anil Garg [EMAIL

Lost Connection to mysql server during query

2002-06-27 Thread Anil Garg
Hi, Here is a strange problem!! I created a table by the following qurey: CREATE TABLE 1_polls ( id int(11) unsigned NOT NULL auto_increment, question varchar(128) NOT NULL default '', active tinyint(1) unsigned NOT NULL default '1', sortorder int(11) NOT NULL default '0', module_id

long table scroll down

2002-06-26 Thread Anil Garg
Hi, for viewing long tables. in my sql query when i say SELECT * FROM abc i miss the upper entries of the table as they scroll down. is there something by which i can view a table page by page(as | more in unix) thanx anil -

query: restartmysql daemon

2002-06-26 Thread Anil Garg
Hi, the sql process(on doing ps) shows the following process: /usr/local/bin/safe_mysqld --user=mysql when i kill this process and try to restart it with command: safe_mysqld --user=mysql it says a mysql process already exists. can anyone tell me how to restart mysql daemon. thanx anil

not able to edit table:((

2002-06-11 Thread Anil Garg
Hi, I am not able to edit a table: the sql queries i tried are follows: delete form documents where id = 134;gives the following error: error: table documents is read only repair doesnt seem to work repair table documents; Table Op Mst_typeMsg_text

Re: not able to edit table:((

2002-06-11 Thread Anil Garg
The persmissions seems to be ok. ne other ideas!! - Original Message - From: Kiss Dániel [EMAIL PROTECTED] To: Anil Garg [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, June 11, 2002 12:59 PM Subject: Re: not able to edit table:(( Greetings, Stop the MySQL server and check

Re: help with empty set

2002-06-05 Thread Anil Garg
have u tried with \0 ?? - Original Message - From: Chris Hohimer [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, June 05, 2002 1:54 PM Subject: help with empty set using PHP what is the value for a returned result from MySQL of empty set ex: if($result != NULL){ do this

Re: help with empty set

2002-06-05 Thread Anil Garg
- Original Message - From: Chris Hohimer [EMAIL PROTECTED] To: Anil Garg [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, June 05, 2002 2:26 PM Subject: Re: help with empty set yeah that kinda works... what i have is $result = mysql($database select x, y, z from $table

changing column name

2002-05-30 Thread Anil Garg
Hi Can anyone plz give me the query for chaning the column name of an existing table(which does not affect the elements of that column). I hope there is a way to do that. Any help appreciated Thanx Anil - Before posting,

errno: 145

2002-05-23 Thread Anil Garg
hi when i try to read a table using query select * from table name it shows following error: cant open file:'anil.MYD'.(errno: 145) y such an error can come!! earlier it was fine. thanx for help anil - Before posting,

Re: STRING TO NUMBER

2002-05-16 Thread Anil Garg
i think u dont need to it will automatically deal with it. - Original Message - From: Marcel [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, May 16, 2002 3:26 PM Subject: STRING TO NUMBER Hi, In Oracle i use TO_NUMBER to convert a String to a Number what Function Do i have