Code Monkey home page Code Monkey logo

mysql_csv_importer's Introduction

MySQL CSV Importer

A tool for importing multiple Comma-Separated Values (CSV) files into MySQL. Written in C#
Also comes with an HTML parser to convert HTML tables into usable CSV files.

Usage

To use the importer, extract the .zip file from the Releases page and place all of your .csv files in the same location as the csv_importer.exe. Next, simply run the csv_importer.exe file and enter information when prompted, the rest will be done for you.

To use the parser, extract the .zip file from the Releases page and run the html_parser.exe. Then, copy and paste any HTML code into the displayed text box and save the generated .csv file wherever you like.

Data Types

Data resembling a whole number will be treated as INT
Data resembling a decimal number will be treated as DOUBLE

Data in the format of YYYY/MM/DD will be converted to YYYY-MM-DD
Data in the format of YYYY/MM/DD HH:MM:SS will be converted to YYYY-MM-DD HH:MM:SS

Data in the format of YYYY-MM-DD will be treated as DATE
Data in the format of YYYY-MM-DD HH:MM:SS will be treated as DATETIME
Data in the format of YYYYMMDDHHMMSS will be treated as TIMESTAMP
Data in the format of HH:MM:SS will be treated as TIME

Data equal to NULL will remain as NULL

Any other type of data will be treated as TEXT

Credits

The CSV Importer uses MySql.Data by Oracle
The HTML Parser uses AngleSharp by Florian Rappl

mysql_csv_importer's People

Contributors

1054009 avatar

Stargazers

 avatar

Watchers

 avatar

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    ๐Ÿ–– Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. ๐Ÿ“Š๐Ÿ“ˆ๐ŸŽ‰

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google โค๏ธ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.