- Original Message -
From: Eko Budiharto [EMAIL PROTECTED]
To: ActivePerl@listserv.ActiveState.com; mysql@lists.mysql.com;
[EMAIL PROTECTED]
Sent: Sunday, March 20, 2005 10:04 AM
Subject: update command
Hi,
I am having problem with update command. I run it directy in the mysql
Hi all,
I just found the error. The error was I did not include the execute statement
in my perl script.
Thank you very much for whom reply my email. Thank you very much. I really
appreciate it.
Eko Budiharto [EMAIL PROTECTED] wrote:
Date: Sun, 20 Mar 2005 07:04:27 -0800 (PST)
From: Eko
are inspecting the value from the command
line before the program has ended, the commit may not have happened yet which
would explain why the update doesn't appear to have taken place.)
Rhino
- Original Message -
From:
Eko
Budiharto
To: Rhino
Sent: Sunday, March 20, 2005 10:
Presumably you remembered to include
Eko Budiharto wrote:
Hi,
I am having problem with update command. I run it directy in the mysql console, it works. But when I run it from perl, it does not work.
here is the perl script
my $server2 = 'localhost';
my $db2 = 'database';
my $username2 =
Patrick J Okui wrote:
I have two collumns in my mysql database like this
+--++
|id|domain |
+--++
|user@domain1com |domain1.com |
|[EMAIL PROTECTED] |domain1.com |
|[EMAIL PROTECTED] |domain1.com |
update table name set id = replace(id, '1', '2');
hope this helps
anil
- Original Message -
From: Patrick J Okui [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, July 16, 2002 9:47 AM
Subject: UPDATE command..
I have two collumns in my mysql database like this
well, #1, I would revision my data model. since user and domain are 2
distinct pieces of information, I would suggest that you consider pulling
them apart and placing them in separate fields.
#2
update users set is = concat(left(id,position('@',id)),'domain2.com') where
domain = domain1.com
or
and others posted should point you
in the right direction.
=C=
*
* Cal Evans
* The Virtual CIO
* http://www.calevans.com
*
-Original Message-
From: Patrick J Okui [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 16, 2002 10:16 AM
To: Cal Evans
Cc: [EMAIL PROTECTED]
Subject: RE: UPDATE command
I am looking to update a record in a table, but take the
exsisting value and adding the new value to it...
I.e.
Exsisting record = 150, new record being inputed = 250 for a
total of 400 to be entered into the database.
UPDATE table SET row = row + 250 WHERE id = #;
Created a table which will be used to track/process URLs:
CREATE TABLE dbURLlist(
IDSMALLINT UNSIGNED NOT NULL AUTO_INCREMENT,
AGING TINYINT UNSIGNED * ,
URL TINYTEXT NOT NULL,
PRIMARY KEY (ID),
INDEX (URL (25)))
In a PHP script (also prototyped using
Created a table which will be used to track/process URLs:
CREATE TABLE dbURLlist(
IDSMALLINT UNSIGNED NOT NULL AUTO_INCREMENT,
AGING TINYINT UNSIGNED * ,
URL TINYTEXT NOT NULL,
PRIMARY KEY (ID),
INDEX (URL (25)))
In a PHP script (also prototyped
11 matches
Mail list logo