phpBB.de

Code: Alles auswählen

Fehler

SQL-Befehl:

EPLACE INTO phpbb_footb_seasons VALUES
(1964, 'Saison 1963/1964', '1963/1964');

MySQL meldet: Dokumentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'EPLACE INTO phpbb_footb_seasons VALUES
(1964, 'Saison 1963/1964', '1963/1964')' at line 1 

Code: Alles auswählen

UPDATE phpbb_footb_teams AS target INNER JOIN (
SELECT team_id, max_symbol
FROM phpbb_footb_teams T
INNER JOIN (SELECT team_id AS team, max( team_symbol ) AS max_symbol
FROM phpbb_footb_teams
GROUP BY team
) AS agg
WHERE T.team_id = agg.team
GROUP BY team_id
) AS source ON target.team_id = source.team_id
SET target.team_symbol = source.max_symbol
[ Bearbeiten ] [ PHP-Code erzeugen ]