MariaDB [jason]> create temporary table tmp(pro char(),city char());

Query OK,  rows affected (0.01 sec)

MariaDB [jason]> insert into tmp values('shanghai','shanghai');

Query OK,  row affected (0.00 sec)

MariaDB [jason]> select * from tmp;

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

| pro      | city     |

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

| shanghai | shanghai |

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

 row in set (0.00 sec)

MariaDB [jason]> drop table tmp;

Query OK,  rows affected (0.01 sec)