This Code:
$mageFilename = 'app/Mage.php';
require_once $mageFilename;
Mage::setIsDeveloperMode(true);
ini_set('display_errors', 1);
error_reporting(E_ALL & ~E_NOTICE);
umask(0);
Mage::app('admin');
Mage::register('isSecureArea', 1);
Mage::app()->setCurrentStore(Mage_Core_Model_App::ADMIN_STORE_ID);
//your mage code here
If Primary key is set to Auto-increment, there are chances that you would not want to provide its value in insert query.
Here is how to do it in MySQL:
INSERT INTO table_name VALUES (NULL, 'column b', 'col c');
Assumption^: The first column is the primary key set to AI
Similarly you can skip columns for other non-required data:
INSERT INTO table_name(col b,col c) VALUES ('column b', 'col c');
Mage::app()->getCacheInstance()->flush();