mysql hint 简书_MySQl

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '你的新密码';

Enter password:

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

Your MySQL connection id is 73

Server version: 5.5.54-0ubuntu0.14.04.1 (Ubuntu)

mysql> show databases ;

mysql> use flow_information;

mysql> show tables;

mysql> desc staWor2AppNew;

mysql> create table staWor2AppDF like staticWord2App;

mysql> select count(*) from staWor2AppDF;

mysql> select count(*) from staWor2AppNew;

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

| count(*) |

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

|    55052 |

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

1 row in set (5.78 sec)

mysql> select count(*) from staticWord2App;

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

| count(*) |

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

|  7795441 |

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