Wiecie jak uzyskac cos takiego:
- jesli istnieje rekord w tabeli to zastosuj: UPDATE
- jesli nie istnieje do: INSERT
w jednym zapytaniu w mysql 4.1?
REPLACE [LOW_PRIORITY | DELAYED] [INTO] tbl_name [(col_name,...)] VALUES ({expr | DEFAULT},...),(...),...
REPLACE [LOW_PRIORITY | DELAYED] [INTO] tbl_name SET col_name={expr | DEFAULT}, ...
REPLACE [LOW_PRIORITY | DELAYED] [INTO] tbl_name [(col_name,...)] SELECT ...