distal-attribute
distal-attribute
distal-attribute
distal-attribute

export - missing column in create table

User, date Message
Written by BubikolRamios
4 years ago
Category: General
327 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
4 years ago
327 posts since Thu, 14 Jan 10
note: restart of HSQL did help, nothing else changed.
Written by ansgar
4 years ago
4973 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
4 years ago
327 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.