How to set inventory of all product in magento

The inventory is kept in the table cataloginventory_stock_item. The column you are looking for is qty.

Run this query:

UPDATE `cataloginventory_stock_item` SET `qty` = 100;

But make sure to take backup of this table first.

This will increase the qty 100 to all products.