[root@rhcs2 sql]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 9
Server version: 5.7.19-17 Percona Server (GPL), Release 17, Revision e19a6b7b73f
Copyright (c) 2009-2017 Percona LLC and/or its affiliates
Copyright (c) 2000, 2017, 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>
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| sys |
+--------------------+
4 rows in set (0.00 sec)
mysql>
mysql> create database you;
Query OK, 1 row affected (0.00 sec)
mysql>
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| sys |
| you |
+--------------------+
5 rows in set (0.00 sec)
mysql>
mysql> select database();
+------------+
| database() |
+------------+
| NULL |
+------------+
1 row in set (0.00 sec)
mysql>
mysql> use you;
Database changed
mysql>
mysql> select database();
+------------+
| database() |
+------------+
| you |
+------------+
1 row in set (0.00 sec)
mysql>
mysql> show tables;
Empty set (0.00 sec)
mysql>
mysql> source /script/sql/give_me_big_data.sql
Query OK, 0 rows affected, 1 warning (0.00 sec)
Query OK, 0 rows affected (0.43 sec)
Query OK, 0 rows affected, 1 warning (0.00 sec)
Query OK, 0 rows affected (0.48 sec)
Query OK, 0 rows affected, 1 warning (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected, 1 warning (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
mysql>
mysql> show tables;
+--------------------+
| Tables_in_you |
+--------------------+
| vote_record |
| vote_record_memory |
+--------------------+
2 rows in set (0.00 sec)
mysql>
mysql> desc vote_record;
+-------------+---------------------+------+-----+-------------------+-----------------------------+
| Field | Type | Null | Key | Default | Extra |
+-------------+---------------------+------+-----+-------------------+-----------------------------+
| id | int(10) unsigned | NO | PRI | NULL | auto_increment |
| user_id | varchar(20) | NO | MUL | | |
| vote_num | int(10) unsigned | NO | | 0 | |
| group_id | int(10) unsigned | NO | | 0 | |
| status | tinyint(2) unsigned | NO | | 1 | |
| create_time | timestamp | NO | | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP |
+-------------+---------------------+------+-----+-------------------+-----------------------------+
6 rows in set (0.00 sec)
mysql>
mysql> desc vote_record_memory;
+-------------+---------------------+------+-----+-------------------+-----------------------------+
| Field | Type | Null | Key | Default | Extra |
+-------------+---------------------+------+-----+-------------------+-----------------------------+
| id | int(10) unsigned | NO | PRI | NULL | auto_increment |
| user_id | varchar(20) | NO | MUL | | |
| vote_num | int(10) unsigned | NO | | 0 | |
| group_id | int(10) unsigned | NO | | 0 | |
| status | tinyint(2) unsigned | NO | | 1 | |
| create_time | timestamp | NO | | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP |
+-------------+---------------------+------+-----+-------------------+-----------------------------+
6 rows in set (0.00 sec)
mysql>
mysql> select * from vote_record;
Empty set (0.00 sec)
mysql>
mysql> select * from vote_record_memory;
Empty set (0.00 sec)
mysql>
Adamhuan