Blue Wave Software wrote:
I'm getting an error from the following SQL Syntax. Can anyone guide me on
what I am missing. It's probably obvious but I can't see it I have even
resorted to rereading the section on the update command.
The CustID Field is the unique Identifier and pri
I'm getting an error from the following SQL Syntax. Can anyone guide me on
what I am missing. It's probably obvious but I can't see it I have even
resorted to rereading the section on the update command.
The CustID Field is the unique Identifier and primary key of the table. The
U
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
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]>
m: Eko Budiharto <[EMAIL PROTECTED]>
Subject: update command
To: ActivePerl@listserv.ActiveState.com, mysql@lists.mysql.com,
[EMAIL PROTECTED]
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
- 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
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 $password2 = 'connect(&q
Awesome! It worked perfectly! Thanks Pat and Stephen.
Bob
-Original Message-
From: Patrick [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 25, 2003 4:20 PM
To: Bob Loeffler; [EMAIL PROTECTED]
Subject: Re: Replacing text using the Update command?
Bob,
Try:
UPDATE pictures set
Pat's version was better than mine.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello Bob,
- Original Message -
From: "Bob Loeffler" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, November 26, 2003 10:01 AM
Subject: Replacing text using the Update command?
> Hi all!
>
> I would like to update many records in a table cal
at...
CocoNet Corporation
825 SE 47th Terrace
Cape Coral, FL 33904
(239) 540-2626 Voice
- Original Message -
From: "Bob Loeffler" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, November 25, 2003 6:01 PM
Subject: Replacing text using the Update command?
Hi all!
I would like to update many records in a table called "pictures" where I
find a string in the "caption" column. If the string (e.g. "www.bob.com")
is found, replace it with another string (e.g. "www.bubba.com").
Unfortunately, there is other text in the caption column of these records,
so
# [EMAIL PROTECTED] / 2003-06-24 01:02:17 -0600:
> But, I need to know which rows were modified, not simply how many. So
> far this is the best that I have come up with
>
> LOCK TABLES MyTable WRITE
> SELECT * FROM MyTable WHERE SomeRecord = OldValue
> UPDATE MyTable SET SomeRecord = NewValue WHER
Hi Jason,
If I understand correctly you need the SELECT statement first to detemine
which records to update. However perhaps on the SELECT statement you could
speed up things by showing only the required columns and not all. While this
doesnt make a big difference for small tables, it can make
I've looked around and believe this to not be possible, but am checking just to be
sure.
Basically I want to run the command
UPDATE MyTable SET SomeRecord = NewValue WHERE SomeRecord = OldValue
But, I need to know which rows were modified, not simply how many. So far this is the
best that I ha
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
2 8:48 AM
To: [EMAIL PROTECTED]
Subject: UPDATE command..
I have two collumns in my mysql database like this
+--++
|id|domain |
+--++
|user@domain1com |domain1.com |
|[EMAIL PROTECTED] |domain1.com |
|
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..
>
>
>
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 have two collumns in my mysql database like this
+--++
|id|domain |
+--++
|user@domain1com |domain1.com |
|[EMAIL PROTECTED] |domain1.com |
|[EMAIL PROTECTED] |domain1.com |
+--++
in a
I'm relatively new to MySQL but "think" I am getting a grip on it.
However, I am seeing some strange behavior when I perform an update
command (through PHP). This following query not only results in the
sessionLastTime column updated but also another column sessionStartTime
(key,
Is there any database only (currently I'm doing this in perl) solution
to update a record or insert it if criteria isn't met:
for example, I have a table:
mysql> describe tblHits;
++--+--+-+-+---+
| Field | Type | Null | Ke
> 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 = #;
---
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.
I have looked at the man pages on this but all it gives is static numbers,
> > 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
) I tried:
UPDATE dbURLlist SET AGING=AGING+1
When * was set to DEFAULT 1 every record updated to 2, as expected; whereas when
* was set
to NULL or DEFAULT 0, it refused to update any of the records present.
The UPDATE command is stripped back to its bare essentials, but it still doesn&#
Can someone help me with the following command? The slashes seem to be
causing a problem. It doesn't find /images/covers?
update products set products_image='images/covers' where
products_image='/images/covers%';
-
Before posti
Could someone help me out with the following line I think the slashes are
causing the problem but I am not sure:
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
29 matches
Mail list logo
