Why is the "CREATE DATABASE" command not working?

Question

When I try to use SQLSHELL "CREATE DATABASE test". I don't get a prompt that anything was created (not sure if i'm supposed to). Then when I check to see if it was created ("\l"). Nothing is there. What is happening?

Answer 1

You have to terminate SQL commands with ;.

In your case:

CREATE DATABASE test;