boxman 发表于 2008-2-4 15:22:01

MRG_MyISAM表结构如何更改？

不太清楚这种存储引擎
只大概知道

kider 发表于 2008-2-4 23:31:05

表结构如何更改？
用SQL语句呀！

或是你有其他的意思？:o

boxman 发表于 2008-2-5 09:01:14

all_logs | CREATE TABLE `all_logs` (
`host` varchar(128) default NULL,
`facility` varchar(10) default NULL,
`priority` varchar(10) default NULL,
`level` varchar(10) default NULL,
`tag` varchar(10) default NULL,
`datetime` datetime default NULL,
`program` varchar(15) default NULL,
`msg` text,
`seq` bigint(20) unsigned NOT NULL auto_increment,
KEY `seq` (`seq`),
KEY `host` (`host`),
KEY `program` (`program`),
KEY `datetime` (`datetime`),
KEY `priority` (`priority`),
KEY `facility` (`facility`)
) ENGINE=MRG_MyISAM DEFAULT CHARSET=latin1 UNION=(`logs`,`logs20071107`,`logs20071108`,`logs20071109`,`logs20071110`,`logs20071111`,`logs20071112`,`logs20071113`,`logs20071114`,`logs20071115`,`logs20071116`,`logs20071117`,`logs20071118`,`logs20071119`,`logs20071120`,`logs20071121`,`logs20071122`,`logs20071123`,`logs20071124`,`logs20071125`,`logs20071126`,`logs20071127`,`logs20071128`,`logs20071129`,`logs20071130`,`logs20071201`,`logs20071202`,`logs20071203`,`logs20071204`,`logs20071205`,`logs20071206`,`logs20071207`,`logs20071208`,`logs20071209`,`logs20071210`,`logs20071211`,`logs20071212`,`logs20071213`,`logs20071214`,`logs20071215`,`logs20071216`,`logs20071217`,`logs20071218`,`logs20071219`,`logs20071220`,`logs20071221`,`logs20071222`,`logs20071223`,`logs20071224`,`logs20071225`,`logs20071226`,`logs20071227`,`logs20071228`,`logs20071229`,`logs20071230`,`logs20071231`,`logs20080101`,`logs20080102`,`logs20080103`,`logs20080104`,`logs20080105`,`logs20080106`,`logs20080107`,`logs20080108`,`logs20080109`,`logs20080110`,`logs20080111`,`logs20080112`,`logs20080113`,`logs20080114`,`logs20080115`,`logs20080116`,`logs20080117`,`logs20080118`,`logs20080119`,`logs20080120`,`logs20080121`,`logs20080122`,`logs20080123`,`logs20080124`,`logs20080125`,`logs20080126`,`logs20080127`,`logs20080128`,`logs20080129`,`logs20080130`,`logs20080131`,`logs20080201`,`logs20080202`,`logs20080203`,`logs20080204`,`logs20080205`) |
......



如上表结构，我想更改
program 为 varchar(45) 有什么方法？一张表一张表的改？
页: [1]
查看完整版本: MRG_MyISAM表结构如何更改？