title: what is wrong with my SQL code? It shows Error Code 1064
body: <p>I've tried to find the problem. But unfortunately I can't. The error show in the INSERT TABLE line as=You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near " at line 1 &amp; also Data truncated for column 'Course_Credit' at row 21. TIA.</p>
  
  <pre><code>CREATE DATABASE testDB;
  
  USE testDB;
  
  CREATE TABLE COURSE (
      COURSE_ID VARCHAR(255),
      COURSE_TITLE VARCHAR(255),
      COURSE_CREDIT DOUBLE(255, 2)
  );
  
  INSERT INTO COURSE (COURSE_ID, COURSE_TITLE, COURSE_CREDIT)
  VALUES ('CSE-101', 'Introduction to Computer Systems', '1.00'),
         ('CSE-102', 'Introduction to Computer Systems (Sessional)', '1.50'),
         ('EEE-105', 'Introduction to Electrical Engineering', '2.00'),
         ('EEE-106', 'Introduction to Electrical Engineering (Sessional)', '1.50'),
         ('ME-100', 'Mechanical Engineering Drawing-I', '1.50'),
         ('ME-101', 'Mechanical Engineering', '2.00'),
         ('ME-102', 'Mechanical Engineering (Sessional)', '1.50'),
         ('MATH-101', 'Differential Calculas And Co-ordinate Geometry', '3.00'),
         ('PHY-101', 'Physics', '3.00'),
         ('PHY-102', 'Physics (Sessional)', '1.50'),
         ('CSE-201', 'Structured Programming Language', '3.00'),
         ('CSE-202', 'Structured Programming Language (Sessional)', '1.50'),
         ('CSE-203', 'Discrete Mathematics', '3.00'),
         ('MATH-201', 'Integral Calculus, Differential Equations and Series', '3.00'),
         ('CHEM-201', 'Chemistry', '3.00'),
         ('CHEM-202', 'Chemistry (Sessional)', '1.50'),
         ('ENG-201', 'English', '2.00'),
         ('ENG-202', 'Communication in English (Practice)', '1.00'),
         ('SS-201', 'Government and Public Administration', '2.00'),
         ('CSE-301', 'Object Oriented Programming Language', '3.00'),
         ('CSE-302', 'Object Oriented Programming Language (Sessional)', '1,50'),
         ('CSE-303', 'Data Structures', '3.00'),
         ('CSE-304', 'Data Structures', '1.50'),
         ('MATH-301', 'Complex Variable and Statistics', '3.00');
  </code></pre>