crimso
29/08/2007, 08h54
Bonjour,
pour info mysql 5 (et les vues donc) est bien dispo sur le plan 720.
crimso
pour info mysql 5 (et les vues donc) est bien dispo sur le plan 720.
crimso
CREATE VIEW Contribution AS SELECT FilmId AS ContribId, FilmTitle AS ContribTitle, Added AS Added, CodeRedacteur, 1 AS TypeId FROM Film UNION ALL SELECT BookId AS ContribId, BookTitle AS ContribTitle, Added AS Added, CodeRedacteur, 2 AS TypeId FROM Book;
#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 'VIEW Contribution AS SELECT FilmId AS ContribId, FilmTitle AS ContribTitle, ' at line 1