MiniSgbd Run SQL

MiniSGBD Execute SQL (DBMS), is an educational application to assist or learn the SQL language. The application runs the basic SQL commands through a command-line interface (Terminal), commands and queries are basically a first-time view with MySQL when executed by the command line. The data is saved and can be queried, also have a list of previous commands executed. Here is a list of possible operations.

Examples:

create database world;

use world;

show databases;

show tables;

create table people (id integer primary key not null, name varchar(40));

describe people;

insert into people values (1, 'Jhon');

select * from people;

select id, name from people;

select t1.id, t2.id from table as t1 join table as t2 on t1.id = t2.id;

select all from people order by id;

select * from people where id = 1 and name like '%jho%';

delete from people where id = 1 and ... or ...;

update people set name = 'Jack' where id = 1 and ...;

drop table people;

drop database world;

Type data = [integer, double, char, varchar(xx), date yyyy-mm-dd]

Type data = [null, not null, unique, primary key]

Exit the program = [exit ou quit]

Help = [help; ou h; ou ?;] for help.