"Shoot yourself in the foot" means "to do or say something that causes problems for you". Example: When Michelle got drunk before her final exam, she shot herself in the foot. She failed the test!