HomeForum
Welcome, Guest

Loading data into MySql
(1 viewing) (1) Guest
  • Page:
  • 1

TOPIC: Loading data into MySql

Loading data into MySql 2 years, 12 months ago #648

  • Pint
  • OFFLINE
  • Fresh Boarder
  • Posts: 2
  • Karma: 0
Hello

I am trying to load data into MySql Database using Advanced ETL Processor

And I am getting the following error message invalid sintax please check the user manual

What I am doing wrong?

Asef

Re:Loading data into MySql 2 years, 11 months ago #652

  • admin
  • OFFLINE
  • Moderator
  • Posts: 2183
  • Karma: 12
Can you try setting SET GLOBAL sql_mode = 'ANSI' in sql before

dev.mysql.com/doc/refman/5.1/en/ansi-mode.html


Mike

Re:Loading data into MySql 2 years, 11 months ago #654

  • Pint
  • OFFLINE
  • Fresh Boarder
  • Posts: 2
  • Karma: 0
Working fine now!

Thank you
  • Page:
  • 1
Time to create page: 0.16 seconds

Testimonials

"The DBSL Integration solution eliminated our data access bottle neck that previously impeded company growth. We are now able to provide solutions to long standing problems areas such as automated order processing and business reporting limitations. Additionally the solution allows for new opportunities to simply hook-on to our existing data sources. From development through testing the DBSL support  team continues to be helpful, resourceful and responsive to our company needs."

John Kil,
IT Manager

User Login

You only need to log in or register to use our support forum



Our customers

BP

BBC

HSBC


Databases we work with

Go to top