err-report help me

Martin Norland · *nix forums beginner Joined: 07 Feb 2005 Posts: 2

Denis Gerasimov wrote:

Artem Koltsov · *nix forums beginner Joined: 07 Feb 2005 Posts: 2

see 12.2 Control Flow functions of MySQL manual

select name, if(adopted=0,'N','Y') from animal;

sirisha gnvg · *nix forums beginner Joined: 04 Feb 2005 Posts: 3

Ingo Strüwing <ingo@mysql.com> wrote:
Hi Sirisha,

Am Donnerstag, den 27.01.2005, 08:41 +0000 schrieb sirisha gnvg:

Jan Kirchhoff · *nix forums beginner Joined: 07 Feb 2005 Posts: 16

We've had very good performance with the official mysql-icc-binaries, so
I upgraded to 4.1.8 last weekend since there is no official 4.1.9 binary
on the mysql.com-site...

It didn't help with my problems, I still have replication-crashs almost
every other hour. I put a fresh snapshot from the master onto the slave
but it didn't help either Sad

A simple "slave start" helps, so I have a cronjob running right now
checking for the replication-status and issuing a "slave start" if
necessary....

I have no other idea but try the gcc-4.1.9 in about 3 weeks, I have no
possibility to take the master database down anytime before that :(

Gleb Paharenko schrieb:

Aji Andri · *nix forums beginner Joined: 08 Feb 2005 Posts: 10

here a syntax

$query=&$conn->Execute("select * from itemlocation
where id limit 1 - 50");
$result=mysql_query($query);
$num_result=mysql_num_rows($result);

and error message are syntax error in
$num_result=mysql_num_rows($result); object unknown
can someone please give a direction

all I want to do is comparing data in itemlocation
with a value and if value in item location is smaller
then the value I make then it will appear in a message

Aji

__________________________________
Do you Yahoo!?
The all-new My Yahoo! - Get yours free!
http://my.yahoo.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org

Denis Gerasimov · *nix forums beginner Joined: 01 Mar 2005 Posts: 22

Rhino · *nix forums Guru Joined: 08 Feb 2005 Posts: 449

| Hi All,
|
| From what I understand the LIKE keyword allows you to do things like
include
| wildcards and match against regular expressions.
|
| But I have a question: is there any difference between the following?
|
| SELECT lname, fname FROM contacts WHERE lname = 'smith';
| SELECT lname, fname FROM contacts WHERE lname LIKE 'smith';
|
| I'm having difficulty figuring out the difference between these two
queries,
| if there is any. Can someone clarify?
|
| Sincerely,
| -Josh

As long the expression on the right hand side of the equal sign uses no
wildcard characters (% or _), the two WHERE conditions you've written are
functionally equivalent; they should get the same rows for their respective
result sets.

However, there *may* be a performance difference between the two. I don't
know if MySQL treats the two differently in terms of choosing an access path
but DB2 will normally choose a better access path for '=' than 'LIKE',
regardless (I think) of whether the LIKE expression contains wildcards. My
gut hunch is that if your LIKE expression is going to contain no wildcards,
you should probably write it as an '=' simply because it is likely to
perform better.

If anyone reading this is knowledgeable on MySQL performance, please jump in
and correct me if I'm wrong.

Rhino
---
rhino1 AT sympatico DOT ca
"There are two ways of constructing a software design. One way is to make it
so simple that there are obviously no deficiencies. And the other way is to
make it so complicated that there are no obvious deficiencies." - C.A.R.
Hoare

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org

Ingo Strüwing · *nix forums beginner Joined: 08 Feb 2005 Posts: 2

Hello,

Am Montag, den 07.02.2005, 17:16 +0000 schrieb sirisha gnvg:
....

Martin Norland · *nix forums beginner Joined: 07 Feb 2005 Posts: 2

My intention of setting the reply-to was not to offend, or claim you
were wrong - merely to move the discussion to the list I felt (and still
feel - as I've done it again) is most appropriate for the question.

anyway, back to the task at hand

( first: I'm assuming you restarted apache after changing your php.ini -
otherwise, that's your problem. )

Whatever the case, the error message clearly shows that it is not
reading the value, however it's set - because the error is still showing
a blank string for the socket. If it were a permissions problem with
the socket, you wouldn't be getting that exact error - at the very
least, it would still show the correct socket path. More likely, it
would also error with a "cannot open socket" or equivalent.

You may wish to examine ini_get(), ini_get_all(), phpinfo(), or
php_ini_scanned_files(), to verify if it is set, or to see if it's being
overwritten somewhere.

Cheers,

Denis Gerasimov wrote:

Chuck Herrick · *nix forums beginner Joined: 08 Feb 2005 Posts: 3

Here's hoping you can help.

I have installed Redhat Linux Fedora Core 3, server version from ISO's
burned on 2/2/05.

I have downloaded the latest MySQL 4.1.9-0 rpms, done an rpm -e and
upgraded the MySQL-server, MySQL-client, MySQL-devel and
MySQL-shared. Basically, I followed the instructions in
http://www.whoopis.com/howtos/php5-mysql4-FC3-rpm.html

Invoking /etc/init.d/mysql start does not yeild a running mysqld. In
/var/lib/mysql/<hostname>.err, I see the mysqld start followed by
mysqld stop a second or so later.

invoking /usr/sbin/mysqld --verbose --help returns nothing.

Can anyone help me get MySQL upgraded?

thanks
--
Chuck Herrick
mailto:cherrick@spamcop.net
512 289 0926 (cell)
830 839 4437 (home)

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org

Jeff Smelser · *nix forums beginner Joined: 04 Feb 2005 Posts: 38

On Tuesday 08 February 2005 03:32 pm, Emmett Bishop wrote:

Ligaya Turmelle · *nix forums beginner Joined: 08 Feb 2005 Posts: 16

Your not getting a valid result from your query. Add
if (!$result) { echo 'Bad query - message: ' . mysql_error();}

I think it will give you a syntax error on your query. MySQL syntax for
the LIMIT clause is:

Gabriel PREDA · *nix forums addict Joined: 04 Feb 2005 Posts: 72

Logan, David (SST - Adela · *nix forums Guru Wannabe Joined: 07 Feb 2005 Posts: 141

Hi Mohsen,

If you install the client libraries from http://www.mysql.com for the
version you wish, this will install the header files in the
mysql/include directory.

Regards

David Logan
Database Administrator
HP Managed Services
148 Frome Street,
Adelaide 5000
Australia

+61 8 8408 4273 - Work
+61 417 268 665 - Mobile
+61 8 8408 4259 - Fax

-----Original Message-----
From: Mohsen@ccerelrim03.cce.hp.com
[mailto:Mohsen@ccerelrim03.cce.hp.com] On Behalf Of Mohsen Pahlevanzadeh
Sent: Thursday, 10 February 2005 9:00 AM
To: mysql@lists.mysql.com
Subject: Header files

Dears,
I have started Linux-programming with C++.
I need to header files's name of MySQL.
Please give that's URL.
Yours,Mohsen

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=david.logan@hp.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org

Mohsen Pahlevanzadeh · *nix forums beginner Joined: 14 Mar 2005 Posts: 23

dear member,
My problem is name of those.When i wish to apply a function,I don't know name
of that's header file.I need to a document for it.
--Mohsen
On Thursday 10 February 2005 02:06, Logan, David (SST - Adelaide) wrote:

Google