This shows you the differences between two versions of the page.
Both sides previous revision Previous revision | |||
sqlqueries [2010/01/04 17:14] 132.168.74.230 effacé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 ** | ||
- | |||