SQL Escape Unescape tool helps you to escape and Unescape SQL string when you want to output the SQL directly not interpreted by browser.
How to Escape/ Unescape SQL?
- To Escape/ Unescape your SQL data add/ copy and paste the SQL data into the input.
- You can also load the SQL data from the url by clicking the button or load the SQL data from the computer by clicking the button.
- Click the 'Escape' or 'Unescape' button to process the data.
- Once conversion is done you can download the file by clicking the button.
Input Data
CREATE TABLE peoples(
id INTEGER PRIMARY KEY,
name CHAR(20),
age CHAR(2)
);
INSERT INTO peoples VALUES (1, 'name 1', '22');
INSERT INTO peoples VALUES (2, 'name 2', '33');
INSERT INTO peoples VALUES (3, 'name 3', '44');
INSERT INTO peoples VALUES (4, 'name 4', '55');
SELECT * FROM peoples
After Escape
CREATE TABLE peoples(
id INTEGER PRIMARY KEY,
name CHAR(20),
age CHAR(2)
);
INSERT INTO peoples VALUES (1, "name 1", "22");
INSERT INTO peoples VALUES (2, "name 2", "33");
INSERT INTO peoples VALUES (3, "name 3", "44");
INSERT INTO peoples VALUES (4, "name 4", "55");
SELECT * FROM peoples