On Fri, Nov 30, 2007 at 08:44:18PM -0800, Frank Conradie wrote: > In sqlbuilder the "Replace" expression currently inherits from "Update", > but in MySQL, according to their official docs, "REPLACE works exactly > like INSERT", i.e. "REPLACE INTO ...". Thus it looks like it should > rather inherit from "Insert" (just replacing the "INSERT" with "REPLACE").
The syntax is (http://dev.mysql.com/doc/refman/4.1/en/replace.html): REPLACE [LOW_PRIORITY | DELAYED] [INTO] tbl_name SET col_name={expr | DEFAULT}, ... That is, it's much more UPDATE (because of SET) than INSERT (that uses a list of names and a list of values, not name/value pairs). PS. Forgive me for not answering so long. Oleg. -- Oleg Broytmann http://phd.pp.ru/ [EMAIL PROTECTED] Programmers don't die, they just GOSUB without RETURN. ------------------------------------------------------------------------- SF.Net email is sponsored by: The Future of Linux Business White Paper from Novell. From the desktop to the data center, Linux is going mainstream. Let it simplify your IT future. http://altfarm.mediaplex.com/ad/ck/8857-50307-18918-4 _______________________________________________ sqlobject-discuss mailing list sqlobject-discuss@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss