mysql - Use sed/awk/grep to change order of a sentence -

mysql - Use sed/awk/grep to change order of a sentence -

i'm trying convert mssql .sql file mysql syntax file. have managed alter of syntax using basic find/replace, need alter ordering of words in line. statements :

alter table add together index index_name on table_name(column_name)

and want right statements format(mysql syntax) :

alter table table_name add together index index_name(column_name)

there 70 statements of sort in file.basically, table_name has shifted between on , (, , set in between table , add. possible using sed/awk/grep?

the next works in sed illustration input:

sed 's/\(add index\) \(.*\) on \(.*\)(/\3 \1 \2(/'

mysql awk sed