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
Updated field
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 primary key
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 = 'username';
my $password2 = 'password';
my $dbh2 = DBI
- 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
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 perl script
my
arto"
<[EMAIL PROTECTED]>To: <ACTIVEPERL@LISTSERV.ACTIVESTATE.COM>;
<MYSQL@LISTS.MYSQL.COM>;<[EMAIL PROTECTED]>Sent: Sunday, March
20, 2005 10:04 AMSubject: update command Hi, I
am having problem with update command. I run it directy in the
mysqlconsole, it w
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
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 I
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
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 called pictures where I
find a string
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]
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
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
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
# [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 WHERE
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
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
: UPDATE command..
I have two collumns in my mysql database like this
+--++
|id|domain |
+--++
|user@domain1com |domain1.com |
|[EMAIL PROTECTED] |domain1.com |
|[EMAIL PROTECTED] |domain1.com
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'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, auto_increment
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 |
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,
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 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't
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
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/
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
29 matches
Mail list logo