谁解释一下是怎么回事? 执行下面的操作也不行create table T(n varchar(10) not null default '')type = innodb总之不能建立type = innodb 格式的表 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 就是你装mysql的时候选了不支持事务,查看支持的表类型可以用命令:mysql> show engines\G*************************** 1. row *************************** Engine: MyISAMSupport: DEFAULTComment: Default engine as of MySQL 3.23 with great performance*************************** 2. row *************************** Engine: MEMORYSupport: YESComment: Hash based, stored in memory, useful for temporary tables*************************** 3. row *************************** Engine: InnoDBSupport: YESComment: Supports transactions, row-level locking, and foreign keys*************************** 4. row *************************** Engine: BerkeleyDBSupport: NOComment: Supports transactions and page-level locking*************************** 5. row *************************** Engine: BLACKHOLESupport: NOComment: /dev/null storage engine (anything you write to it disappears)*************************** 6. row *************************** Engine: EXAMPLESupport: NOComment: Example storage engine*************************** 7. row *************************** Engine: ARCHIVESupport: YESComment: Archive storage engine*************************** 8. row *************************** Engine: CSVSupport: NOComment: CSV storage engine*************************** 9. row *************************** Engine: ndbclusterSupport: NOComment: Clustered, fault-tolerant, memory-based tables*************************** 10. row *************************** Engine: FEDERATEDSupport: NOComment: Federated MySQL storage engine*************************** 11. row *************************** Engine: MRG_MYISAMSupport: YESComment: Collection of identical MyISAM tables*************************** 12. row *************************** Engine: ISAMSupport: NOComment: Obsolete storage engine12 rows in set (0.00 sec) 请问:hy2003fly() 如何修改?安装的时候注意什么? 看配置文件的这一行是否被注释掉了#skip-innodb ALTER TABLE T_Name ENGINE = InnoDB; 如何设置mysql 指定数据库为只读 handlersocket无法安装在二进制版本mysql下面吗? MySQL的一些历史遗留问题,希望ACMAIN_CHM、zuoxingyu等高手帮忙回答下 关于MYSQL表中某字段内容前空格删除的命令 表访问频率 包含视图的mysql怎么备份和恢复?? 求一个Linux C写的开源数据库系统 mysql 日期比较 有关日期格式 mysql 插入空的整型值时候报错 关于不同服务器的两张结构相同的表合并 mysql与postgresql相比,哪个功能强大些,成熟些呢?听说mysql要收费了,难道真的不免费了吗? 如何计算mysql的时间间隔?
mysql> show engines\G
*************************** 1. row ***************************
Engine: MyISAM
Support: DEFAULT
Comment: Default engine as of MySQL 3.23 with great performance
*************************** 2. row ***************************
Engine: MEMORY
Support: YES
Comment: Hash based, stored in memory, useful for temporary tables
*************************** 3. row ***************************
Engine: InnoDB
Support: YES
Comment: Supports transactions, row-level locking, and foreign keys
*************************** 4. row ***************************
Engine: BerkeleyDB
Support: NO
Comment: Supports transactions and page-level locking
*************************** 5. row ***************************
Engine: BLACKHOLE
Support: NO
Comment: /dev/null storage engine (anything you write to it disappears)
*************************** 6. row ***************************
Engine: EXAMPLE
Support: NO
Comment: Example storage engine
*************************** 7. row ***************************
Engine: ARCHIVE
Support: YES
Comment: Archive storage engine
*************************** 8. row ***************************
Engine: CSV
Support: NO
Comment: CSV storage engine
*************************** 9. row ***************************
Engine: ndbcluster
Support: NO
Comment: Clustered, fault-tolerant, memory-based tables
*************************** 10. row ***************************
Engine: FEDERATED
Support: NO
Comment: Federated MySQL storage engine
*************************** 11. row ***************************
Engine: MRG_MYISAM
Support: YES
Comment: Collection of identical MyISAM tables
*************************** 12. row ***************************
Engine: ISAM
Support: NO
Comment: Obsolete storage engine
12 rows in set (0.00 sec)
如何修改?
安装的时候注意什么?
#skip-innodb