Using a Digital Camera to record videos, doable idea?

I did something like this once, close-range. But the vid was short, like... 15 seconds short. I'm wondering if the quality would be viewable when uploaded to Youtube, my cam is 9 megapixels. I'm probably going to record some SSBM matches this way temporarily so I can view my own matches and get better by looking at what I did wrong. Does this seem doable? I have a 2 GB SD card in my camera, if you're wondering. Brand is Kodak, meh. Thanks for feedback. Might as well record vids of the cafe I regularly hang out at as well.