export - missing column in create table
| User, date | Message |
|---|---|
|
Written by BubikolRamios
2 years ago Category: General 273 posts since Thu, 14 Jan 10 |
ver. 6.0.0.0.3621 copy create table to clpboard with MYSQL query browser DROP TABLE IF EXISTS `test`.`imported_data_stat_urad_cene_master`; CREATE TABLE `test`.`imported_data_stat_urad_cene_master` ( `id` int(10) unsigned NOT NULL, `name` varchar(200) COLLATE utf8_slovenian_ci NOT NULL, `grupa` int(10) unsigned NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_slovenian_ci; The result of export with HSQ ( 'grupa' column is gone !): # Dumping structure for table test.imported_data_stat_urad_cene_master DROP TABLE IF EXISTS `imported_data_stat_urad_cene_master`; CREATE TABLE IF NOT EXISTS `imported_data_stat_urad_cene_master` ( `id` int(10) unsigned NOT NULL, `name` varchar(200) COLLATE utf8_slovenian_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_slovenian_ci; |
|
Written by BubikolRamios
2 years ago 273 posts since Thu, 14 Jan 10 |
note: restart of HSQL did help, nothing else changed. |
|
Written by ansgar
2 years ago 3954 posts since Fri, 07 Apr 06 |
I can only guess that grupa was added after Heidi had cached the CREATE code for that table. |
|
Written by BubikolRamios
2 years ago 273 posts since Thu, 14 Jan 10 |
1. nope (I guess), the inserts following create, in that same exported file contained 'grupa' column. |
|
Please login to leave a reply, or register at first. |