title: Syntax error in a compound sql statement around Start Transaction, i guess
body: <p>I am struggling with this compound mysql. I am using the Start Transaction for the first time. So anything will be really helpful.</p>
  
  <pre><code>START TRANSACTION
  INSERT
  INTO
    p_ucourse(
    course_name,
    course_goal,
    course_time,
    course_creator_id,
    course_status
  )
  VALUES(
   'This Course',
   'Goal of this course',
   480,
   1,
   1
  );
  SET
  ucourse_id = LAST_INSERT_ID();
  INSERT
  INTO
    r_ucourse_module(course_id,
    module_id,
    rank)
  VALUES(ucourse_id, 1, 1);
  
  INSERT
  INTO
    r_ucourse_eu(
    course_id,
    lu_id,
    rank,
    afterclass
    )
  VALUES(ucourse_id, 1, 1, 0);
  COMMIT
  </code></pre>
  
  <p>And it throws up the following error:</p>
  
  <pre><code>#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'INSERT
  INTO
    p_ucourse(
      course_name,
      course_goal,
      course_time,' at line 2
  </code></pre>
  
  <p>I am not being able to get the syntax of the thing.</p>