Posts Tagged ‘Database’

Drupal 6 installation problem stopped on database configuration settings step

Wednesday, March 18th, 2009

Today when I tried to install drupal but the installation wizard couldn't continue.

Solution:
Edit /sites/default/settings.php and change

$db_url = 'mysql://username:password@localhost/databasename';

to the actual db settings and then reload the page (CTRL+R) or press F5 in your browser.

Good Luck

How to increase a database table column value in Zend Framework

Saturday, February 28th, 2009

... in a class extending Zend_Db_Table

$db = $this->getAdapter();
....
$db->update('table', array('views' => new <strong>Zend_Db_Expr</strong>("views + 1")), 'id = ' . $id);
....

MySQL Stored Procedure: Hello World

Thursday, November 27th, 2008

If you always wanted to see Hello World in a MySQL stored procedure now is the time.

[code]
DROP PROCEDURE IF EXISTS sp_hello_world;
CREATE PROCEDURE sp_hello_world() SELECT 'Hello World';
[/code]

For some strange reason Wordpress removes my formatting after the image above.

Why software try to be smart ? :D