Skip to content

Instantly share code, notes, and snippets.

@YumaInaura

YumaInaura/file0.sql

Last active December 22, 2015 03:45
Show Gist options
  • Save YumaInaura/77b50105e5ddf3c314b2 to your computer and use it in GitHub Desktop.
Save YumaInaura/77b50105e5ddf3c314b2 to your computer and use it in GitHub Desktop.
Download ZIP
SQL で FROM を使わず、架空のレコードを SELECT する方法 ref: http://qiita.com/Yinaura/items/b3e3c88cb9e44dfb6595
Raw
file0.sql
SELECT 'john', 'programmer', 30;
Raw
file1.sql
+------+-----------+----+
| john | programmer | 30 |
+------+-----------+----+
| john | programmer | 30 |
+------+-----------+----+
Raw
file2.sql
SELECT 'john' AS Name, 'programmer' AS Job, 30 AS Age;
Raw
file3.sql
+------+------------+-----+
| Name | Job | Age |
+------+------------+-----+
| john | programmer | 30 |
+------+------------+-----+
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment