MySQL Forums
Forum List  »  Delphi

Re: an old problem"multiple-step operation generated error check each status value"
Posted by: Baohong geng
Date: January 07, 2010 11:46PM

mysql 5.1

mysql-connector-odbc-5.1.5

CREATE TABLE `datas` (
`num` int(15) NOT NULL AUTO_INCREMENT COMMENT '序号\0e',
`nodenum` int(11) unsigned NOT NULL DEFAULT '1' COMMENT '设备节点号',
`channelnum` int(11) unsigned NOT NULL DEFAULT '1' COMMENT '设备通道号',
`sDate` datetime NOT NULL COMMENT '采样时刻\0\0ME',
`phase` int(1) unsigned NOT NULL DEFAULT '0' COMMENT '相别(0-A,1-B,2-C)',
`base` float(9,3) NOT NULL DEFAULT '0.000' COMMENT '电流或电压基波有效值',
`thd3` float(9,3) NOT NULL DEFAULT '0.000' COMMENT '三次谐波含量(%)',
`thd5` float(9,3) NOT NULL DEFAULT '0.000' COMMENT '五次谐波含量',
`thd7` float(9,3) NOT NULL DEFAULT '0.000' COMMENT '七次谐波含量',
`C` float(9,3) NOT NULL DEFAULT '0.000' COMMENT '电容值(pF)',
`absolutePhi` float NOT NULL DEFAULT '0' COMMENT '绝对介损角',
`absoluteTan` float NOT NULL DEFAULT '0' COMMENT '绝对介损',
`deltaPhi` float NOT NULL DEFAULT '0' COMMENT '相对介损角',
`deltaTan` float NOT NULL DEFAULT '0' COMMENT '相对介损',
`groupPhi` float NOT NULL DEFAULT '0' COMMENT '同组相对介损角',
`groupTan` float NOT NULL DEFAULT '0' COMMENT '同组相对介损',
`groupDeltaPhi` float NOT NULL DEFAULT '0' COMMENT '同组差角',
PRIMARY KEY (`num`)
) ENGINE=InnoDB AUTO_INCREMENT=33310 DEFAULT CHARSET=gb2312 COMMENT='InnoDB free: 9216 kB';

Options: ReplyQuote


Subject
Written By
Posted
Re: an old problem"multiple-step operation generated error check each status value"
January 07, 2010 11:46PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.