sql commons

SELECT 
	`applicationdetails`.`name`, `applicationdetails`.`addr`, `applicationdetails`.`city`,`applicationdetails`.`photo`, `applicationdetails`.`signature`, `applicationdetails`.`roll_no`,`applicationdetails`.`appNo`, s.name as state_name, `jobdetails`.`jobTitle`, `jobdetails`.`jobCatName`, `jobdetails`.`exam_date`, e_state.name as e_state_name, e_district.name e_district_name, `examcenter`.`center_name`, `examcenter`.`center_addr`
FROM 
	`applicationdetails` 
	JOIN
    `examcenter`
    ON
    `applicationdetails`.`ecenter`=`examcenter`.`center_id`
    JOIN
    `states` e_state
    ON
    `examcenter`.`state_id` = e_state.`id`
    JOIN
    `districts` e_district
    ON
    `examcenter`.`district_id` = e_district.`id`
    JOIN
    `jobdetails`
    on
    `applicationdetails`.`jobPostId`=`jobdetails`.`jobPostId`
    JOIN
    `states` s
    ON
    `applicationdetails`.`state`=S.`id`

ALTER TABLE tablename AUTO_INCREMENT = 1

qualification_id

ALTER TABLE Orders
ADD FOREIGN KEY (P_Id)
REFERENCES Persons(P_Id)

ALTER TABLE `applicationdetails`
ADD FOREIGN KEY (`qualification_id`)
REFERENCES `qualification`(`qId`)

ALTER TABLE `jobdetails`
ADD FOREIGN KEY (`eligibility_id`)
REFERENCES `qualification`(`qId`)

ALTER TABLE `sefeedback` ADD FOREIGN KEY (`userName`) REFERENCES `login`(`userName`)

RewriteEngine on in the .htaccess file and replace yourdomain.com: 
Redirect /setup http://billing.unicornsoftwares.com/



CREATE TABLE IF NOT EXISTS `examcenter` (
  `center_id` int(11) NOT NULL AUTO_INCREMENT,
  `state_id` int(10) NOT NULL,
  `district_id` int(10) NOT NULL,
  `center_name` varchar(100) NOT NULL,
  `center_addr` text NOT NULL,
  `seat_capacity` int(19) NOT NULL,
);

CREATE TABLE `jobneepco`.`examcenter` ( `center_id` INT NOT NULL AUTO_INCREMENT , `state_id` INT NOT NULL , `district_id` INT NOT NULL , `center_name` VARCHAR(100) NOT NULL , `center_addr` VARCHAR(300) NOT NULL , `seat_capacity` INT NOT NULL , PRIMARY KEY (`center_id`)) ENGINE = InnoDB;

ALTER TABLE `applicationdetails`
ADD FOREIGN KEY (`ecenter`)
REFERENCES examcenter(center_id)

CREATE TABLE `jobneepco`.`roll_no_generated` ( `id` INT NOT NULL AUTO_INCREMENT , `job_post_id` INT NOT NULL , `center_id` INT NOT NULL , `roll_no` INT NOT NULL , `updated_at` timestamp on update CURRENT_TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP , PRIMARY KEY (`id`)) ENGINE = InnoDB;

ALTER TABLE 
	`roll_no_generated` 
ADD 
	FOREIGN KEY (`job_post_id`) REFERENCES jobdetails(jobPostId)


DELETE FROM `leave_details` WHERE ld_id or (SELECT `ld_id` FROM `leave_details` GROUP by ecode,`effective_on`)

DELETE FROM sametable
WHERE id IN (
 SELECT implicitTemp.id from (SELECT id FROM sametable WHERE stuff=true) implicitTemp
)

DELETE FROM `leave_details` WHERE ld_id in (SELECT `temp_table`.`ld_id` FROM (select `ld_id` from `leave_details` GROUP by ecode,`effective_on`) temp_table)


SELECT * FROM `attmis_temp_attendance_logs` GROUP by emp_id, log_date, flag