Search In
While working with a large relational database in rails we come to point where we have to access data from a large number of tables in a single query. Well for this rails provide us with two very powerfull active records methods i.e joins and include
In this web journal, I'll demonstrate to you generally accepted methods to bring the information from the database and showing the got information in the drop down. I do have a database named CakePHP and in that database I have one table named pr
In previous posts we have learned about creating a connection to a MySQL database with procedural and object oriented way, we also learn how to run a query with mysqli. This article demonstrates how to perform different CRUD operations with MySQLi pr
In this era of software development technology, the main concern in development should be the best performance. As we already aware that database is the backbone of any software. So whilst designing the database we need to keep a few things in mind t
There are many ways to restore MSSQL Server database from backup files(.bak) like using tools available in SQLServer Management tools. But we face problems when the backup was not created on the same machine or it was shared by someone else or it wa
Using Vuforia we can scan any label and image from cloud database of Vuforia.
You need to create free developer account there and then you can create your own application.
Then you can create your database in develop tab where you have 2 part
A trigger is SQL code which runs just before or just after an
INSERT, UPDATE or DELETE event occurs on a particular database table.
Creating a Trigger:
Consider we have two tables:
CREATE TABLE `blog` (
`id` mediumint(8) unsigned NOT NULL AU
Successful businesses today are adopting IT solutions to optimize their operations. From personnel management tools, accounting systems, and supply chain management software to security management, IT solutions come in handy.
With digi
Hello Readers
The below is the difference between the static website and the dynamic website:
Static website is a site which is used using HTML. In this each web pages is a static type means separate document there is no use of databases while the
Stored procedure is used to store a SET of SQL statements in database as a compiled form which can be used by different programs. It performs a special task like inserting data into database, deleting records from database or updating an existing rec
