mysql> desc t1; +--------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------+-------------+------+-----+---------+-------+ | id | int(11) | YES | MUL | NULL | | | nick | varchar(32) | YES | | NULL | | | email | varchar(32) | YES | | NULL | | | gmt_create | datetime | YES | | NULL | | | gmt_modified | datetime | YES | | NULL | | +--------------+-------------+------+-----+---------+-------+ mysql> select count(*) from t1; +----------+ | count(*) | +----------+ | 2228017 | +----------+ 1 row in set (1.78 sec) |
mysql> alter table t1 add(tel varchar(20)); Query OK, 2304923 rows affected (41.03 sec) Records: 2304923 Duplicates: 0 Warnings: 0 |
mysql> select count(*) from t1; +----------+ | count(*) | +----------+ | 2304923 | +----------+ 1 row in set (2.10 sec) mysql> select * from t1 limit 10; +------+-------+------------------+---------------------+---------------------+ | id | nick | email | gmt_create | gmt_modified | +------+-------+------------------+---------------------+---------------------+ | 0 | nick0 | nick0@taobao.com | 2008-03-14 00:00:00 | 2008-03-14 00:00:00 | | 1 | nick1 | nick1@taobao.com | 2008-03-14 00:00:00 | 2008-03-14 00:00:00 | | 2 | nick2 | nick2@taobao.com | 2008-03-14 00:00:00 | 2008-03-14 00:00:00 | | 3 | nick3 | nick3@taobao.com | 2008-03-14 00:00:00 | 2008-03-14 00:00:00 | | 4 | nick4 | nick4@taobao.com | 2008-03-14 00:00:00 | 2008-03-14 00:00:00 | | 5 | nick5 | nick5@taobao.com | 2008-03-14 00:00:00 | 2008-03-14 00:00:00 | | 6 | nick6 | nick6@taobao.com | 2008-03-14 00:00:00 | 2008-03-14 00:00:00 | | 7 | nick7 | nick7@taobao.com | 2008-03-14 00:00:00 | 2008-03-14 00:00:00 | | 8 | nick8 | nick8@taobao.com | 2008-03-14 00:00:00 | 2008-03-14 00:00:00 | | 9 | nick9 | nick9@taobao.com | 2008-03-14 00:00:00 | 2008-03-14 00:00:00 | +------+-------+------------------+---------------------+---------------------+ 10 rows in set (0.00 sec) mysql> update t1 set nick='test_nick' where id=1; Query OK, 4 rows affected (43.89 sec) --这里是阻塞的时间 Rows matched: 4 Changed: 4 Warnings: 0 |
欢迎光临 MariaDB社区 (http://123.56.88.72/) | Powered by Discuz! X3.2 |