scott botkins Posted June 14, 2007 Share Posted June 14, 2007 When I upload a sql file I am getting this error. Could someone please correct me on this? # ---------- CREATE TABLE `AusbildKZ` ---------- CREATE TABLE `AusbildKZ` ( `AusbildKZ` VARCHAR( 10 ) NOT NULL DEFAULT '""', `Bezeichnung` VARCHAR( 40 ) NULL DEFAULT '""', `PunkteA` TINYINT( 1 ) NULL , `PunkteB` TINYINT( 1 ) NULL , `PunkteC` TINYINT( 1 ) NULL , `Ergebnis` TINYINT( 1 ) NULL , `HotKey` VARCHAR( 1 ) NULL DEFAULT '""', `Datumerfasst` DATETIME NULL , `Datumgeaendert` DATETIME NULL , PRIMARY KEY ( `AusbildKZ` ) ) TYPE = MYISAM ; MySQL said: Documentation #1067 - Invalid default value for 'HotKey' Thanks! Link to comment https://forums.phpfreaks.com/topic/55500-help-on-invalid-default-value-error/ Share on other sites More sharing options...
bubblegum.anarchy Posted June 14, 2007 Share Posted June 14, 2007 change DEFAULT '""' to DEFAULT NULL or DEFAULT '' Link to comment https://forums.phpfreaks.com/topic/55500-help-on-invalid-default-value-error/#findComment-274440 Share on other sites More sharing options...
fenway Posted June 17, 2007 Share Posted June 17, 2007 You don't have to say NULL, it defaults to that. Link to comment https://forums.phpfreaks.com/topic/55500-help-on-invalid-default-value-error/#findComment-276332 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.