[Quick Tip] Splitting SQL into CSV

[Ernestbok]

Saw some people get confused with viewing SQL dump and I have small trick up the sleeves to help

cat FILE.sql | dos2unix -f | gawk -f split.awk


With the split.awk file being this

Please, Log in or Register to view URLs content!

only work with mysql

 

[alazka123]

thanks man!

 

[xdotxonex]

thanks so much

 

[panjis]

Great!

 

[nexos7]

thanks for sharing bro !

 

[GameMasterJ]

THANKS FOR THIS!

 

[lenec]

thanks for this

 

[romankosoj]

the best!

 

[yarrrrak]

thank you so much

 

[nichxlas98]

thanks for this