VIEW and GROUP_CONCAT

mysql> CREATE TABLE test_1 (str text);

mysql> INSERT INTO `test_1` VALUES ("My"),("SQL");

mysql> 

CREATE VIEW my_view AS SELECT GROUP_CONCAT(str  SEPARATOR  '\\') FROM `test_1`

;

Query OK, 0 rows affected (0.01 sec)

mysql> SELECT * FROM my_view;

ERROR 1064 (42000): 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 '\\')` from `data`.`test_1`' at line 1

mysql> SHOW CREATE VIEW my_view;ERROR 1064 (42000): 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 '\\')` from `data`.`test_1`' at line 1