Hjælp til SQL

SQL kode 

 CREATE TABLE `trailerrental` (
   `RENTALNUMBER` int(11) NOT NULL auto_increment,
   `LICENSENUMBER` int(11) NOT NULL,
   `TRAILERID` int(11) NOT NULL,
   `DATE` varchar(10) collate latin1_danish_ci NOT NULL,
   `FROMTIME` varchar(10) collate latin1_danish_ci NOT NULL,
   `TOTIME` varchar(10) collate latin1_danish_ci NOT NULL,
   PRIMARY KEY  (`RENTALNUMBER`),
   KEY `FK_LICENSE_COSTUMER` (`LICENSENUMBER`)
 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_danish_ci AUTO_INCREMENT=1 ;

SQL kode 

 INSERT INTO `bauhaus`.`trailerrental` (`RENTALNUMBER`, `LICENSENUMBER`, `TRAILERID`, `DATE`, `FROMTIME`, `TOTIME`) VALUES (`2`, `123`, `1`, `27/2`, `12.00`, `15.00`);