USE

The USE statement selects a current database for the user session.

Synopsis

UseStmt

USE - 图1

DBName

USE - 图2

  1. UseStmt ::=
  2.     "USE" DBName
  4. DBName ::=
  5.     Identifier

Examples

  1. mysql> USE mysql;
  2. Reading table information for completion of table and column names
  3. You can turn off this feature to get a quicker startup with -A
  5. Database changed
  6. mysql> SHOW TABLES;
  7. +-------------------------+
  8. | Tables_in_mysql         |
  9. +-------------------------+
  10. | GLOBAL_VARIABLES        |
  11. | bind_info               |
  12. | columns_priv            |
  13. | db                      |
  14. | default_roles           |
  15. | expr_pushdown_blacklist |
  16. | gc_delete_range         |
  17. | gc_delete_range_done    |
  18. | global_priv             |
  19. | help_topic              |
  20. | opt_rule_blacklist      |
  21. | role_edges              |
  22. | stats_buckets           |
  23. | stats_feedback          |
  24. | stats_histograms        |
  25. | stats_meta              |
  26. | stats_top_n             |
  27. | tables_priv             |
  28. | tidb                    |
  29. | user                    |
  30. +-------------------------+
  31. 20 rows in set (0.01 sec)
  33. mysql> CREATE DATABASE newtest;
  34. Query OK, 0 rows affected (0.10 sec)
  36. mysql> USE newtest;
  37. Database changed
  38. mysql> SHOW TABLES;
  39. Empty set (0.00 sec)
  41. mysql> CREATE TABLE t1 (a int);
  42. Query OK, 0 rows affected (0.10 sec)
  44. mysql> SHOW TABLES;
  45. +-------------------+
  46. | Tables_in_newtest |
  47. +-------------------+
  48. | t1                |
  49. +-------------------+
  50. 1 row in set (0.00 sec)

MySQL compatibility

The USE statement in TiDB is fully compatible with MySQL. If you find any compatibility differences, report a bug.

See also