| User, date |
Message |
Written by BubikolRamios
3 years ago
Category: Import/Export
273 posts
since Thu, 14 Jan 10
|
export creates something like that:
# --------------------------------------------------------
# Host: 127.0.0.1
# Database: test
# Server version: 5.1.31-community
# Server OS: Win32
# HeidiSQL version: 4.0.0.2983
# Date/time: 2010-01-20 06:32:28
# --------------------------------------------------------
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
# Dumping structure for table test.lang
DROP TABLE IF EXISTS `lang`;
CREATE TABLE IF NOT EXISTS `lang` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`en` varchar(400) NOT NULL,
`sl` varchar(400) CHARACTER SET utf8 COLLATE utf8_slovenian_ci DEFAULT NULL,
`sr` varchar(400) CHARACTER SET utf8 COLLATE utf8_slovenian_ci DEFAULT NULL,
`it` varchar(400) DEFAULT NULL,
`de` varchar(400) DEFAULT NULL,
`fr` varchar(400) DEFAULT NULL,
`hr` varchar(400) CHARACTER SET utf8 COLLATE utf8_slovenian_ci DEFAULT NULL,
`ru` varchar(400) CHARACTER SET utf8 DEFAULT NULL,
`es` varchar(400) DEFAULT NULL,
PRIMARY KEY (`id`,`en`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
# Dumping data for table test.lang: 173 rows
....
run that in linux session of heidi sql, all goes OK, but there is no indexes on target table ?
|
Written by BubikolRamios
3 years ago
273 posts
since Thu, 14 Jan 10
|
Actualy there are, coz I can see them with mysql query browser, heidi sql does ot see them !
|
Written by ansgar
3 years ago
3950 posts
since Fri, 07 Apr 06
|
Ah, notice your "USING BTREE" addition. That's currently unsuppoerted by HeidiSQL. See issue #1576.
|
|
|
Please login to leave a reply, or register at first. |
