To open database  "mysql c0_immast_site"
Insert:- INSERT INTO jobs (
    ->   job_code,
    ->   job_position,
    ->   job_desc,
    ->   job_salary,
    ->   job_vacancy,
    ->   job_other_information,
    ->   job_last_date,
    ->   job_posted_date,
    ->   job_status,
    ->   job_category,
    ->   priority
    -> )
    -> VALUES
    -> ('J001', 'Manager (Outbound Education)', 'Position for managing outbound educational travel.', 'As per industry standards', '1', 'Worli, Mumbai. Transferable', '2025-05-31', CURDATE(), 'A', 1, 1),
('J002', 'Officer – Admin, Travel & Guest Relations', 'Responsible for administrative and guest relation duties.', 'As per industry standards', '1', 'Worli, Mumbai', '2025-05-31', CURDATE(), 'A', 1, 2),
('J003', 'Officer – Marketing & Sales', 'Marketing and sales in the travel industry.', 'As per industry standards', '1', 'Worli, Mumbai', '2025-05-31', CURDATE(), 'A', 1, 3),
('J004', 'Senior Executive (Purchase)', 'Handles purchasing and vendor relations.', 'As per industry standards', '1', 'Mumbai', '2025-05-31', CURDATE(), 'A', 1, 4);
    -> ('J002', 'Officer – Admin, Travel & Guest Relations', 'Responsible for administrative and guest relation duties.', 'As per industry standards', '1', 'Worli, Mumbai', '2025-05-31', CURDATE(), 'A', 1, 2),
    -> ('J003', 'Officer – Marketing & Sales', 'Marketing and sales in the travel industry.', 'As per industry standards', '1', 'Worli, Mumbai', '2025-05-31', CURDATE(), 'A', 1, 3),
    -> ('J004', 'Senior Executive (Purchase)', 'Handles purchasing and vendor relations.', 'As per industry standards', '1', 'Mumbai', '2025-05-31', CURDATE(), 'A', 1, 4);


for any update or replace content -- Update for job_id 92
UPDATE jobs 
SET job_posted_date = '2025-04-25', 
    job_last_date = '2025-06-15' 
WHERE job_id = 92;

-- Update for job_id 93
UPDATE jobs 
SET job_posted_date = '2025-04-25', 
    job_last_date = '2025-06-15' 
WHERE job_id = 93;

-- Update for job_id 94
UPDATE jobs 
SET job_posted_date = '2025-04-25', 
    job_last_date = '2025-06-15' 
WHERE job_id = 94;

-- Update for job_id 95
UPDATE jobs 
SET job_posted_date = '2025-04-25', 
    job_last_date = '2025-06-15' 
WHERE job_id = 95;

for Active or Inactive Job Vaccancy :- UPDATE jobs SET job_status = 'C' WHERE job_id = 43;
Now After that you want to see job vacancy :- SELECT * FROM jobs WHERE job_status = 'A';