User guide

Examples of commands (in the GUI Interface)

create database test
show databases
use test

create table person(firstname,lastname)
show tables
alter table person add column tel
alter table person modify column tel telephone
show columns from person
alter table person drop column telephone

insert into person value(frank,lucas)
insert into person value(martin,scorsese)
insert into person value(ridley,scott)
update tab1 set firstname='george' where lastname='lucas'
delete from person where lastname='scott'

select * from person where lastname='lucas'
drop table person
drop database test