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
|