/*
*-------------------------------------------------MySQL数据表---------------------------------------------------
*
*
C:\Users\kevinelstri>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)
*
*/
【MySQL 00】MySQL数据表
最新推荐文章于 2016-10-29 11:20:07 发布