import sqlite table into mySQL database

Question

i am trying to import data from a table in sqlite onto a mysql table :

U exported the table of sqlite into a csv file. While importing the csv file into the mysql table, ihave the following error :

#1366 - Incorrect integer value: 'IDAPPRECIATIONL' for column 'idAppreciation' at row 1

IDAPPRECIATION is the column of the sqlite database and idAppreciation is the column of the mysql table they are both autoincrement.

Sounds like your CSV file includes the column names as headers and the import doesn't seem to like that. — Matt S
– Matt S, Commented Sep 27, 2012 at 21:21
I explained further in an answer below since I'm pretty sure that's your problem. — Matt S
– Matt S, Commented Sep 28, 2012 at 13:11

Matt S · Accepted Answer · 2012-09-28 13:10:30Z

1

The first line in your CSV file is likely the column names from your sqlite table. Export without the column names or remove that first line. Or during the import choose to skip the first line if you have the option.

answered Sep 28, 2012 at 13:10

Matt S

15.5k6 gold badges60 silver badges79 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

import sqlite table into mySQL database

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related