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 key
L PROTECTED]>
>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.
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 R
le 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:/p
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 roo
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 PROTEC
able has 2 records. When I run the above code, I have 2 blank
lines return. Could any one tell me what the problem is? Where could 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
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 coul
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 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
Msql-Mysq
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 dow
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 dow
15 matches
Mail list logo
