git - gitignore - only include certain extension except for filename

Question

I have sql- and bat-files in a folder:

ARCHIVE
log.txt
file_1.sql
file_2.sql
file_3.bat
file_4.bat
password.bat
.gitignore

I now want to push all *.sql-files and *.bat-files to a gitlab project except for password.bat, because that is where the password is stored. Is that even possible? My .gitignore looks like this:

*
!*.sql
!*.bat
password.bat

but that does not work. I also tried !!password.bat, but also failed. It seems after a negation ! there is no way to exclude files again. Does anyone have an idea?

Thanks!

question from:https://stackoverflow.com/questions/65830290/gitignore-only-include-certain-extension-except-for-filename