Re: [lms] Mysql błąd

Matyasik Mieczysław wrote:

...

CREATE ALGORITHM = UNDEFINED DEFINER = `root`@ `localhost` SQL

SECURITY

...

DEFINER VIEW `customersview` AS SELECT `c`.`id` AS `id` ,

`c`.`lastname`

...

#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 'localhost` SQL SECURITY DEFINER VIEW `customersview` AS SELECT `c`.`id` AS `id` ' at line 1

ewidentnie jest to problem mysqla, najprościej myślę, będzie jak wywalisz fragment "ALGORITHM = UNDEFINED DEFINER = `root`@ `localhost` SQL SECURITY DEFINER", czyli zostaw CREATE VIEW .... Wydaje mi się też, że może problemem jest spacja po znaku @.

p.s. wycinaj sygnatury p.s.2. mysql 5.1 to wciąż rc