Add value in DB table (Migration)

Question

I need to insert a value into the database. The table already exists, just insert one more

And I need Insert 9 newcode newcode_title I created new file

mysql4-upgrade-0.7.9-0.8.0.php

And it includes

<?php

$installer = $this;

$installer->startSetup();

???????????
$installer->endSetup();

Answer 1

You can try:

$installer->startSetup();
$installer->getConnection()->addColumn($installer->getTable('[YOUR TABLE]'),'new_column', array(
'type'      => Varien_Db_Ddl_Table::TYPE_TEXT,
'nullable'  => false,
'length'    => 255,
'after'     => null,
'comment'   => 'New column'
)); 
$installer->endSetup();

EDIT:

To insert data to your table you must create a model in your module and call the save action:

$model = Mage::getModel('modulename/modelname');
$model->setData($yourData);
$model->save();