Hello world project extravaganza, the Sql version.
This repository contains a version of “Hello World” statements written in Sql;
indeed this is part of a fun and educational project that showcases how to print “Hello World” in different programming languages. The goal is to have a “Hello World” program in every programming language. This project is inspired by the GitHub Hello World project and you can found it in Hello World Extravaganza website.
To get started, clone this repository to your local machine:
git clone https://github.com/silviotorre/helloworld.git
To run the “Hello World” statement you need to have a Sql database installed on your machine. You can use MySql or PostgreSQL or any other Sql database.
SQL stands for Structured Query Language and is a standard language for storing, manipulating and retrieving data in databases. Our “Hello World” statement will use the MySql database. Info about Sql can be found at Sql Wikipedia and Sql Tutorial.
The standard of Sql language is defined by the ISO/IEC 9075 standard.
To run the “Hello World” statement navigate to the project directory and run the statement. Follow the instructions below to run the “Hello World”.
mysql -u root -p < helloworld.sql
This was an example of a more complex “Hello, World!” in Sql using a simple DML statement: In SQL DML is Data Manipulation Language and is used to retrieve, store, modify, delete, insert and update data in database. DML statements are SELECT, INSERT, UPDATE and DELETE.
Using CTE This one is made using Common Table Expression (CTE) and is a bit more complex than the previous one. A CTE is a temporary result set that is defined within the execution scope of a single SQL statement. A CTE is similar to a derived table in that it is not stored as an object and lasts only for the duration of the query. Unlike a derived table, a CTE can be self-referencing and can be referenced multiple times in the same query.
mysql -u root -p < helloworld2.sql
Using DDL A bit more complex example of “Hello, World!” in Sql using a simple DDL statement: In SQL DDL is Data Definition Language and is used to create and modify the structure of database objects in Sql. DDL statements are CREATE, ALTER, DROP, RENAME and TRUNCATE.
mysql -u root -p < helloDML.sql
Feel free to contribute your own “Hello World” programs to this repository. Simply create a new directory with the name of the programming language and add a file named hello-world.
Enjoy and happy coding!