This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
sqlqueries [2009/04/23 18:32] 132.168.73.124 créée |
— (current) | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ===== SQL Queries ===== | ||
- | |||
- | Once the connection is successful, the first simple feature is to explore the database or create 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''. | ||
- | |||
- | {{:sql_comment.png|}} | ||
- | |||
- | ** SQL queries sample ** | ||
- | |||