## sql.sl

creates syntax tables for SQL language. It supports most of the keywords defined in the following SQL variants: Sql92, Sql99, PostgreSql, MySql, MS SQL, Oracle PL/SQL. Each language variant has it's own set of keywords.

The comments are highlighted the same in all SQL variants:

      /*
        Multiline Comment
      */

      -- End Of Line comment

If a mode should support different comments, please report.

### Installation

Put the file somewhere on your jed_library_path and

       autoload ("sql_mode", "sql");
       autoload ("sql92_mode", "sql");
       autoload ("sql99_mode", "sql");
       autoload ("mssql_mode", "sql");
       autoload ("mysql_mode", "sql");
       autoload ("pgsql_mode", "sql");
       autoload ("orsql_mode", "sql");
       add_mode_for_extension ("sql", "sql");

in your .jedrc file.

When you open a file with the `.sql` extension, the function `sql_mode()` will be called which defaults to "sql92". If you wish to use a different default mode you can define the custom variable `sql_default_mode` in the .jedrc file:

       variable sql_default_mode = "mysql";

Now all files with the `.sql` extension (and without a mode defined in the 'modeline') will be treated as MySql files.

If you edit a file that has a syntax different than the default, you can use the modeline (a comment at the beginning of the file) to select the appropriate mode:

      -- -*- mode: pgsql; -*-

The file will be treated as a PostgreSql file.