**结案。**此问题不可复制或由打字错误引起。它目前不接受答案。
**想改进这个问题吗？**更新问题，使其成为堆栈溢出的主题。

两年前关门了。
改进这个问题
我试着找出问题所在。但不幸的是我不能。插入表行中的错误显示为=您的sql语法有错误；检查与mysql服务器版本相对应的手册，以获得正确的语法，以便在第1行的“course\u credit”列附近使用，第21行的“course\u credit”列的数据也被截断。蒂亚。

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');