Esempio di applicazione - Prof-Matteo-Palitto-Peano/GPO-Software-Project GitHub Wiki

Data Base

CREATE DATABASE TEST;

creo la tabella

create table Employees
   (
      id int not null UNIQUE,
      age int not null,
      first varchar (255),
      last varchar (255),
      PRIMARY KEY (id)
   );

Inserisco alcuni impiegati

INSERT INTO Employees VALUES (100, 18, 'Zara', 'Ali');
INSERT INTO Employees VALUES (101, 25, 'Mahnaz', 'Fatma');
INSERT INTO Employees VALUES (102, 30, 'Zaid', 'Khan');
INSERT INTO Employees VALUES (103, 28, 'Sumit', 'Mittal');