mysql using JOIN query by three table

mysql using JOIN query by three table :

     SELECT b.`booking_id`, r.`ud_room_id`,r.room_name, u.`name`, u.`contact_no`, u.`designation`, u.`department`, b.`title` , b.`booking_date` , DATE_FORMAT( b.`start_time` , '%H:%i' ) start_time, DATE_FORMAT( b.`end_time` , '%H:%i' ) end_time
    FROM `rbs_room_booking` b
    JOIN `rbs_room` r ON r.`room_id` = b.`room_id`
    JOIN `rbs_user` u ON u.`user_id` = b.`entered_by`
    WHERE b.`booking_date`='2015-04-30'

mysql delete query from 2 table

mysql delete query from 2 table :

 DELETE rbs_room_booking , rbs_sc_user  FROM rbs_room_booking  INNER JOIN rbs_sc_user WHERE rbs_room_booking.booking_id= rbs_sc_user.booking_id AND rbs_room_booking.booking_id = '310'

mysql active status show as Active and Inactive

mysql active status show as Active and Inactive :

rbs_user this table active_status Coloumn Default=N

SELECT user_id,user_name,e_mail,designation,CASE WHEN active_status ='Y' THEN 'Active' ELSE 'Inactive' END activestatus FROM rbs_user


activestatus is allias name 

java code:
public String userStatus(){
   
        System.out.println("kaniz");
       
         if(statusVal.equalsIgnoreCase("inactive")){
                status ="Y";
            } else {
                status ="N";
            }
       
   
       
         UsersSQL usersSQL = new UsersSQL();
         usersSQL.getUpdateTable(status,unikId); // use for update query
         
       
            //userDataList = usersSQL.selectUsersDate();// use for select query
           
        return "userStatus";       
       
    }

mysql query write using join Not subQuery

mysql query write using join :

two query convert into one query using join



//1st query :
SELECT b.all_users_email,b.room_id FROM rbs_room_booking b WHERE b.booking_id = 277

SELECT b.all_users_email,b.room_id,  r.ud_room_id, r.room_name, r.room_type,r.capacity
FROM rbs_room_booking b
 JOIN rbs_room r ON r.room_id = b.room_id
WHERE booking_id = 277



//2nd query :
SELECT ud_room_id, room_name, room_type,capacity FROM rbs_room r WHERE room_id = 41

server Auto run when pc run

 Please go to start->all programs -> set-> here drag and drop short cut icon from desktop

sql in and out query Writing way ( mySql )

sql in  query Writing way :

 SELECT *FROM rbs_user

  SELECT e_mail FROM rbs_user WHERE user_id IN(1,2)//it is correct,it is auto increment id
  SELECT e_mail FROM rbs_user WHERE ud_user_id IN('gp101','gp102')


  SELECT e_mail FROM rbs_user WHERE ud_user_id IN(gp101,gp102) //Wrong way


 SELECT *FROM rbs_user

mySql Date format

SELECT NOW();
SELECT CURDATE();
SELECT CURTIME();
SELECT  DATE_FORMAT(NOW(), '%d/%m/%Y') FROM DUAL
SELECT  DATE_FORMAT(CURDATE(), '%d/%m/%Y') FROM DUAL

or

SELECT  DATE_FORMAT(SYSDATE(), '%d/%m/%Y') FROM DUAL




                // String query = "SELECT booking_id,type_id,title,room_id,booking_date,start_time,end_time,description,attendy_people FROM rbs_room_booking where booking_id="+bookingid+"";
               //mySQL date format
                 String query = "SELECT booking_id,type_id,title,room_id,booking_date,DATE_FORMAT(start_time, '%d/%m/%Y')start_time,DATE_FORMAT(end_time, '%d/%m/%Y')end_time,description,attendy_people FROM rbs_room_booking where booking_id="+bookingid+"";



See the following Example :
//search criteria :: mySQL date format 
( SELECT DATE_FORMAT(booking_date, '%d/%m/%Y')booking_date FROM rbs_room_booking )
// String query = "SELECT booking_id,type_id,title,room_id,DATE_FORMAT(booking_date, '%d/%m/%Y')booking_date,DATE_FORMAT(start_time, '%d/%m/%Y')start_time,DATE_FORMAT(end_time, '%d/%m/%Y')end_time,description,(SELECT user_name FROM rbs_user WHERE user_id = a.entered_by)user_name FROM rbs_room_booking a where booking_id="+bookingid+"";

//search criteria :: get time from datetime column sql
( SELECT CAST(start_time AS TIME)starttime,CAST(end_time AS TIME)endtime FROM rbs_room_booking )
String query = "SELECT booking_id,type_id,title,room_id,DATE_FORMAT(booking_date, '%d/%m/%Y')booking_date,CAST(start_time AS TIME)starttime,CAST(end_time AS TIME)endtime,description,(SELECT user_name FROM rbs_user WHERE user_id = a.entered_by)user_name FROM rbs_room_booking a where booking_id="+bookingid+"";