sql72 B
SQL — Hello World
The classic first query in SQL — a single SELECT of a literal — for testing highlighters, SQL parsers, and query editors.
Preview — first 3 linessql
-- The classic first query, in SQL.
SELECT 'Hello, world!' AS greeting;
Specifications
- Language
- SQL
- Kind
- hello-world
- Lines
- 2
- Encoding
- UTF-8
- Line Endings
- LF
What is a .sql file?
SQL files contain plain-text Structured Query Language statements, typically schema definitions, data inserts, or queries used to build or populate a database. Dialect details vary between engines such as PostgreSQL, MySQL, and SQLite. A dump file often recreates an entire database when executed.
How to use this file
Use an example SQL file to test statement parsing, database restore and migration tooling, and dialect-compatibility of import pipelines.
Code examples
psql mydb < hello-world.sql # PostgreSQL
mysql -u user -p mydb < hello-world.sql # MySQLRelated files
- sqlSQL — Library schema (DDL, view, join)A realistic SQL script with CREATE TABLE constraints and foreign keys, INSERT seed data, a CREATE VIEW, and a grouped aggregate query with a join — for testing SQL parsers, formatters, and highlighters.
- cC — Hello WorldThe classic hello-world in C — an include, main, and printf — for testing highlighters, C compilers, and parsers against the canonical first program.
- cC — Linked list (structs, malloc, pointers)A realistic C program: a singly linked list with a typedef struct, malloc/free memory management, pointer walking, and error handling — for testing highlighters, compilers, and static analysers.
- cppC++ — Hello WorldThe classic hello-world in C++ — iostream and std::cout — for testing highlighters, C++ compilers, and parsers.
- cppC++ — Series (class template, STL)A realistic C++ snippet with a class template, STL algorithms (max_element, accumulate), std::move, and range handling — for testing highlighters, g++/clang++, and parsers against real templates.
- cssCSS — Component styles (variables, flexbox, keyframes)A realistic component stylesheet using custom properties, flexbox, a fluid clamp() font size, color-mix(), a keyframe animation, and a media query — for testing CSS parsers, linters (stylelint), and highlighters.
Generated by generation/code_samples.py. Free for any use, no attribution required — license.