create database db1;
use db1;
CREATE TABLE `db1` (
  `id` int(11) default NULL,
  `prezime` text,
  `ime` text,
  `grad` text,
  `albumi` int(11) default NULL,
  `visina` int(11) default NULL,
  `spol` int(11) default NULL,
  `datrodenja` date default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `db1`
--

INSERT INTO `db1` (`id`, `prezime`, `ime`, `grad`, `albumi`, `visina`, `spol`, `datrodenja`) VALUES
(1, 'Clapton', 'Eric', 'London', 10, 186, 1, '1945-02-15'),
(2, 'Spears', 'Britney', 'Mccaub', 7, 182, 0, '1982-04-15'),
(3, 'Mercury', 'Fredy', 'London', 3, 184, 1, '1955-04-27'),
(4, 'Rose', 'Axl', 'Indiana', 10, 176, 1, '1962-02-06'),
(5, 'Gaga', 'Lady', 'NewYork', 2, 155, 0, '1986-02-02');