merge multiple sql files into single sql file with new line in Windows

Asked May 13 '22 at 10:53

Active May 17 '22 at 10:18

Viewed 442 times

I want to merge multiple sql files into single sql file. In windows terminal I am using below type command which is working fine. But during merge i need to add new line space after every file but dont know how to do it. Is there any option in type command or do i need to use any other command ?

type *.sql > TRT.sql

edited May 17 '22 at 10:18

asked May 13 '22 at 10:53

Andrew

3,632
24
64
113

Should use loop https://stackoverflow.com/questions/2591758/batch-script-loop – Nikolai Shevchenko May 13 '22 at 11:13
@NikolaiShevchenko i still dont understand in loop what command i have to use to add new line space after each file merge – Andrew May 17 '22 at 10:18
Maybe `echo '' >> TRT.sql` on each iteration? – Nikolai Shevchenko May 17 '22 at 10:21
@NikolaiShevchenko can you please tell the complete command which i can test ? sorry i am very much new to this terminal command .. – Andrew May 17 '22 at 14:42

merge multiple sql files into single sql file with new line in Windows

0 Answers0