import: from MySQL Workbanch to phpMyAdmin
I've export same table, from phpMyAdmin, in .sql file.
Then I've imported that table in MYSQL Workbench and everything work fine.
Now, I try, without to modify nothing, to export the tables in .sql and import again in phpMyAdmin and I receive back an error below.
Why?
I need to import to phpMyAdmin many manypulated tables.... what can I do?
Query SQL:
-- ----------------------------------------------------- -- Table `mydb`.`jos_categories` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `mydb`.`jos_categories` ( `id` INT(11) NOT NULL AUTO_INCREMENT , `asset_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'FK to the #__assets table.' , `parent_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' , `lft` INT(11) NOT NULL DEFAULT '0' , `rgt` INT(11) NOT NULL DEFAULT '0' , `level` INT(10) UNSIGNED NOT NULL DEFAULT '0' , `path` VARCHAR(255) NOT NULL DEFAULT '' , `extension` VARCHAR(50) NOT NULL DEFAULT '' , `title` VARCHAR(255) NOT NULL , `alias` VARCHAR(255) NOT NULL DEFAULT '' , `note` VARCHAR(255) NOT NULL DEFAULT '' , `description` VARCHAR(5120) NOT NULL DEFAULT '' , `published` TINYINT(1) NOT NULL DEFAULT '0' , `checked_out` INT(11) UNSIGNED NOT NULL DEFAULT '0' , `checked_out_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' , `access` TINYINT(3) UNSIGNED NOT NULL DE[...]
Message MySQL:
#1067 - Invalid default value for 'checked_out_time'