Hi all,
I find php slow when accessing mysql. When I do
$sql='select count(*) from table';
$result = mysql_query($sql);
It takes 10 sec to return. Is this normal speed for php or my Mandrake Linux
configuration problem?
The same query run in mysql return instantly. Thanks
Hi all,
How is MySql compare to Access database? I understand that Access database
is fit for a small environment where you have 5 to 10 users. Can MySql
handle larger environment like Oracle, Microsoft SQL or it is just like
Access?
Hi,
I am trying to learn about indexing and have a few questions.
1. Does index only apply to query that use = operator in the where clause?
2. Does operators such as , like and between will result to full table
scan?
3. For example, In the following table:
tbl_A
id int primary
]
To: Andy Cheng [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: Re: php+apache+mysql installation. Help!
Date: Thu, 23 May 2002 21:34:37 -0500
Dear Andy,
Here's a thought. Before you go much further, install Apache 2.0.36.
It's
easy to install and lots of improvements will be gained that you'll
Hi,
I am new to linux and trying to install Apache, php and mysql on my Redhat
7.2.Linux box. When I run the configure for PHP 4.2.1, I got this error:
checking whether build environment is sane..configure error:newly created
file is older than distributed files!
I have Apache 1.3.20 (from
Apache not
understand the php script? Thanks
From: Jim Philips [EMAIL PROTECTED]
To: Andy Cheng [EMAIL PROTECTED]
Subject: RE: mysql/php on linux
Date: 18 Mar 2002 21:59:09 -0500
You should not save php scripts in cgi-bin. They need to be in your
document root directory or a sub-directory
of http.conf is different. How
do I check if the module is load or installed?
From: Dustin Rabe [EMAIL PROTECTED]
To: Andy Cheng [EMAIL PROTECTED]
Subject: RE: mysql/php on linux
Date: Sat, 23 Mar 2002 11:57:53 -0800 (PST)
Try adding this to your http.conf file in apache.
ScriptAlias /php/ c:/php
Hi all,
I too new to php and mysql, trying to get things works. I installed Redhat
7.2, Apache, mysql and php. I copied a sample php script from the internet
and save it as phptest.php in my cgi-bin. When calling it from my browser, I
got Format error. Did I not do it right? Should I put it
Great, the uppercase in $sth-{NUM_OF_FIELDS} works. Now I can start to
learn perl. Any advice on where could I find a good source for beginner on
the web? Thank you very much.
From: ds [EMAIL PROTECTED]
To: Andy Cheng [EMAIL PROTECTED]
CC: [EMAIL PROTECTED]
Subject: Re: Mysql installation
Hi all,
I got this error message when trying to connect to mysql at the shell
command:
Error 2002:Can't connect to local MySql server through socket
'/var/lib/mysql/mysql.sock
There is no mysql.sock in the /var/lib/mysql directory. Did I miss some
thing in the mysql installation? Where
I
find better documentation on DBI::DBD::mysql stuff for beginner? man
DBD::mysql is difficult to understand. Thanks again for the info.
From: Chuck \PUP\ Payne [EMAIL PROTECTED]
To: Doug Thompson [EMAIL PROTECTED], Andy Cheng
[EMAIL PROTECTED], Intrex [EMAIL PROTECTED],
[EMAIL
Hello all,
I am new to linux. I was told that I need DBI::DBD to connect to Mysql
using perl. So I go to http://www.mysql.com/downloads/api-dbi.html and
downloaded DBI-1.18.tar.gz, Msql-Mysql-modules-1.2216.tar.gz. Using gunzip,
I unziped the two files. Now I have DBI-1.18.tar and
Hello all,
I am new to linux. I need to connect to Mysql using perl. I downloaded
DBI-1.18.tar.gz, Msql-Mysql-modules-1.2216.tar.gz from
http://www.mysql.com/downloads/api-dbi.html. I don't see any installation
instruction. Could some one show me how to install it? Thanks for the
help.
Hello,
I am new to MySql. I have MySql installed in my Linux PC. How do I connect
to MySql using Perl script and assign the result of a query to an array?
Where could I find a sample code? Thank you.
Andy
_
Get your FREE
Hello,
I am new to MySql. I have MySql installed in my Linux PC. How do I connect
to MySql using Perl script and assign the result of a query to an array?
Where could I find a sample code? Thank you.
Andy
_
Get your FREE
15 matches
Mail list logo