On Sat, Jul 12, 2008 at 8:01 PM, Waynn Lue <[EMAIL PROTECTED]> wrote:
> Is there any way to have an UPDATE statement change a column value based on
> the WHERE statement?
>
> Essentially, I want to do something like this
>
> UPDATE Actions SET ActionsSent = WHERE ActionsReceived =
>
> where foo a
At 07:05 PM 7/12/2008, Rob Wultsch wrote:
I suggest taking a look at mk-table-sync available from
http://www.maatkit.org/ .
On Sat, Jul 12, 2008 at 3:07 PM, mos <[EMAIL PROTECTED]> wrote:
> I have 2 tables (TblNew: Memory Table, TblOld: MyISAM table) with identical
> structure and each has appro
Is there any way to have an UPDATE statement change a column value based on
the WHERE statement?
Essentially, I want to do something like this
UPDATE Actions SET ActionsSent = WHERE ActionsReceived =
where foo and bar change for multiple sets of values. Is there a way to do
this in one SQL st
On Wed, Jul 9, 2008 at 9:37 AM, Phil <[EMAIL PROTECTED]> wrote:
> Is it possible to do an insert into with subselect and group by with an
> additional on duplicate insert ?
>
> CREATE TABLE NEW_TABLE (
> `a` varchar(10),
> `b` double
> ) engine=MyISAM;
>
>
> INSERT INTO NEW_TABLE (select old.x,su
I suggest taking a look at mk-table-sync available from
http://www.maatkit.org/ .
On Sat, Jul 12, 2008 at 3:07 PM, mos <[EMAIL PROTECTED]> wrote:
> I have 2 tables (TblNew: Memory Table, TblOld: MyISAM table) with identical
> structure and each has approx 75 columns in it. I need to update TblOld
I have 2 tables (TblNew: Memory Table, TblOld: MyISAM table) with identical
structure and each has approx 75 columns in it. I need to update TblOld
with rows in TblNew if any of the values are different, or insert the
TblNew rows into TblOld if they are are missing. The two tables have the
same
On Fri, Jul 11, 2008 at 4:24 AM, Warren Windvogel
<[EMAIL PROTECTED]> wrote:
> $tables = mysql_list_tables($DB_DBName);
Not that it matters much, but mysql_list_tables() is deprecated.
--
Rob Wultsch
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Has the wheel been invented??
All my image files, stored in *.psd (photoshop) or *.cr2 (canon raw files)
file extension, have an associated *.xml file that contains the metadata
relating to the image sharing the same file name. The *.xml files have been
created by Adobe bridge and/or photoshop
