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 o
- Original Message -
From: "Rich" <[EMAIL PROTECTED]>
To:
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 instructions?
"update m
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 misty
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
--
Thanks, Jeremy,
Best answer I've seen yet - and I've searched a lot of docs! - but, naturally
it raises other questions .
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
php4apache2.dll. I
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 at
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
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 wit
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 data
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
-
Mi
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
11 matches
Mail list logo
