Code Mirror is not working with SQL

I have used code mirror to have syntax highlighting on “xml” editor, however, I am trying to implement SQL code highlighting by using these examples. [Example 1][1] and [Example 2][2]

I have used a text area and script as shown below:

<script type="text/javascript" src="/Users/userName/Desktop/codemirror-5.9/lib/codemirror.js"></script>

<textarea id="editor">
Select * from random_table;     

<script text="text/javascript">
    var editor = CodeMirror.fromTextArea(document.getElementById("editor"), {
               lineNumbers: true,
               height: "450px",
               parserfile: "/Users/userName/Desktop/codemirror-5.9/contrib/sql/js/parsesql.js",
               stylesheet: "/Users/userName/Desktop/codemirror-5.9/css/sqlcolors.css",
               path: "/Users/userName/Desktop/codemirror-5.9/lib/",
               textWrapping: true

I have attached my file structure;

I am not sure what exactly I am missing here.Thanks for reading.

You seem to be basing the options you’re passing on an example for CodeMirror 1.0. Read the current manual to find out how to configure version 5.

Oh Wow, I just checked that documentation of version 5 and it worked for me.
Thank you so much. Really Appreciate it.