dolt table importcommand.
csvfiles without a defined SQL schema. Consider the following csv file:
CREATE TABLESQL statement. You can also specify a schema for a csv file. Let's walk through the following file.
mysqldumpprogram. Let's say you have MySQL server with the following configuration
file.pgdumpyou can convert it into a mysql dump as follows.
dolt table import. Consider the following excel file:
dolt table import -c --pk=id employees employees.xlsxto load the excel file into our Dolt. Be sure to give the same name for the table as the spreadsheet's name.
to_sqlfunction. We can then use the read_sql function to read back data from our MySQL database into Dolt.
dolt table import.