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 = '';
my $username2 = '';
my $pass
Eko
Budiharto
To: Rhino
Sent: Sunday, March 20, 2005 10:57
AM
Subject: Re: update command
sorry Rhino,
what I mean with "does not work" is it does not update the value in the
mysql, but it does not give any error message either.
Rhino <[EMAIL PROTECTED]>
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 Budiha
- Original Message -
From: "Eko Budiharto" <[EMAIL PROTECTED]>
To: ; ;
<[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
console, it works. But when I run it from perl, it does
I 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 co
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"
o
update 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
>
> +
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 |
>+---
> 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 (a
> 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 us
11 matches
Mail list logo
