Step 2: Load company profile data
Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
Download companylist.company
table by either using a MySQL client (such as Sequel Pro, MySQLWorkbench) or by using the LOAD DATA command.
If you are using a MySQL client, open your MySQL client and navigate to the menu item for importing data from a file.company
table.
If you are using a terminal, run the LOAD DATA
command to load the data into the company
table.
LOAD DATA INFILE '/tmp/companylist.csv'INTO TABLE companyFIELDS TERMINATED BY ',' ENCLOSED BY '"'LINES TERMINATED BY '\r\n'IGNORE 1 LINES;
Last modified: April 29, 2025