How to use views in mysql

Bug Tracker

How to use views in mysql 01Aug, 2014

How to use views in mysql

Views are the stored queries which produce results on being invoked. A view act as the virtual table or the prepared SQL statement. Available in MySQL Server 5.0, the view help in retrieving the data faster because you don’t have to perform joins and incorporate functions in your queries. Just create views for the data you require and see the action being performed by itself whenever the  insert, update and delete function is performed in the table. Once created, views update the data automatically. Example: Here I am going to create one table where I will store the data related to video rating and store rating calculation in view. This is done to reduce the complications of the user,by using…

CakePHP not working – cake.generic.css not found in Ubuntu 03May, 2011

CakePHP not working – cake.generic.css not found in Ubuntu

If you have done all the things right in installation of cakephp on Ubuntu system as per specified in various sites and have made changes in apaches settings but still cakephp is not working on Ubuntu then try uncommenting the Configure::write(‘App.baseUrl’, env(‘SCRIPT_NAME’)); line in core.php of cakephp installation.

Posted in: Bug Tracker
Installing and Configuring Mantis Bug Tracker 09Jan, 2010

Installing and Configuring Mantis Bug Tracker

Step by step instructions on installing and configuring Mantis on your system: Installing Mantis Download latest version of mantis from http://www.mantisbt.org/download.php. The first thing to do is to unzip the downloaded file, keeping the directory structure intact. The next step is to move that Mantis root directory to “c:inetpubwwwrootmantis” (assuming that the root directory of your http server is “c:inetpubwwwroot”). The last thing to do to make sure that you have a minimal installation working is to copy the file mantis/root/mantis/config_inc.php.sample to mantis/root/mantis/config_inc.php First Mantis Test Point your browser to http://localhost/mantis/admin/check.php or http://localhost/mantis/root/mantis/admin/check.php You should get a diagnostics page that shows colored boxes, with all of them green, except for the first one. You should have red ( BAD )…

Posted in: Bug Tracker