Windows: Sourcing SQL Files

[Stabones]

So, there are a lot of files to source...

source a.sql
source b.sql

...


source zz.sql

No thanks.

For future sourcing, use:

copy /b *.sql all_files.sql

This will take all .sql files in the directory and concatenate them into one. Want to pick and choose what to source? Select all .sql files you are interested in, copy them to a temp folder, and then run the copy command above!

Stabones

[sorvani]

There are like two things to source.

[Stabones]

Not when you do proper source control

[lerxst2112]

for %i in (*.sql) do mysql -uroot -ppassword peq < %i

[Stabones]

Originally Posted by lerxst2112

for %i in (*.sql) do mysql -uroot -ppassword peq < %i

Always good to see other solutions.

Cheers!