Epitaph Help

Categories

Concepts	Creator Commands	Creator Tutorials	Games	Innate Commands	Known Commands
Lord	Npc	Objects	Playtesters	Rooms	Rules

Sql

Description

This command allows you to connect to the mySQL database and perform SQL queries on it.

Once you are inside the command interpreter, clear allows a query to be cleared, edit enters the editor so you can edit an existing query, and exit is used to exit completely.

Tables will be listed with a starting capital letter, however their name may still be starting with a lowercase letter. So, if the table doesn't react, try lowercase.

Example

> sql epitaph
Welcome to the Epitaph SQL monitor. Commands end with ; .

Type 'help' for help.

sql> select address from Customer_Database where age > 18;

Syntax Forms

sql <database> 

sql <database> -u <user> 

sql <database> -u <user> -p <password>