On Fri, 31 Aug 2001, Sinisa Milivojevic wrote:
> May be you used some special chars in column names. In that case you
> should use instruct mysqldump to use backticks for table and column
> names.
Ehh, now I know what you meant: - to use -Q option to mysqldump ...., ok
but it anyway did not help.
CREATE TABLE `rep` (
`id` mediumint(8) unsigned NOT NULL default '0',
`prot_data_id` mediumint(8) unsigned NOT NULL default '0',
`contig_data_id` mediumint(8) unsigned NOT NULL default '0',
`contig_data_code` varchar(100) NOT NULL default '',
`code` varchar(100) NOT NULL default '',
`length` int(11) NOT NULL default '0',
`mw` float(10,2) NOT NULL default '0.00',
`pI` float(10,2) NOT NULL default '0.00',
`class` varchar(255) NOT NULL default '',
`mem` int(11) NOT NULL default '0',
`low` float(10,2) NOT NULL default '0.00',
`nonglob` float(10,2) NOT NULL default '0.00',
`coil` float(10,2) NOT NULL default '0.00',
`sigp` int(11) NOT NULL default '0',
`loc` varchar(255) NOT NULL default '',
`summary` text,
`geneid` varchar(255) NOT NULL default '',
`classification` varchar(255) NOT NULL default '',
`pubmed` varchar(255) NOT NULL default '',
`comments` text,
`remarks` text,
`descr` varchar(255) NOT NULL default '',
`manual` enum('yes','no') default NULL,
PRIMARY KEY (`id`),
KEY `class` (`class`),
KEY `loc` (`loc`),
KEY `geneid` (`geneid`),
KEY `classification` (`classification`),
KEY `pubmed` (`pubmed`),
KEY `descr` (`descr`),
KEY `code` (`code`),
KEY `prot_data_id` (`prot_data_id`),
KEY `contig_data_id` (`contig_data_id`)
) TYPE=MyISAM PACK_KEYS=1;
I'm pretty sure the problem is with text "nan" being in place of a float
number.
--
Martin Mokrejs - PGP5.0i key is at http://www.natur.cuni.cz/~mmokrejs
MIPS / Institute for Bioinformatics <http://mips.gsf.de>
GSF - National Research Center for Environment and Health
Ingolstaedter Landstrasse 1, D-85764 Neuherberg, Germany
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php