craig@Emerald:~/Documents/Projects/Amethyst$ ./amethyst
Database connected with test:password
Established link with 'test_db'

Please enter your query:
 > insert into users set username="Snowman", password=MD5(":o"), user_id=1
Query was successful, but there are no results to display.
1 rows were affected.

 > insert into users set username="PhQ", password=MD5("kree"), user_id=2
Query was successful, but there are no results to display.
1 rows were affected.

 > select * from users
<table>
<tr><th>user_id</th><th>username</th><th>password</th></tr>
<tr><td>1</td><td>Snowman</td><td>3d92545d1f254a341e34350cbfbf4a7f</td></tr>
<tr><td>2</td><td>PhQ</td><td>0c6152c059221670ccfa4eceb4061acb</td></tr>
</table>

 > delete from users
Query was successful, but there are no results to display.
2 rows were affected.

 > select * from users
<table>
<tr><th>user_id</th><th>username</th><th>password</th></tr>
</table>

 >