Creating a Database¶
Once you’ve installed SQream you can create a database.
To create a database:
Write a CREATE DATABASE statement.
The following is an example of creating a new database:
master=> CREATE DATABASE test; executed
Reconnect to the newly created database.
Exit the client by typing
\qand pressing Enter.
From the Linux shell, restart the client with the new database name:
$ sqream sql --port=5000 --username=rhendricks -d test Password: Interactive client mode To quit, use ^D or \q. test=> _
The name of the new database that you are connected to is displayed in the prompt.