初步尝试tidb

1.在mac 上安装 Docker for Mac  略，傻瓜一样的装上了，怎么装的忘记了。

接下来按tidb github 主页提示  敲三行命令。

1. docker pull pingcap/tidb:latest

2.docker run --name tidb-server -d -p 4000:4000 pingcap/tidb:latest

3.  mysql -h 127.0.0.1 -P 4000 -u root -D test --prompt="tidb> " 

跟mysql 一样使用

tidb> show databases;

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

| Database           |

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

| INFORMATION_SCHEMA |

| PERFORMANCE_SCHEMA |

| mysql              |

| test               |

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

4 rows in set (0.00 sec)

tidb> create database yantesttidb;

Query OK, 0 rows affected (0.01 sec)

tidb> use yantesttidb;

Database changed

tidb> ctidb> 

tidb> create table testtimestamp1(u varchar(100),updatetime timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP);

Query OK, 0 rows affected (0.00 sec)

tidb> show create table testtimestamp1;

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

| Table          | Create Table                                                                                                                                                    |

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

| testtimestamp1 | CREATE TABLE `testtimestamp1` (

  `u` varchar(100) DEFAULT NULL,

  `updatetime` timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP

) ENGINE=InnoDB |

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

1 row in set (0.00 sec)

tidb> quit

Bye

shenhai:~ yan$ mysql -h 127.0.0.1 -P 4000 -u root -D test --prompt="tidb> " 

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 2

Server version: 5.7.1-TiDB-1.0 MySQL Community Server (GPL)

Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

tidb> show databases;

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

| Database           |

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

| INFORMATION_SCHEMA |

| PERFORMANCE_SCHEMA |

| mysql              |

| test               |

| yantesttidb        |

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

5 rows in set (0.00 sec)

tidb> use yantesttidb;

Reading table information for completion of table and column names

You can turn off this feature to get a quicker startup with -A

Database changed

tidb>  insert into testtimestamp1 (u) values ('uiui');

Query OK, 1 row affected (0.00 sec)

tidb> select * from  testtimestamp1;

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

| u    | updatetime          |

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

| uiui | 2017-02-08 15:23:28 |

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

1 row in set (0.00 sec)

tidb> explain select * from testtimestamp1;

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

| ID          | Json                                                                                                                                                                                                                                                                          | ParentID |

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

| TableScan_3 | {

    "db": "yantesttidb",

    "table": "testtimestamp1",

    "desc": false,

    "keep order": false,

    "push down info": {

        "limit": 0,

        "access conditions": null,

        "index filter conditions": null,

        "table filter conditions": null

    }

} |          |

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

1 row in set (0.00 sec)