mysql explain insert_执行explain insert into语句自动提交

这个不能证明是explain导致的插入。有可能是表中原来就有数据，或是从其它渠道插入了数据。

mysql -umycat -pmycat -h192.168.0.100 -P8066 test

mysql> truncate table t2;

Query OK, 0 rows affected (0.12 sec)

mysql> select * from t2;

Empty set (0.02 sec)

mysql> desc t2;

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

| Field | Type | Null | Key | Default | Extra |

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

| id | int(10) unsigned | NO | PRI | NULL | auto_increment |

| name | int(10) unsigned | NO | | NULL | |

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

2 rows in set (0.01 sec)

mysql> explain insert into t2 (id,name) values(1,'a');

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

| DATA_NODE | SQL |

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

| dn1 | insert into t2 (id,name) values(1,'a') |

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

1 row in set (0.08 sec)

mysql> select * from t2;

Empty set (0.01 sec)

mysql> explain insert into t2 (id,name) values(2,'a');

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

| DATA_NODE | SQL |

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

| dn4 | insert into t2 (id,name) values(2,'a') |

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

1 row in set (0.00 sec)

mysql> select * from t2;

Empty set (0.02 sec)