utgwkk/quine.sql

Created May 15, 2021 03:17

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/utgwkk/e3af094288afd2621d74b4628727eb6f.js"></script>
Save utgwkk/e3af094288afd2621d74b4628727eb6f to your computer and use it in GitHub Desktop.

Download ZIP

Quine in SQL (SQLite3)

Raw

with quine as (select 'with quine as (select %c%s%c as s) select printf(s, char(39), s, char(39)) from quine' as s) select printf(s, char(39), s, char(39)) from quine

Author

utgwkk commented May 15, 2021

% sqlite3 < quine.sql | tee out
with quine as (select 'with quine as (select %c%s%c as s) select printf(s, char(39), s, char(39)) from quine' as s) select printf(s, char(39), s, char(39)) from quine
% diff quine.sql out           
%

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment