Als ik deze paar zinnen
CREATE TABLE `[admin_checked]` (
`check_id` smallint(5) unsigned NOT NULL auto_increment,
`ip_adres` varchar(15) collate latin1_general_ci NOT NULL default '0.0.0.0',
`status` text collate latin1_general_ci NOT NULL,
`door_admin` varchar(50) collate latin1_general_ci NOT NULL default 'Niemand',
`op` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
PRIMARY KEY (`check_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=18 ;
In mijn Mysql Doe, Krijg ik deze error:
#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'collate latin1_general_ci NOT NULL default '0.0.0.0',
`statu
Wat is er verkeerd ik snap het niet
650 views
) gebruiken.