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:35] 132.168.74.230 |
how_to:writesqlqueries [2010/02/03 11:02] 132.168.74.230 |
||
---|---|---|---|
Line 3: | Line 3: | ||
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 ]]. | 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 ]]. | ||
- | To create a new SQL file from an hEIDI project, select the ''File > New File'' menu, then choose ''SQL File'' under the ''Other'' Category.\\ | + | ===== View data from a table ===== |
- | It is also possible to view data from a table like this:\\ | + | It is possible to view data from a table like this:\\ |
* In the ''Services'' Window, select a database connection | * In the ''Services'' Window, select a database connection | ||
* Expand the schema node of your choice, then the ''TABLES'' node | * Expand the schema node of your choice, then the ''TABLES'' node | ||
Line 11: | Line 11: | ||
{{:sql_comment.png|}} | {{:sql_comment.png|}} | ||
- | ===== SQL queries sample ===== | + | ===== Create your own SQL query ===== |
+ | To create a new SQL file from an hEIDI project, select the ''File > New File'' menu, then choose ''SQL File'' under the ''Other'' Category.\\ | ||
+ | Specify a name and a project folder then ''Finish''. An empty SQL file appears on the screen. \\ | ||
+ | Select your database in the droplist at the top.\\ | ||
+ | {{:how_to:sqlquery_choosedb.png|}} | ||
+ | |||
+ | When you query is written, | ||
+ | |||
+ | ==== SQL queries sample ==== | ||
+ | FIXME Add an example here FIXME | ||