A quine in SQL.

quine.sql

SET SESSION group_concat_max_len = 1600;
DROP TABLE IF EXISTS `list`;
CREATE TABLE `list` (
  `id` INT(10) NOT NULL AUTO_INCREMENT,
  `var` VARCHAR(120) NOT NULL,
  PRIMARY KEY (`id`)
);
INSERT INTO `list` (`var`) VALUES
  ("SET SESSION group_concat_max_len = 1600;"),
  ("DROP TABLE IF EXISTS `list`;"),
  ("CREATE TABLE `list` ("),
  ("  `id` INT(10) NOT NULL AUTO_INCREMENT,"),
  ("  `var` VARCHAR(120) NOT NULL,"),
  ("  PRIMARY KEY (`id`)"),
  (");"),
  ("INSERT INTO `list` (`var`) VALUES"),
  (";"),
  ("SELECT GROUP_CONCAT(`var` SEPARATOR '\\r\\n') var"),
  ("FROM ("),
  ("( SELECT GROUP_CONCAT(`var` SEPARATOR '\\r\\n') var"),
  ("  FROM `list`"),
  ("  WHERE id<=8"),
  ("  ORDER BY `id`)"),
  ("UNION"),
  ("( SELECT GROUP_CONCAT(CONCAT('  (\"', REPLACE(REPLACE(`var`, '\\\\', '\\\\\\\\'), '\"', '\\\\\"' ), '\")') SEPARATOR ',\\r\\n') var"),
  ("  FROM `list`"),
  ("  ORDER BY `id`)"),
  ("UNION"),
  ("( SELECT GROUP_CONCAT(`var` SEPARATOR '\\r\\n') var"),
  ("  FROM `list`"),
  ("  WHERE id>8"),
  ("  ORDER BY `id`)"),
  (") t;")
;
SELECT GROUP_CONCAT(`var` SEPARATOR '\r\n') var
FROM (
( SELECT GROUP_CONCAT(`var` SEPARATOR '\r\n') var
  FROM `list`
  WHERE id<=8
  ORDER BY `id`)
UNION
( SELECT GROUP_CONCAT(CONCAT('  ("', REPLACE(REPLACE(`var`, '\\', '\\\\'), '"', '\\"' ), '")') SEPARATOR ',\r\n') var
  FROM `list`
  ORDER BY `id`)
UNION
( SELECT GROUP_CONCAT(`var` SEPARATOR '\r\n') var
  FROM `list`
  WHERE id>8
  ORDER BY `id`)
) t;