How did the people of Spain feel about the War of Spanish Succession?

I'm Spanish, and I don't give a f*ck about it. But, according to my history book, people felt so bad. That's all, sorry, don't have time to make a long answer.