Search In
Following is a list of best practices for SQL Server
1) Use correct formatting
Following is a sample select query for reference:
SELECT
X.column1,
HABTM association is used when you have two models that need to be joined up, repeatedly, many times in many different ways.
So below is the following steps to follow to use the above relationship. First we create the database and its tables
The Tab
Hi Friends.
In this blog, I'm going to explain how you can create Transformations in Pentaho Spoon. I shall Extract data from a DBF file, will apply simple (no) Transformation and Load into MySql database. Pentaho comes with different components
To take backup of MySQL database only you need to execute the following command:
mysqldump -u [username] –p[password] –no-create-info [database_name] > [dump_file.sql]
Here, we will use the –no-create-info to take data backup only.
This blog will help you to understand how to install securely phpMyAdmin to manage your databases on Ubuntu 14.04
How to install phpMyAdmin:
Step 1: First you need to update the package index on your server with this command:
Now write t
There are a plethora of PHP frameworks available today. They are suitable to develop a web application for any business. Choosing the best PHP framework can be a tough task. It is due to so many available options. Laravel is among the most popular fr
Consider the following scenario.
Let us say we have a User model and users ,its corresponding table in the database has a column role_id along with other columns.
During the time of the attachment of the role_id to users table ,we could have writte
Hello Reader's if your making the parent child relationship then this blog is very helpful to you. Here we are making parent child tree by using the Iteration functions. The output of this will a tree which showing the childs on branches and pare
Forget Password function use in cakePhp for making it secure by sending the code to the database in encrypted form, and fetch the value from by using find keyword in the list, this will give you detail on the bases of email id.
Forexample: A us
Easy way to install cakephp:
Hello Readers. Here is small blog on how to install cakephp. Cakephp is very fast and easy to install. The minimun requirements to install cakephp are a web server and a copy of cakephp.
Step 1
