/inonusql

Database of Republic of Türkiye

Primary LanguageCOtherNOASSERTION

logo-no-background

INONUsql Database Management System

This directory contains the source code distribution of the INONUsql database management system.

INONUsql is an advanced object-relational database management system that supports an extended subset of the SQL standard, including transactions, foreign keys, subqueries, triggers, user-defined types and functions. This distribution also contains C language bindings.

Examples

Create a table

CREATE TABLE countries (
  name TEXT NOT NULL PRIMARY KEY,
  anthem TEXT NOT NULL,
  code VARCHAR(2) NOT NULL,
  population INTEGER DEFAULT 0,
);

Insert into table

INSERT INTO countries
VALUES ('Republic of Türkiye', 'İstiklal Marşı', 'tr', 85_000_000);

Update table

UPDATE countries WHERE code = 'tr' SET population = 86_000_000;

Delete from table

DELETE FROM citizens WHERE name LIKE 'recep';