Translate into your language!

SQL Interface


This function is intended only for power users who know SQL (Structured Query Language)! Because you have full control over the database using this interface, it is easy to inadvertently corrupt the database. You cannot "undo" any action.

Lotto Sorcerer's SQL database is a SQLite database; see the SQLite web site (at for full information and syntax.

How to Invoke

Use the menu item "Utilities > Database Utilities > SQL Interface" .

Basic Procedure

Window Controls

"Select Lottery" dropdown menu

Use this dropdown to select the lottery that you want to work with.

"Refresh" button

If you executed a SQL command that changed the data, clicking this button will refresh the view of the table.

"SQL Command" combo box

Enter the SQL command or statement you want to execute in this box.

"Export" button

This will export the results as a Microsoft Excel spreadsheet.

"Copy" button

This will copy the results to your System Clipboard.

"Save" button

This will save the results to a text file.

"Execute" button

This will execute the SQL command you typed in the command box.

"Paste" button

This will paste all text from your System Clipboard into the SQL Command combo box


When you select the lottery in the top dropdown, the name of the table will be shown at the top-right of the window.

Successfully executed SQL statements will be "remembered" and displayed in the SQL Command text box as long as you have Lotto Sorcerer running. Use the dropdown to recall these statements.