Regardless you choose an individual mattress, single, double sized mattress, you should match the size of the mattress with the size of the tent and the number of people who will be on the same mattress.
Many of the single mattresses are a one-chamber bladder designed to simply elevate the camper from the ground. Getting one small hole in this type of mattress will result mattress deflated and you have to sleep on a piece of plastic on the ground.
Camping air mattress that has multiple chambers is the best type of them, since that type allows the mattress to remain essentially inflated is. Using this mattress, you can still use it even if there is a hole in one of the chambers.
Before going, you need to prepare how the camping air mattress will be inflated. While some campgrounds have air compressors for just that reason, many do not. Besides, lugging a large air mattress to the dedicated compressor and back can be a trial of its own. You can consider bringing a foot pump, since it makes inflating a camping air mattress easier and will not require someone to manually inflate one by blowing into it for hours.
You can find many tire inflators that plug into the 12-volt power plug in most vehicles. Many of these pumps can be connected to a camping air mattress and inflated in minutes. For larger mattresses, 120-volt pumps are available and if the campsite being used is equipped with electricity, they can make short work of inflating the camping air mattress.
You also need to ensure that you have already checked out the area for sharp objects that can puncture the outside allowing air to escape throughout the night, before placing the mattress on the ground. You should avoid a place with many rocks around it to place your air mattress. Even if you sleeping on a camping air mattress, if it is set on a large rock it can still make for an uncomfortable night. Also avoid placing an air mattress on plastic as it can slide as though it were sitting on ice.
Many types of camping mattresses are available nowadays. Most of camping air mattress that is coated on one side with flannel or other cloth is more comfortable than the one made from the plastic or rubber mattress. You also have to remember to bring a sleeping bag or some blankets to lay on top of the mattress to prevent muscle pain from sleeping directly on the cold mattress.