MySQL中怎样行使profile说明SQL执行状态

再看同结构数据的MyISAM表

mysql> create table payment_myisam like payment;

Query OK, 0 rows affected (0.03 sec)

mysql> alter table payment_myisam engine=myisam;

Query OK, 0 rows affected (0.03 sec)

Records: 0  Duplicates: 0  Warnings: 0

mysql> show create table payment_myisamG

*************************** 1. row ***************************

Table: payment_myisam

Create Table: CREATE TABLE `payment_myisam` (

payment_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,

customer_id` smallint(5) unsigned NOT NULL,

staff_id` tinyint(3) unsigned NOT NULL,

rental_id` int(11) DEFAULT NULL,

amount` decimal(5,2) NOT NULL,

payment_date` datetime NOT NULL,

last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,

PRIMARY KEY (`payment_id`),

KEY `idx_fk_staff_id` (`staff_id`),

KEY `idx_fk_customer_id` (`customer_id`),

KEY `fk_payment_rental` (`rental_id`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8

1 row in set (0.00 sec)

mysql> insert into payment_myisam select * from payment;

Query OK, 16049 rows affected (0.10 sec)

Records: 16049  Duplicates: 0  Warnings: 0

mysql> select count(*) from payment_myisam;

+----------+

| count(*) |

+----------+

|    16049 |

+----------+

1 row in set (0.01 sec)

（编辑：PHP编程网 - 黄冈站长网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!