-- MySQL dump 8.22
--
-- Host: localhost    Database: test
---------------------------------------------------------
-- Server version	3.23.55-log

--
-- Table structure for table 't1'
--

DROP TABLE IF EXISTS t1;
CREATE TABLE t1 (
  id int(11) default NULL,
  nome char(30) default NULL
) TYPE=MyISAM;

--
-- Dumping data for table 't1'
--


INSERT INTO t1 VALUES (1,'pippo');
INSERT INTO t1 VALUES (2,'pluto');
INSERT INTO t1 VALUES (3,'caio');
INSERT INTO t1 VALUES (4,'pluto');

--
-- Table structure for table 't2'
--

DROP TABLE IF EXISTS t2;
CREATE TABLE t2 (
  id2 int(11) default NULL,
  stipendio int(11) default NULL
) TYPE=MyISAM;

--
-- Dumping data for table 't2'
--


INSERT INTO t2 VALUES (1,1000);
INSERT INTO t2 VALUES (3,3000);
INSERT INTO t2 VALUES (2,1900);
INSERT INTO t2 VALUES (7,10);

--
-- Table structure for table 't3'
--

DROP TABLE IF EXISTS t3;
CREATE TABLE t3 (
  id2 int(11) default NULL,
  indirizzo char(30) default NULL
) TYPE=MyISAM;

--
-- Dumping data for table 't3'
--


INSERT INTO t3 VALUES (1,'pescara');
INSERT INTO t3 VALUES (2,'chieti');
INSERT INTO t3 VALUES (3,'roma');

--
-- Table structure for table 't4'
--

DROP TABLE IF EXISTS t4;
CREATE TABLE t4 (
  nome char(20) default NULL,
  valore int(11) default NULL,
  categoria char(10) default NULL
) TYPE=MyISAM;

--
-- Dumping data for table 't4'
--


INSERT INTO t4 VALUES ('giuseppe',100,'a');
INSERT INTO t4 VALUES ('marco',200,'b');
INSERT INTO t4 VALUES ('luca',NULL,'b');
INSERT INTO t4 VALUES ('luca',100,'b');
INSERT INTO t4 VALUES (NULL,NULL,'b');
INSERT INTO t4 VALUES ('carlo',1000,'a');

