SQLTeam.com | Weblogs | Forums

1064 - You have an error in your SQL syntax


#1

Please help, I get the following error message:

1064 - 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 'test name', '1239', '', '', 'Albanian', '', '', 'Academic Year', '1', '4', '', '' at line 1

here is my code:

INSERT INTO courses ( duration, important_information, terms, exam_board_fee, how_to_apply, special, special_home, special_home_message, special_home_finish, domains, application_form, is_interview_required, allow_direct_payment, name, school_id, related, ranking, language, type_old, course_type_id_old, type, course_type_id, sector_id, certificate_received, frequency, delivery_method, tefl_level, duration_tefl, duration_type_tefl, quality_assurance, external_validation, dialect, min_age, max_age, average_size, min_size, max_size, course_material, material_info, level_changes, content, text_books, nationalities, comments, inclusive, transfer_inclusive, average_price, active, vatable, commission_info, commission_course, course_linked_id, course_help_for_jobs, language_id, courses_percentage_recommended, cactus_name,cactus_name_english,cactus_name_spanish,class_time,class_time_english,class_time_spanish,description_english,description_spanish,updated, created ) VALUES ( '0', '', '', '', '', '', '', '', '', '[CL]''''[SGA]'', '', '', '', 'test name', '1239', '', '', 'Albanian', '', '', 'Academic Year', '1', '4', '', '', '', '', '', '', '', '', '', '16', '100', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '','test','test','','','','','description', '', '2015-06-16 11:02:25', '2015-06-16 11:02:25')

#2

Sorry, this is a Microsoft SQL Server site.


#3

I figured it out, I needed to delete the '''' from the domains: '[CL]''''[SGA]'',