xlsx2mysql: An tool of helping your fastly generate SQL from Excel.

Last update: Nov 13, 2021

Comments: 0

xlsx2mysql

An tool of helping your fastly generate SQL from Excel

中文文档

Origin

In order to convert Excel to MySQL and I made a tool to implement.But Why do I write it? because I find a round tools that it still not satisfy my needs.Then it was born.

Install

Install from source

xlsx2mysql Requires Go >= 1.16. You can build it from source:

$ go get -u -v github.com/ToWeLong/xlsx2mysql

Install pre-build binariy

Pre-built binaries are available here: release

Usage

Generate to sql

$ xlsx2mysql generate example.xlsx

Interface

Help

An tool of helping your fastly generate SQL from Excel.

Usage:
  xlsx2mysql [command]

Available Commands:
  completion  generate the autocompletion script for the specified shell
  generate    generate SQL from Excel
  help        Help about any command

Flags:
  -h, --help   help for xlsx2mysql

Use "xlsx2mysql [command] --help" for more information about a command.

License

MIT

Owner

WeLong

There is not much to learn, just use your heart.

https://github.com/ToWeLong/xlsx2mysql

Similar Resources

OctoSQL is a query tool that allows you to join, analyse and transform data from multiple databases and file formats using SQL.

OctoSQL OctoSQL is a query tool that allows you to join, analyse and transform data from multiple databases, streaming sources and file formats using

Dec 29, 2022

CLI tool that can execute SQL queries on CSV, LTSV, JSON and TBLN. Can output to various formats.

trdsql CLI tool that can execute SQL queries on CSV, LTSV, JSON and TBLN. It is a tool like q, textql and others. The difference from these tools is t

Jan 1, 2023

WAL-G is an archival restoration tool for PostgreSQL, MySQL/MariaDB, and MS SQL Server (beta for MongoDB and Redis).

Jan 1, 2023

MSSQLDecryptor - Small and simple tool for decrypting encrypted views, functions and stored procdeures in Microsoft SQL Server

MSSQLDecryptor small and simple decryptor for encrypted objects in Microsoft SQL

Mar 7, 2022

Mergestat - a command-line tool for running SQL queries on git repositories and related data sources

Query git repositories with SQL. Generate reports, perform status checks, analyze codebases. 🔍 📊

Dec 30, 2022

Go package for sharding databases ( Supports every ORM or raw SQL )

Octillery Octillery is a Go package for sharding databases. It can use with every OR Mapping library ( xorm , gorp , gorm , dbr ...) implementing data

Dec 16, 2022

Prep finds all SQL statements in a Go package and instruments db connection with prepared statements

Prep Prep finds all SQL statements in a Go package and instruments db connection with prepared statements. It allows you to benefit from the prepared

Dec 10, 2022

🐳 A most popular sql audit platform for mysql

Jan 6, 2023

sqlx is a library which provides a set of extensions on go's standard database/sql library

sqlx is a library which provides a set of extensions on go's standard database/sql library. The sqlx versions of sql.DB, sql.TX, sql.Stmt, et al. all leave the underlying interfaces untouched, so that their interfaces are a superset on the standard ones. This makes it relatively painless to integrate existing codebases using database/sql with sqlx.

Jan 7, 2023

Dumpling is a fast, easy-to-use tool written by Go for dumping data from the database(MySQL, TiDB...) to local/cloud(S3, GCP...) in multifarious formats(SQL, CSV...).

?? Dumpling Dumpling is a tool and a Go library for creating SQL dump from a MySQL-compatible database. It is intended to replace mysqldump and mydump

Nov 9, 2022