Hey,
I'm using the C api, issuing a SELECT statement and then calling
mysql_store_result().
What id like to know is, if I keep the MYSQL_ROW structure returned from
mysql_fetch_row(), and then call mysql_fetch_row() again into a different
MYSQL_ROW structure -- is that first MYSQL_ROW structure
Miguel
What i need is to list all the products and show the type name of
each of them.
What you need is a join
(http://dev.mysql.com/doc/refman/5.0/en/join.html), eg:
SELECT t.id, t.id_type, t.name, t.desc, t.price, p.name
FROM tbl AS t
INNER JOIN products AS p USING (id)
PB
-
You could try Cacti, it can graph applications as well as poll node health
and statistics e.t.c.
Cacti is a complete network graphing solution designed to harness the
power of RRDTool's data storage and graphing functionality. Cacti provides
a fast poller, advanced graph templating, multiple
Folk,
Just installed MySQL 4.1.14 on a new Windows XP Pro system - this is a
development system, no domain. Also installed PHP 4.3.11 and Apache 2.0.55.
so now I have WAMP, right? Apache works fine as the web server; PHP works
fine, as well.
As soon as I tried to access databases created
Barney
Dumb question, but is this in response to the error message you got
where at the end of the error it asks you to update your client
program? If so it is referring to the PHP code not the actual
PHP/MYSQL/APACHE programs. you need to update your PHP code to work
with the updated
I'm running a dual G5 xserve with OSXS 10.3.9. Mysql version 4.0.24
(the version that ships with the OS). For many months now mysql has
been stopping/crashing about twice a week. It's primary purpose in life
is to provide the database for a minimally used Horde webmail setup.
I've looked
Thanks, Jeremy,
Best answer I've seen yet - and I've searched a lot of docs! - but, naturally
it raises other questions grin /.
If I don't need to upgrade the PHP engine, is there some extension dll that I
should seek? For instance, to use Apache 2.x with PHP, we need to use the
Hi folks.
I want to set the status of 5 records to 'completed'. how do I go about
that without having to prepare 5 different instructions?
update myTable set status = 'completed' where id=10 OR id=20 OR id=30
OR id=40 OR id=50
I'm trying to reduce the number of instructions.
Cheers
--
update myTable set status = 'completed' where id IN (10,20,30,40,50) LIMIT
5;
I believe that should work.
As a precaution, I recommend always using LIMIT x whenever possible on
SELECT, UPDATE or DELETE statements. This will minimize any accidental
dammage to other records should you have
- Original Message -
From: Rich [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Saturday, March 18, 2006 6:28 PM
Subject: Update Multiple Records
Hi folks.
I want to set the status of 5 records to 'completed'. how do I go about
that without having to prepare 5 different
On 2006-03-18, at 00:59, Yani Copas wrote:
Is there a quick and dirty way to update such that I can only
affect the portion
of a string (varchar column) that matches a regexp?
(e.g. replace all '%20' with ' ' leaving the rest untouched?)
You know that proverb - For a man in possession
11 matches
Mail list logo
