SQL syntax

Share your cool Custom SQL reports or Lua scripts with other mmex users

SQL syntax

Postby jaworski_m » Sun May 31, 2009 4:29 am

Hello,
Where can I find table names etc and other detail how to build SQL queries in MMEX?

Thank you.
jaworski_m
New MMEX User
 
Posts: 1
Joined: Sun May 31, 2009 4:24 am

Re: SQL syntax

Postby DickyP » Sun May 31, 2009 7:27 am

The easy way is to download and use a tool such as the standalone 'SQLiteMan' from http://sqliteman.com/ or the Web based addon for Firefox, 'SQLiteManager' from http://www.sqlitemanager.org/ - I use the former normally but both work equally well to investigate the structure of the MMEX SQLite database.

For details of the SQLite flavour of SQL go to http://www.sqlite.org/lang.html.
DickyP
New MMEX User
 
Posts: 13
Joined: Fri May 15, 2009 9:28 am
Location: UK


Return to Custom SQL and Lua Scripts

Who is online

Users browsing this forum: Google [Bot] and 1 guest

cron