USE

The USE statement tells MatrixOne to use the named database as the default (current) database for subsequent statements.

Description

The USE statement tells MatrixOne to use the named database as the default (current) database for subsequent statements.

Syntax

> USE db_name

Examples

DROP DATABASE IF EXISTS use_database_demo;
CREATE DATABASE use_database_demo;
USE use_database_demo;

CREATE TABLE mytable (id INT);
INSERT INTO mytable VALUES (1), (2), (3);

SELECT COUNT(*) FROM mytable;

DROP DATABASE use_database_demo;