SQL and Extra Commands

VanadiumDB accepts the MariaDB / MySQL SQL variant.

Most of the common commands are avaiable

User Management

Users are created without a hostname like @localhost:

CREATE USER supernewuser IDENTIFIED BY 'pass234aasdf32324word';
GRANT CREATE, SELECT ON default.art TO supernewuser;
REVOKE * ON *.* FROM supernewuser;
DROP USER supernewuser;

Extra Commands

• OPTIMIZE TABLES; --> Frees up space and removes the undo stack.
• SELECT * FROM home/mytable; or SELECT * FROM home.mytable; witches to database home automatically like USE home;
• ROLLBACK; Is not extra command it self but it is more powerful. You reanimate deleted users and get deleted databases back.
• Error messages --> Provide you help when you have a broken syntax

Datatypes