CODEWITHSUNDEEP
csvubuntu-12.04mysql-workbench
Sakeer
Sakeer

Reputation: 2006

importing .sql3 and csv file into mysql workbench

This is may be foolish question. But i cant find the answer of this problem anywhere.

i have a .sql3 and a .csv file i want do import functionality in my mysql workbench using any of these file.

right now i dont have any tables and shemas in my mysql

when i am importing my demo.csv or demo.sql3 files in my workbench its showing an error like

ERROR 1064 (42000) at line 1: 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 'SQLite format 3' at line 1

I am on ubuntu

can anyone help me out from this problem

thanks in advance

Upvotes: 1

Views: 777

Answers (1)

Mike Lischke
Mike Lischke

Reputation: 53307

For reading csv data into MySQL LOAD DATA is probably the best way to go. There's a plugin in MySQL WOrkbench for importing CSV data but it requires an existing result set.

Upvotes: 1

Related Questions