New answers tagged

1

You can concatenate output to CSV, like select email || ',' || firstname from account with column header turned off using set heading


1

As @Rick James has already said CREATE TABLE ... with the columns approximating the Excel columns. LOAD DATA LOCAL FILE ... into that table in MySQL. I am just goin to explore a bit more. I am writting the steps by steps the procedure based on (SQLyog,MySQL Workbench) tool . How you shall import excel file or CSV file into Mysql DB. 1) ...


1

This issue has been dealt with here. The approach described therein assumes that you have already separated your schema dump by filename. However, if I've understood you correctly, you have a schema dump from which you wish to extract a single file? I have written a small tool which extracts individual table data separately from a schema dump file. It's ...


1

This is possible using piecemeal restore. The source database's objects and filegroups have to be organised in a way that supports this. The RESTORE requires additional specific keywords. While the concept may take a little bit of getting used to, the amount of scripting to implement is no more than that for other solutions suggested.



Top 50 recent answers are included