Javaquery.com

Introduction This article describes an implementation of multi-tenancy using Yii and MySQL. “Multi-tenancy” is but one (and crucial) aspect of SaaS applications; refer to the IBM document Convert your web application to a multi-tenant SaaS...

I have a concern with four mysql tables: "users, sections, products(fullext) and content(fulltext)". "Users" table store the personal information of each registered users like City -> "users.city". "Sections" table are for separate the content of...

The previous day How to create REST API for Android app using PHP, Slim and MySQL – Day ⅓, we have learned fundamental concepts about REST API and preparing your development environment ready by installing the required tools needed....

We are designing a DB for a limited functionality social networking application. Users (Registered Users), Retail Outlets, etc are several entities we need to store. We need to store Address of each of these entities. Also we need to store latitude and...

In this article i'm going to explain "How to delete multiple records from different tables based on parent table in sql server" as i shown in above image. First we need to create this 3 tables i.e { User Table , Fruit Table and UserFruitMapping Table...