MySQL interesse |
|
mijn database ziet er zo uit:
CREATE TABLE `pagina_link` (
`id` mediumint(5) NOT NULL auto_increment,
`naam` varchar(255) collate latin1_general_ci NOT NULL,
`link` varchar(255) collate latin1_general_ci NOT NULL,
`plaats` varchar(5) collate latin1_general_ci NOT NULL,
`top` enum('0','1') collate latin1_general_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=3 ;
CREATE TABLE `pagina_link` ( `id` mediumint(5) NOT NULL AUTO_INCREMENT, `naam` varchar(255) collate latin1_general_ci NOT NULL, `link` varchar(255) collate latin1_general_ci NOT NULL, `plaats` varchar(5) collate latin1_general_ci NOT NULL, `top` enum('0','1') collate latin1_general_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=3 ;
En ik heb het script zelf geschreven |