.xml files extract to mysql for my image library

2008-07-12 Thread David Southwell
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

Re: Count total number of records in db

2008-07-12 Thread Rob Wultsch
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:

How to compare rows in different tables?

2008-07-12 Thread mos
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

Re: How to compare rows in different tables?

2008-07-12 Thread Rob Wultsch
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

Re: Insert into...on duplicate key problem

2008-07-12 Thread Rob Wultsch
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,sum(old.y)

UPDATE rows based on multiple WHERE values?

2008-07-12 Thread Waynn Lue
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 = foo WHERE ActionsReceived = bar where foo and bar change for multiple sets of values. Is there a way to do this in one

Re: How to compare rows in different tables?

2008-07-12 Thread mos
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 approx

Re: UPDATE rows based on multiple WHERE values?

2008-07-12 Thread Rob Wultsch
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 = foo WHERE ActionsReceived = bar where foo and