【MySQL 00】MySQL数据表

/*   *-------------------------------------------------MySQL数据表---------------------------------------------------       *       *          C:Userskevinelstri>mysql -u root -p          Enter password: *****          Welcome to the MySQL monitor.  Commands end with ; or g.          Your MySQL connection id is 118          Server version: 5.5.29 MySQL Community Server (GPL)            Copyright (c) 2000, 2012, 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.            mysql> show databases;          +--------------------+          | Database           |          +--------------------+          | information_schema |          | data1              |          | data2              |          | mysql              |          | performance_schema |          | test               |          +--------------------+          6 rows in set (0.00 sec)            mysql> use test;          Database changed          mysql> show tables;          +----------------+          | Tables_in_test |          +----------------+          | access         |          | app            |          | cal            |          | orders         |          | person         |          | person01       |          | web            |          | website        |          +----------------+          10 rows in set (0.00 sec)            mysql> select * from access;          +------+---------+-------+------------+          | aid  | site_id | count | date       |          +------+---------+-------+------------+          |    1 |       1 |    45 | 2016-05-10 |          |    2 |       3 |   100 | 2016-05-13 |          |    3 |       1 |   230 | 2016-05-14 |          |    4 |       2 |    10 | 2016-05-14 |          |    5 |       5 |   206 | 2016-05-14 |          |    6 |       4 |    13 | 2016-05-15 |          |    7 |       3 |   220 | 2016-05-16 |          |    8 |       5 |   545 | 2016-05-16 |          |    9 |       3 |   201 | 2016-05-17 |          +------+---------+-------+------------+          9 rows in set (0.00 sec)            mysql> select * from app;          +------+------------+-----------------------+---------+          | id   | app_name   | url                   | country |          +------+------------+-----------------------+---------+          |    1 | qq         | http://www.qq.com     | CN      |          |    2 | taobao app | http://www.taobao.com | CN      |          |    3 | weibo app  | http://weibo.com      | CN      |          +------+------------+-----------------------+---------+          3 rows in set (0.00 sec)            mysql> select * from cal;          +----+------+-------+--------+------+          | id | name | first | second | sum  |          +----+------+-------+--------+------+          |  1 | lily |    42 |      3 | NULL |          |  2 | mary |    22 |    637 | NULL |          |  3 | may  |    32 |     43 |   75 |          +----+------+-------+--------+------+          3 rows in set (0.00 sec)            mysql> select * from orders;          +------+---------+------+          | O_id | OrderNo | id   |          +------+---------+------+          |    1 |   77895 |    3 |          |    2 |   44678 |    3 |          |    3 |   22456 |    2 |          |    4 |   24562 |    1 |          +------+---------+------+          4 rows in set (0.00 sec)            mysql> select * from person;          +----+-----------+-----------+--------------+----------+          | id | LastName  | FirstName | Address      | City     |          +----+-----------+-----------+--------------+----------+          |  1 | Hansen    | Ola       | Timoteivn 10 | Sandes   |          |  2 | Svendson  | Tove      | Borgvn 23    | Sandes   |          |  3 | Pettersen | Keri      | Storgt 20    | Stavaner |          +----+-----------+-----------+--------------+----------+          3 rows in set (0.00 sec)            mysql> select * from website;          +----+----------+-------------------------+-------+---------+          | id | name     | url                     | alexa | country |          +----+----------+-------------------------+-------+---------+          |  1 | Google   | http://www.google.com   |     1 | USA     |          |  2 | taobao   | http://www.taobao.com   |    13 | CN      |          |  3 | cainiao  | http://www.runoob.com   |   673 | CN      |          |  4 | weibo    | http://weibo.com        |    20 | CN      |          |  5 | facebook | http://www.facebook.com |     3 | USA     |          |  7 | ali      | http://www.ali.com      |    32 | CN      |          +----+----------+-------------------------+-------+---------+          6 rows in set (0.00 sec)            mysql> select * from person01;          +------+------+---------+----------+------------+          | id   | name | address | city     | date       |          +------+------+---------+----------+------------+          |    1 | Lily | xian    | shanghai | NULL       |          |    2 | Mary | beijing | shanghai | 2016-03-02 |          +------+------+---------+----------+------------+          2 rows in set (0.00 sec)         *       */