The initial goal is to provide a working framework from which to call all UNIX
shell command combinations as the underlying storage mechanism for a machine
learning algorithm. I would like to build a completely self aware
instantiation that will maintain itself on all levels... I postulate that
Hi Incarus,
You don't need a loop just a correlated subquery on the update:
UPDATE TB1 SET Ivet=PREG_REPLACE('/TeXT/', '', Ivet);
Example:
mysql> CREATE TABLE blah(value INTEGER, square INTEGER);
Query OK, 0 rows affected (0.17 sec)
mysql> INSERT INTO blah(value) VALUES (1),(2),(3),(4),(5);
Q
Garot
Can ypou provide any specific goal(s) on what you would like to achieve?
Martin
__
Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité
Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger
sein, so
On 8/19/2012 5:56 PM, william drescher wrote:
mysql> select status from tasks;
++
| status |
++
| W |
++
1 row in set (0.00 sec)
mysql> update tasks set status= 'H';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed 1 Warnings: 0
mysql> select status f
On 8/19/2012 1:25 PM, Johnny Withers wrote:
The client indicates a warning after the update. Issue a show warnings
after the update.
actually, it doesn't.
but I did a show warnings and it replied: Empty Set (0.00 sec)
I also did a show triggers and it replied: Empty Set (0.00 sec)
On Aug 19,
I have a two line query that is only able to handle 1 row per
execution. Could any of you give me some insight on how I could loop this
per every single row in the table? The query in question is:
SELECT PREG_REPLACE('/TeXT/', '' , Ivet) FROM `DB1`.`TB1` INTO @VAR12;
UPDATE `TB1` SET Ivet = @VAR12
The client indicates a warning after the update. Issue a show warnings
after the update.
On Aug 19, 2012 11:19 AM, "william drescher"
wrote:
> On 8/17/2012 12:13 PM, Rik Wasmus wrote:
>
>> I get 1 row affected, but the status does not change when I look
>>> at the row.
>>>
>>> If I set it to 'X'
On 8/17/2012 12:13 PM, Rik Wasmus wrote:
I get 1 row affected, but the status does not change when I look
at the row.
If I set it to 'X' it does change.
To make it even more wacky, if I (using phpMyAdmin) change it to
'H' it will change and the row is shown change, but when I go to
examine the