dolt table import
command.csv
files without a defined SQL schema. Consider the following csv file:dolt table import
documenation for additional ways to modify your database such as updating or replacing your existing data.CREATE TABLE
SQL statement. You can also specify a schema for a csv file. Let's walk through the following file.LOAD DATA
command to work with data that is compatible with the LOAD DATA api. For example you can load the above file.csv
as follows:mysqldump
program. Let's say you have MySQL server with the following configurationtest
as follows:file.pgdump
you can convert it into a mysql dump as follows.dolt table import
. Consider the following excel file: employees.xlsx
dolt table import -c --pk=id employees employees.xlsx
to load the excel file into our Dolt. Be sure to give the same name for the table as the spreadsheet's name.to_sql
function. We can then use the read_sql function to read back data from our MySQL database into Dolt.dolt table import
.