SQL Practical Guide

Search

SNOMED CT Document Library

    Loading...

Page tree

Versions Compared

Old Version 1

changes.mady.by.user David Markwell

Saved on

compared with

New Version Current

changes.mady.by.user Jon Zammit

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

In future when you open MySQL Workbench you will see the the option to open the SNOMEDCT connection.

...

You can run your SQL queries in MySQL Workbench as descripted described in the previous section. Additionally these queries can be run using the MySQL command line interface or through a MySQL connector for one of the programming languages listed at: https://dev.mysql.com/downloads/.

Warning

If you are using example queries as templates for your own queries alway copy the query first so that you do not overwrite the original example query.

  • If you accidently accidentally overwrite an example query, you can download the SnomedRfsMySql.zip file again and extract the example queries folder.

...

The "root" user account is typically used for importing the SNOMED CT release files. However, you should create additional MySQL accounts for database users that do not have administrator rights. Ideally the name of these MySQL accounts should match the Mac username of the user as this simplifies call the the mysql command line tool and the use of MySQL connectors.

...