How to import Ms.Access True/False Format to MySQL via /r/learnprogramming


How to import Ms.Access True/False Format to MySQL

I got some information that True in Ms.Access is considered as -1 instead of 1. For other format such as date, number, etc, I can use LOAD DATA INFILE to import the .csv file (exported from ms.access table) to MySQL. But, for the True/False (appears as checkbox in Ms.Access), it cannot be read by MySQL. Any solution about this problem?

Submitted July 17, 2017 at 09:46PM by epstanza
via reddit http://ift.tt/2u3yibS

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s