mysql database replication : How To Step by Step: master -slave replication

Here we will help you to setup master-slave replication between MySQL servers. Setup Details: Master Server: 10.0.10.12 Slave  Server: 10.0.10.18 Database: empmaster 1. Setup MySQL Master Server Create an mysql account on Master server with REPLICATION SLAVE privileges to which replication client will connect to master. Block write statement on all the tables, so not … Read more

JOINs in MySQL and Other Relational Databases

INNER JOIN (or just JOIN) The most frequently used clause is INNER JOIN. This produces a set of records which match in both the user and course tables, i.e. all users who are enrolled on a course: SELECT user.name, course.name FROM `user` INNER JOIN `course` on user.course = course.id; LEFT JOIN What if we require … Read more

Fundamental Rights : Power point presentation

Click here to download ppt. Fundamental rights Download Now  

Top 10 Mobile Game : Top android games

1. Dots (free) Proving the notion that simpler is better on mobile, Dots is stupidly, almost patronisingly simple, with players just drawing lines between coloured dots. Link them up and, as coloured things tend to do in games, they disappear, So more fall in. And it carries on like this, getting more and more compulsive as you … Read more