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:
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:
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
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
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
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
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.
-
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
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
Hi,
I have a table as shown with approx 500 lines:
---
Tndr| Detail|
34 | one |
47 | two |
34
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
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
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)
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
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
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,
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
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
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
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
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
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
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]',
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
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:
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
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
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
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
-
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
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
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
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
- 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
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,
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,
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
37 matches
Mail list logo