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! Quote 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 '' Quote 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. Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.