Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 7
Server version: 5.7.18-log MySQL Community Server (GPL)

Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> CREATE DATABASE Test;
Query OK, 1 row affected (0.00 sec)

mysql> USE Test;
Database changed
mysql> CREATE TABLE TextTable(
    -> TextInput VARCHAR(100)
    -> );
Query OK, 0 rows affected (0.31 sec)

mysql> SET @@SESSION.sql_mode='NO_BACKSLASH_ESCAPES';
Query OK, 0 rows affected, 1 warning (0.00 sec)

mysql> DELIMITER $$
mysql> CREATE PROCEDURE TestLiteral()
    -> BEGIN
    -> INSERT INTO TextTable (TextInput) VALUES ('Literal string with \backspace');
    -> END$$
Query OK, 0 rows affected (0.09 sec)

mysql> CREATE PROCEDURE TestParameter(IN TextIn VARCHAR(100))
    -> BEGIN
    -> INSERT INTO TextTable (TextInput) VALUES (TextIn);
    -> END$$
Query OK, 0 rows affected (0.03 sec)

mysql> DELIMITER ;
mysql> CALL TestLiteral();
Query OK, 1 row affected (0.05 sec)

mysql> CALL TestParameter('Parameter with \backspace');
Query OK, 1 row affected (0.06 sec)

mysql> SELECT * FROM TextTable;
+--------------------------------+
| TextInput                      |
+--------------------------------+
| Literal string with \backspace |
| Parameter with \backspace      |
+--------------------------------+
2 rows in set (0.00 sec)

mysql> SET @@SESSION.sql_mode='';
Query OK, 0 rows affected (0.00 sec)

mysql> DELETE FROM TextTable;
Query OK, 2 rows affected (0.05 sec)

mysql> CALL TestLiteral();
Query OK, 1 row affected (0.05 sec)

mysql> CALL TestParameter('Parameter with \backspace');
Query OK, 1 row affected (0.03 sec)

mysql> SELECT * FROM TextTable;
+--------------------------------+
| TextInput                      |
+--------------------------------+
| Literal string with \backspace |
| Parameter with ackspace       |
+--------------------------------+
2 rows in set (0.00 sec)

mysql> exit