This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
how_to:writesqlqueries [2010/01/04 17:22] 132.168.74.230 |
how_to:writesqlqueries [2010/01/04 17:35] 132.168.74.230 |
||
---|---|---|---|
Line 1: | Line 1: | ||
====== How to write SQL Queries to explore database ====== | ====== How to write SQL Queries to explore database ====== | ||
- | Once you are opened an [[how to:how_to:opensession|MSI session]], you can explore the database by creating SQL queries. Information on MSI database and its model is available [[http://biodev.extra.cea.fr/docs/irma/doku.php?id=msidb| here ]]. | + | Once you are opened an [[how to:opensession|MSI session]], you can explore the database by creating SQL queries. Information on MSI database and its model is available [[http://biodev.extra.cea.fr/docs/irma/doku.php?id=msidb| here ]]. |
- | You can create new SQL files from hEIDI project (''File > New File'' menu then choose ''Empty File'' or directly ''New Empty File'' from hEIDI Project window) . It is also possible to select a Table under database connection and choose ''Veiw Data''. | + | To create a new SQL file from an hEIDI project, select the ''File > New File'' menu, then choose ''SQL File'' under the ''Other'' Category.\\ |
+ | It is also possible to view data from a table like this:\\ | ||
+ | * In the ''Services'' Window, select a database connection | ||
+ | * Expand the schema node of your choice, then the ''TABLES'' node | ||
+ | * Select a table, riggt-click and choose ''View data'' | ||
{{:sql_comment.png|}} | {{:sql_comment.png|}} |