connection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'OXYCODONE'New record created successfullySELECT LAST_INSERT_ID() as id FROM drug_info33insert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','33','0056-01','OXYCODONE','Debra Robinson','2007831','150','02 07 2025','60','ei')New record created successfullyconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'test'Cannot add more than 2 records for the same drug name.testNew record updated successfullyconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS ER'New record created successfullySELECT LAST_INSERT_ID() as id FROM drug_info36insert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','36','3061-11','AMPHETAMINE+DEXTRO SALTS ER','jackson justin','2007815','60','02 05 2025','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'JORNAY PM'New record created successfullySELECT LAST_INSERT_ID() as id FROM drug_info37insert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','37','0203-03','JORNAY PM','violet reiter','2007816','30','02 05 2025','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'ADZENYS XR-ODT'New record created successfullySELECT LAST_INSERT_ID() as id FROM drug_info38insert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','38','0020-30','ADZENYS XR-ODT','gregory waggoner','2007848','30','02 11 2025','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'DEXMETHYLPHENIDATE'New record created successfullySELECT LAST_INSERT_ID() as id FROM drug_info39insert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','39','0379-88','DEXMETHYLPHENIDATE','gregory waggoner','2007849','60','02 11 2025','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS'New record created successfullySELECT LAST_INSERT_ID() as id FROM drug_info40insert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','40','0808-01','AMPHETAMINE+DEXTRO SALTS','laura ulshafer','2007855','90','02 12 2025','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS'New record created successfullySELECT LAST_INSERT_ID() as id FROM drug_info41AMPHETAMINE+DEXTRO SALTSNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS'Cannot add more than 2 records for the same drug name.insert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0952-01','AMPHETAMINE+DEXTRO SALTS','emma coleman','2007843','60','02 11 2025','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'OXYCODONE'New record created successfullySELECT LAST_INSERT_ID() as id FROM drug_info42insert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','42','8515-01','OXYCODONE','jeffrey soble','2007844','120','01 10 2025','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'OXYCODONE/APAP'New record created successfullySELECT LAST_INSERT_ID() as id FROM drug_info43insert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','43','0104-50','OXYCODONE/APAP','kwame mckenzie','2007842','80','01 10 2025','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'OXYCODONE'Cannot add more than 2 records for the same drug name.insert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','8520-01','OXYCODONE','grayden maier','2007838','170','02 10 2025','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'ADZENYS XR-ODT'New record created successfullySELECT LAST_INSERT_ID() as id FROM drug_info44insert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','44','0015-30','ADZENYS XR-ODT','cooper heidin','2007812','30','02 04 2025','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS'Cannot add more than 2 records for the same drug name.insert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0953-01','AMPHETAMINE+DEXTRO SALTS','michell colman','2007810','90','02 04 2025','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS'Cannot add more than 2 records for the same drug name.insert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0948-01','AMPHETAMINE+DEXTRO SALTS','ciara catalan','2007803','30','02 03 2025','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS ER'New record created successfullySELECT LAST_INSERT_ID() as id FROM drug_info45AMPHETAMINE+DEXTRO SALTS ERNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS ER'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTS ERNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS ER'Cannot add more than 2 records for the same drug name.insert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','3063-11','AMPHETAMINE+DEXTRO SALTS ER','rachel brooks','2007827','30','02 07 2025','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'ADZENYS XR-ODT'Cannot add more than 2 records for the same drug name.insert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0025-30','ADZENYS XR-ODT','hilary boretz','2007804','30','02 06 2025','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'VYVANSE'New record created successfullySELECT LAST_INSERT_ID() as id FROM drug_info46insert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','46','0105-10','VYVANSE','joanna geeker','2007825','30','02 06 2025','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS'Cannot add more than 2 records for the same drug name.insert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0950-01','AMPHETAMINE+DEXTRO SALTS','joanna geeker','2007824','30','02 06 2025','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'OXYCODONE'Cannot add more than 2 records for the same drug name.OXYCODONENew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'FENTANYL'New record created successfullySELECT LAST_INSERT_ID() as id FROM drug_info47insert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','47','9119-98','FENTANYL','cynthia mayer','2007821','15','02 06 2025','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'HYDROMORPHONE'New record created successfullySELECT LAST_INSERT_ID() as id FROM drug_info48insert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','48','3249-01','HYDROMORPHONE','melissa baratian','2007811','90','02 06 2025','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS ER'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTS ERNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'OXYCODONE'Cannot add more than 2 records for the same drug name.insert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0552-01','OXYCODONE','james mcdonald','2007832','30','01 07 2025','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'LISDEXAMFETAMINE (VYVANSE)'New record created successfullySELECT LAST_INSERT_ID() as id FROM drug_info49insert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','49','0165-01','LISDEXAMFETAMINE (VYVANSE)','phyllis jordan','2007808','30','02 07 2025','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'COTEMPLA XR-ODT'New record created successfullySELECT LAST_INSERT_ID() as id FROM drug_info50insert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','50','0300-30','COTEMPLA XR-ODT','millie dempsey','2007814','30','02 06 2025','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'METHYLPHENIDATE ER'New record created successfullySELECT LAST_INSERT_ID() as id FROM drug_info51insert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','51','0727-01','METHYLPHENIDATE ER','charlie hodge','2007795','30','01 31 2025','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS ER'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTS ERNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'METHYLPHENIDATE ER'New record created successfullySELECT LAST_INSERT_ID() as id FROM drug_info52insert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','52','0725-01','METHYLPHENIDATE ER','belal abbas abdelsabour','2007793','30','01 31 2025','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'OXYCODONE/APAP'New record created successfullySELECT LAST_INSERT_ID() as id FROM drug_info53insert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','53','0103-50','OXYCODONE/APAP','rebecca barnett','2007769','150','01 23 2025','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'ADZENYS XR-ODT'Cannot add more than 2 records for the same drug name.ADZENYS XR-ODTNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS ER'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTS ERNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'LISDEXAMFETAMINE (VYVANSE)'New record created successfullySELECT LAST_INSERT_ID() as id FROM drug_info54LISDEXAMFETAMINE (VYVANSE)New record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS ER'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTS ERNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'HYDROMORPHONE'New record created successfullySELECT LAST_INSERT_ID() as id FROM drug_info55insert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','55','3243-01','HYDROMORPHONE','amanda  bush','2007765','130','01 22 2025','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'MORPHINE SULF ER'New record created successfullySELECT LAST_INSERT_ID() as id FROM drug_info56insert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','56','8330-01','MORPHINE SULF ER','amanda  bush','2007766','60','01 22 2025','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS ER'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTS ERNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'ADZENYS XR-ODT'Cannot add more than 2 records for the same drug name.insert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0030-30','ADZENYS XR-ODT','maria bridges','2007730','30','01 21 2025','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'HYDROMORPHONE'Cannot add more than 2 records for the same drug name.insert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','3244-01','HYDROMORPHONE','meagan lagasse','2007744','180','01 18 2025','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'OXYCODONE/APAP'Cannot add more than 2 records for the same drug name.OXYCODONE/APAPNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'DEXMETHYLPHENIDATE'New record created successfullySELECT LAST_INSERT_ID() as id FROM drug_info57insert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','57','0378-88','DEXMETHYLPHENIDATE','brendan gibson','2007747','30','01 17 2025','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'DEXMETHYLPHENIDATE ER'New record created successfullySELECT LAST_INSERT_ID() as id FROM drug_info58insert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','58','0009-01','DEXMETHYLPHENIDATE ER','brendan gibson','2007745','30','01 17 2025','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'OXYCODONE'Cannot add more than 2 records for the same drug name.OXYCODONENew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'METHYLPHENIDATE ER'Cannot add more than 2 records for the same drug name.METHYLPHENIDATE ERNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'ADZENYS XR-ODT'Cannot add more than 2 records for the same drug name.ADZENYS XR-ODTNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'COTEMPLA XR-ODT'New record created successfullySELECT LAST_INSERT_ID() as id FROM drug_info59COTEMPLA XR-ODTNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'LISDEXAMFETAMINE (VYVANSE)'Cannot add more than 2 records for the same drug name.LISDEXAMFETAMINE (VYVANSE)New record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'JORNAY PM'New record created successfullySELECT LAST_INSERT_ID() as id FROM drug_info60insert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','60','0204-03','JORNAY PM','john caleb jones','2007719','30','01 17 2025','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS ER'Cannot add more than 2 records for the same drug name.insert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','3059-11','AMPHETAMINE+DEXTRO SALTS ER','julie iyamu','2007698','90','01 18 2025','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'ADZENYS XR-ODT'Cannot add more than 2 records for the same drug name.ADZENYS XR-ODTNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSNew record updated successfullyconnection madeconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'COTEMPLA XR-ODT'Cannot add more than 2 records for the same drug name.insert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0100-30','COTEMPLA XR-ODT','delaney stutz','2007705','30','01 15 2025','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'COTEMPLA XR-ODT'Cannot add more than 2 records for the same drug name.COTEMPLA XR-ODTNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS ER'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTS ERNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'COTEMPLA XR-ODT'Cannot add more than 2 records for the same drug name.COTEMPLA XR-ODTNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS ER'Cannot add more than 2 records for the same drug name.insert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','3064-11','AMPHETAMINE+DEXTRO SALTS ER','brittany norris','2007711','30','01 14 2025','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'METHYLPHENIDATE ER'Cannot add more than 2 records for the same drug name.METHYLPHENIDATE ERNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'METHYLPHENIDATE ER'Cannot add more than 2 records for the same drug name.METHYLPHENIDATE ERNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS ER'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTS ERNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS ER'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTS ERNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'OXYCODONE'Cannot add more than 2 records for the same drug name.OXYCODONENew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'OXYCODONE/APAP'Cannot add more than 2 records for the same drug name.OXYCODONE/APAPNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'METHYLPHENIDATE'New record created successfullySELECT LAST_INSERT_ID() as id FROM drug_info61insert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','61','0480-01','METHYLPHENIDATE','crystal burdette','2007681','90','01 13 2025','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'OXYCODONE/APAP'Cannot add more than 2 records for the same drug name.OXYCODONE/APAPNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'LISDEXAMFETAMINE (VYVANSE)'Cannot add more than 2 records for the same drug name.LISDEXAMFETAMINE (VYVANSE)New record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS ER'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTS ERNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'OXYCODONE'Cannot add more than 2 records for the same drug name.OXYCODONENew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'OXYCODONE'Cannot add more than 2 records for the same drug name.OXYCODONENew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'METHYLPHENIDATE ER'Cannot add more than 2 records for the same drug name.insert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0734-01','METHYLPHENIDATE ER','charlie hodge','2007655','30','01 04 2025','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'METHYLPHENIDATE ER'Cannot add more than 2 records for the same drug name.METHYLPHENIDATE ERNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'ADZENYS XR-ODT'Cannot add more than 2 records for the same drug name.ADZENYS XR-ODTNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'HYDROMORPHONE'Cannot add more than 2 records for the same drug name.HYDROMORPHONENew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'OXYCODONE'Cannot add more than 2 records for the same drug name.insert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0004-01','OXYCODONE','pamela grayden maier','2007675','36','01 08 2025','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'ADZENYS XR-ODT'Cannot add more than 2 records for the same drug name.ADZENYS XR-ODTNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'OXYCODONE'Cannot add more than 2 records for the same drug name.OXYCODONENew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS ER'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTS ERNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'OXYCODONE'Cannot add more than 2 records for the same drug name.OXYCODONENew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'METHYLPHENIDATE'New record created successfullySELECT LAST_INSERT_ID() as id FROM drug_info62METHYLPHENIDATENew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AZSTARYS'New record created successfullySELECT LAST_INSERT_ID() as id FROM drug_info63insert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','63','0286-99','AZSTARYS','jaydyn fiona kilpatrick','2007781','30','01 28 2025','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'OXYCODONE'Cannot add more than 2 records for the same drug name.OXYCODONENew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'OXYCODONE'Cannot add more than 2 records for the same drug name.OXYCODONENew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'HYDROCODONE/APAP'New record created successfullySELECT LAST_INSERT_ID() as id FROM drug_info64insert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','64','0123-05','HYDROCODONE/APAP','mitsue harada','2007755','30','01 18 2025','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'LISDEXAMFETAMINE (VYVANSE)'Cannot add more than 2 records for the same drug name.insert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0024-09','LISDEXAMFETAMINE (VYVANSE)','tiffany shaw','2007754','30','01 18 2025','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'LISDEXAMFETAMINE (VYVANSE)'Cannot add more than 2 records for the same drug name.LISDEXAMFETAMINE (VYVANSE)New record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'OXYCODONE'Cannot add more than 2 records for the same drug name.OXYCODONENew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'JORNAY PM'Cannot add more than 2 records for the same drug name.JORNAY PMNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'JORNAY PM'Cannot add more than 2 records for the same drug name.JORNAY PMNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'DEXMETHYLPHEN ER'New record created successfullySELECT LAST_INSERT_ID() as id FROM drug_info65insert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','65','5553-01','DEXMETHYLPHEN ER','jessica balena-borneman','2007678','30','01 08 2025','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'ADZENYS XR-ODT'Cannot add more than 2 records for the same drug name.ADZENYS XR-ODTNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'OXYCODONE/APAP'Cannot add more than 2 records for the same drug name.insert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0102-01','OXYCODONE/APAP','stanley wooley','2007670','30','01 07 2025','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS ER'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTS ERNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'HYDROCODONE/APAP'New record created successfullySELECT LAST_INSERT_ID() as id FROM drug_info66HYDROCODONE/APAPNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'COTEMPLA XR-ODT'Cannot add more than 2 records for the same drug name.COTEMPLA XR-ODTNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'METHYLPHENIDATE ER'Cannot add more than 2 records for the same drug name.METHYLPHENIDATE ERNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'OXYCODONE/APAP'Cannot add more than 2 records for the same drug name.OXYCODONE/APAPNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'MORPHINE SULF ER'New record created successfullySELECT LAST_INSERT_ID() as id FROM drug_info67MORPHINE SULF ERNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'OXYCODONE'Cannot add more than 2 records for the same drug name.OXYCODONENew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS ER'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTS ERNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'METHYLPHENIDATE CD'New record created successfullySELECT LAST_INSERT_ID() as id FROM drug_info68insert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','68','1820-01','METHYLPHENIDATE CD','cate mary kirbo','2007482','30','11 26 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS'Cannot add more than 2 records for the same drug name.insert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0853-01','AMPHETAMINE+DEXTRO SALTS','tina kirven','2007477','30','11 25 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AZSTARYS'New record created successfullySELECT LAST_INSERT_ID() as id FROM drug_info69insert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','69','0429-99','AZSTARYS','victoria penake','2007474','30','11 25 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'OXYCODONE'Cannot add more than 2 records for the same drug name.OXYCODONENew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS'Cannot add more than 2 records for the same drug name.insert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','2099-01','AMPHETAMINE+DEXTRO SALTS','laura ulshafer','2007458','90','11 25 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'METHYLPHENIDATE'Cannot add more than 2 records for the same drug name.METHYLPHENIDATENew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'JORNAY PM'Cannot add more than 2 records for the same drug name.JORNAY PMNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'OXYCODONE'Cannot add more than 2 records for the same drug name.OXYCODONENew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'HYDROCODONE/APAP'Cannot add more than 2 records for the same drug name.insert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0125-05','HYDROCODONE/APAP','tess warnke','2007440','112','11 21 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS ER'Cannot add more than 2 records for the same drug name.insert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','3060-11','AMPHETAMINE+DEXTRO SALTS ER','laura d' errico','2007439','30','11 21 2024','','')connection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS ER'Cannot add more than 2 records for the same drug name.insert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','3060-11','AMPHETAMINE+DEXTRO SALTS ER','vaughne chavez-gray','2007437','30','11 21 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'METHYLPHENIDATE ER'Cannot add more than 2 records for the same drug name.METHYLPHENIDATE ERNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'OXYCODONE'Cannot add more than 2 records for the same drug name.OXYCODONENew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'COTEMPLA XR-ODT'Cannot add more than 2 records for the same drug name.COTEMPLA XR-ODTNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'HYDROCODONE/HOMATROPINE'New record created successfullySELECT LAST_INSERT_ID() as id FROM drug_info70insert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','70','0150-16','HYDROCODONE/HOMATROPINE','jeffrey soble','2007419','120','11 18 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'DEXMETHYLPHEN ER'New record created successfullySELECT LAST_INSERT_ID() as id FROM drug_info71DEXMETHYLPHEN ERNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'METHYLPHENIDATE CD'New record created successfullySELECT LAST_INSERT_ID() as id FROM drug_info72METHYLPHENIDATE CDNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'JORNAY PM'Cannot add more than 2 records for the same drug name.JORNAY PMNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'DEXMETHYLPHENIDATE ER'New record created successfullySELECT LAST_INSERT_ID() as id FROM drug_info73DEXMETHYLPHENIDATE ERNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'LISDEXAMFETAMINE (VYVANSE)'Cannot add more than 2 records for the same drug name.LISDEXAMFETAMINE (VYVANSE)New record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'DEXMETHYLPHENIDATE'Cannot add more than 2 records for the same drug name.DEXMETHYLPHENIDATENew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'METHYLPHENIDATE ER'Cannot add more than 2 records for the same drug name.METHYLPHENIDATE ERNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'HYDROCODONE/HOMATROPINE'New record created successfullySELECT LAST_INSERT_ID() as id FROM drug_info74HYDROCODONE/HOMATROPINENew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'OXYCODONE'Cannot add more than 2 records for the same drug name.OXYCODONENew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'METHYLPHENIDATE'Cannot add more than 2 records for the same drug name.METHYLPHENIDATENew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'ADZENYS XR-ODT'Cannot add more than 2 records for the same drug name.ADZENYS XR-ODTNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS ER'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTS ERNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'JORNAY PM'Cannot add more than 2 records for the same drug name.JORNAY PMNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS ER'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTS ERNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'ADZENYS XR-ODT'Cannot add more than 2 records for the same drug name.ADZENYS XR-ODTNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AZSTARYS'Cannot add more than 2 records for the same drug name.AZSTARYSNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'COTEMPLA XR-ODT'Cannot add more than 2 records for the same drug name.insert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0200-30','COTEMPLA XR-ODT','hollis allen','2007340','30','11 02 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE SULFATE (MYDAXIS)'New record created successfullySELECT LAST_INSERT_ID() as id FROM drug_info75insert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','75','3685-01','AMPHETAMINE SULFATE (MYDAXIS)','john joshua reiter','2007286','30','11 08 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'METHYLPHENIDATE'Cannot add more than 2 records for the same drug name.METHYLPHENIDATENew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS ER'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTS ERNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'METHYLPHENIDATE'Cannot add more than 2 records for the same drug name.METHYLPHENIDATENew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS ER'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTS ERNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS ER'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTS ERNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'HYDROCODONE/APAP'Cannot add more than 2 records for the same drug name.insert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0124-01','HYDROCODONE/APAP','Julianne Auerbach','2007479','20','11 26 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'HYDROCODONE/HOMATROPINE'Cannot add more than 2 records for the same drug name.insert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0055-03','HYDROCODONE/HOMATROPINE','Winston Auerbach','2007480','15','11 26 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'OXYCODONE'Cannot add more than 2 records for the same drug name.insert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','8000201','OXYCODONE','Deanna Williams','2007447','112','11 14 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Adzenys XR-ODT'Cannot add more than 2 records for the same drug name.ADZENYS XR-ODTinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0020-30','Adzenys XR-ODT','Mark Mandell','2007436','30','11 20 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'HYDROCODONE/APAP'Cannot add more than 2 records for the same drug name.HYDROCODONE/APAPNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Hydromorphone hcl'New record created successfullySELECT LAST_INSERT_ID() as id FROM drug_info76HYDROMORPHONEinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','76','3243-01','Hydromorphone hcl','Amanda Bush','2007430','130','11 20 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Hydromorphone hcl'New record created successfullySELECT LAST_INSERT_ID() as id FROM drug_info77HYDROMORPHONEinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','77','3249-01','Hydromorphone hcl','Melissa Baratian','2007388','90','11 09 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'DEXMETHYLPHEN ER'Cannot add more than 2 records for the same drug name.DEXMETHYLPHEN ERNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Adzenys XR-ODT'Cannot add more than 2 records for the same drug name.ADZENYS XR-ODTinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0020-30','Adzenys XR-ODT','Connor Mccurdy','2007406','30','11 15 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Morphine Sulfate ER'New record created successfullySELECT LAST_INSERT_ID() as id FROM drug_info78insert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','78','0450-01','Morphine Sulfate ER','Jeff Soble','2007322','90','10 28 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Concerta'New record created successfullySELECT LAST_INSERT_ID() as id FROM drug_info79insert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','79','0587-01','Concerta','Trent Gibson','2007238','30','10 18 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Fentanyl'New record created successfullySELECT LAST_INSERT_ID() as id FROM drug_info80insert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','80','9123-16','Fentanyl','Cynthia Mayer','2007200','15','10 24 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Fentanyl'Cannot add more than 2 records for the same drug name.insert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','9112-76','Fentanyl','Cynthia Mayer','2007202','15','10 04 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Adzenys XR-ODT'Cannot add more than 2 records for the same drug name.ADZENYS XR-ODTinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0025-30','Adzenys XR-ODT','David Cooper','2007196','30','10 04 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Dyanavel XR'New record created successfullySELECT LAST_INSERT_ID() as id FROM drug_info81insert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','81','0110-01','Dyanavel XR','Logan Obrien','2007228','30','10 10 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Oxycodone-Acetamin'New record created successfullySELECT LAST_INSERT_ID() as id FROM drug_info82OXYCODONE/APAPinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','82','0104-50','Oxycodone-Acetamin','Kimberly Burdette','2007236','90','10 11 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Dexmethylphenidate hcl ER'New record created successfullySELECT LAST_INSERT_ID() as id FROM drug_info83insert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','83','0229-01','Dexmethylphenidate hcl ER','Lachlan Kilpatrick','2007216','30','10 08 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Methylphenidate ER'Cannot add more than 2 records for the same drug name.insert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0127-01','Methylphenidate ER','Charlie Hodge','2007198','30','10 04 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Methylphenidate hcl'New record created successfullySELECT LAST_INSERT_ID() as id FROM drug_info84insert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','84','0478-01','Methylphenidate hcl','Peyton Maynard','2007219','30','10 09 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Hydromet'New record created successfullySELECT LAST_INSERT_ID() as id FROM drug_info85insert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','85','1030-16','Hydromet','Jeffrey Soble','2007268','120','10 21 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Methylphenidate CD'Cannot add more than 2 records for the same drug name.insert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','1810-01','Methylphenidate CD','Belal Abbas Abdelsabour','2007290','30','10 24 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Methylphenidate CD'Cannot add more than 2 records for the same drug name.METHYLPHENIDATE CDinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','1820-01','Methylphenidate CD','Aiden Toosi','2007325','30','10 29 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Azstarys'Cannot add more than 2 records for the same drug name.insert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0561-99','Azstarys','Augustin McCullough','2007221','30','10 09 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Azstarys'Cannot add more than 2 records for the same drug name.AzstarysNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro ER'New record created successfullySELECT LAST_INSERT_ID() as id FROM drug_info86insert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','86','0188-01','Amphetamine-Dextro ER','Heidi Speckhart','2007096','30','10 07 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Methylphenidate hcl'New record created successfullySELECT LAST_INSERT_ID() as id FROM drug_info87insert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','87','0479-01','Methylphenidate hcl','Henry Haynes','2007234','30','10 11 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Lisdexamfetamine Dimesylate'New record created successfullySELECT LAST_INSERT_ID() as id FROM drug_info88insert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','88','0026-09','Lisdexamfetamine Dimesylate','Joanna Geeker','2007266','30','10 21 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Lisdexamfetamine Dimesylate'New record created successfullySELECT LAST_INSERT_ID() as id FROM drug_info89Lisdexamfetamine DimesylateNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro'New record created successfullySELECT LAST_INSERT_ID() as id FROM drug_info90insert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','90','0766-37','Amphetamine-Dextro','Heather Hyche','2007284','30','10 23 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro'New record created successfullySELECT LAST_INSERT_ID() as id FROM drug_info91Amphetamine-DextroNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro'Cannot add more than 2 records for the same drug name.insert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0973-02','Amphetamine-Dextro','Erin Coleman','2007299','90','10 28 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'HYDROCODONE/APAP'Cannot add more than 2 records for the same drug name.HYDROCODONE/APAPNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Morphine Sulfate ER'New record created successfullySELECT LAST_INSERT_ID() as id FROM drug_info92MORPHINE SULF ERinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','92','8330-01','Morphine Sulfate ER','Amanda Bush','2007332','60','10 30 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Dexmethylphenidate hcl ER'New record created successfullySELECT LAST_INSERT_ID() as id FROM drug_info93Dexmethylphenidate hcl ERNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Methylphenidate hcl'Cannot add more than 2 records for the same drug name.Methylphenidate hclNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'OXYCODONE'Cannot add more than 2 records for the same drug name.OXYCODONENew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Methylphenidate LA'New record created successfullySELECT LAST_INSERT_ID() as id FROM drug_info94insert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','94','0013-01','Methylphenidate LA','Aiden Toosi','2007326','30','10 29 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro'Cannot add more than 2 records for the same drug name.Amphetamine-DextroNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro ER'New record created successfullySELECT LAST_INSERT_ID() as id FROM drug_info95AMPHETAMINE+DEXTRO SALTS ERinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','95','3061-11','Amphetamine-Dextro ER','Destinee Hood','2007338','30','10 31 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'HYDROCODONE/APAP'Cannot add more than 2 records for the same drug name.HYDROCODONE/APAPNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'HYDROCODONE/HOMATROPINE'Cannot add more than 2 records for the same drug name.HYDROCODONE/HOMATROPINENew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'OXYCODONE'Cannot add more than 2 records for the same drug name.OXYCODONENew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Adzenys XR-ODT'Cannot add more than 2 records for the same drug name.ADZENYS XR-ODTinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0020-30','Adzenys XR-ODT','Mark Mandell','2007436','30','11 20 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'HYDROCODONE/APAP'Cannot add more than 2 records for the same drug name.HYDROCODONE/APAPNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Hydromorphone hcl'Cannot add more than 2 records for the same drug name.HYDROMORPHONEinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','3243-01','Hydromorphone hcl','Amanda Bush','2007430','130','11 20 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Hydromorphone hcl'Cannot add more than 2 records for the same drug name.HYDROMORPHONEinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','3249-01','Hydromorphone hcl','Melissa Baratian','2007388','90','11 09 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Adzenys XR-ODT'Cannot add more than 2 records for the same drug name.ADZENYS XR-ODTinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0020-30','Adzenys XR-ODT','Connor McCurdy','2007406','30','11 15 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Dexmethylphenidate hcl ER'Cannot add more than 2 records for the same drug name.Dexmethylphenidate hcl ERNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Dyanavel XR'New record created successfullySELECT LAST_INSERT_ID() as id FROM drug_info96insert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','96','0108-01','Dyanavel XR','Griffin Shields','2007378','30','11 07 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Lisdexamfetamine Dimesylate'Cannot add more than 2 records for the same drug name.Lisdexamfetamine DimesylateNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro'Cannot add more than 2 records for the same drug name.insert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0765-37','Amphetamine-Dextro','Gabriel Holly','2007401','30','11 13 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro'Cannot add more than 2 records for the same drug name.Amphetamine-DextroNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro'Cannot add more than 2 records for the same drug name.Amphetamine-DextroNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro'Cannot add more than 2 records for the same drug name.insert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0117-01','Amphetamine-Dextro','Justin Jackson','2007400','60','11 13 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro'Cannot add more than 2 records for the same drug name.Amphetamine-DextroNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Lisdexamfetamine Dimesylate'Cannot add more than 2 records for the same drug name.Lisdexamfetamine DimesylateNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Dexmethylphenidate ER'Cannot add more than 2 records for the same drug name.insert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0006-01','Dexmethylphenidate ER','Naomi Chidolue','2007481','30','11 26 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Dyanavel XR'Cannot add more than 2 records for the same drug name.Dyanavel XRNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Lisdexamfetamine Dimesylate'Cannot add more than 2 records for the same drug name.insert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0167-01','Lisdexamfetamine Dimesylate','Morgan Batie','2007386','30','11 14 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Morphine Sulfate ER'Cannot add more than 2 records for the same drug name.insert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0801-01','Morphine Sulfate ER','Jeffrey Soble','2007472','90','11 23 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro'Cannot add more than 2 records for the same drug name.Amphetamine-DextroNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Azstarys'Cannot add more than 2 records for the same drug name.AzstarysNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Lisdexamfetamine Dimesylate'Cannot add more than 2 records for the same drug name.Lisdexamfetamine DimesylateNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Morphine Sulfate ER'Cannot add more than 2 records for the same drug name.Morphine Sulfate ERNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Methylphenidate HCL CD'New record created successfullySELECT LAST_INSERT_ID() as id FROM drug_info97insert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','97','1830-01','Methylphenidate HCL CD','Caitlin Connelly','2007424','30','11 20 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro'Cannot add more than 2 records for the same drug name.Amphetamine-DextroNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Cotempla XR-ODT'Cannot add more than 2 records for the same drug name.COTEMPLA XR-ODTinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0300-30','Cotempla XR-ODT','Millie Dempsey','2007632','30','12 30 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Morphine Sulfate ER'Cannot add more than 2 records for the same drug name.MORPHINE SULF ERinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','8330-01','Morphine Sulfate ER','Amanda Bush','2007612','60','12 24 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'OXYCODONE'Cannot add more than 2 records for the same drug name.OXYCODONENew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'LISDEXAMFETAMINE (VYVANSE)'Cannot add more than 2 records for the same drug name.LISDEXAMFETAMINE (VYVANSE)New record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0953-01','Amphetamine-Dextro','Gabriel Holly','2007608','30','12 20 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0953-01','Amphetamine-Dextro','Margaret Akhabue','2007594','30','12 18 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Hydromorphone hcl'Cannot add more than 2 records for the same drug name.HYDROMORPHONEinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','3243-01','Hydromorphone hcl','Amanda Bush','2007589','130','12 18 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Morphine Sulfate ER'Cannot add more than 2 records for the same drug name.MORPHINE SULF ERinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','8330-01','Morphine Sulfate ER','Amanda Bush','2007431','60','11 20 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Lisdexamfetamine Dimesylate'Cannot add more than 2 records for the same drug name.Lisdexamfetamine DimesylateNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Adzenys XR-ODT'Cannot add more than 2 records for the same drug name.ADZENYS XR-ODTinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0020-30','Adzenys XR-ODT','Connor McCurdy','2007580','30','12 16 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Hydromorphone hcl'Cannot add more than 2 records for the same drug name.HYDROMORPHONEinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','3243-01','Hydromorphone hcl','Meagan Lagasse','2007533','420','12 06 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'OXYCODONE/APAP'Cannot add more than 2 records for the same drug name.OXYCODONE/APAPNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Dexmethylphenidate hcl ER'Cannot add more than 2 records for the same drug name.Dexmethylphenidate hcl ERNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Hydrocodone-Acetaminophen'New record created successfullySELECT LAST_INSERT_ID() as id FROM drug_info98insert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','98','0123-01','Hydrocodone-Acetaminophen','Leslie Gibson','2007530','30','12 06 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS ER'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTS ERNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0950-01','Amphetamine-Dextro','Patrick O'Hearn','2007522','30','12 04 2024','','')connection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Dexmethylphenidate hcl ER'Cannot add more than 2 records for the same drug name.insert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0049-01','Dexmethylphenidate hcl ER','Jessica Balena-Borneman','2007500','30','12 02 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'DEXMETHYLPHEN ER'Cannot add more than 2 records for the same drug name.DEXMETHYLPHEN ERNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Cotempla XR-ODT'Cannot add more than 2 records for the same drug name.COTEMPLA XR-ODTinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0300-30','Cotempla XR-ODT','Millie Dempsey','2007493','30','12 02 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Hydrocodone-Acetaminophen'New record created successfullySELECT LAST_INSERT_ID() as id FROM drug_info99Hydrocodone-AcetaminophenNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'ADZENYS XR-ODT'Cannot add more than 2 records for the same drug name.ADZENYS XR-ODTNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Methylphenidate CD'Cannot add more than 2 records for the same drug name.METHYLPHENIDATE CDinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','1820-01','Methylphenidate CD','Alex Crafter','2007581','30','12 19 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'OXYCODONE'Cannot add more than 2 records for the same drug name.OXYCODONENew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Methylphenidate ER'Cannot add more than 2 records for the same drug name.METHYLPHENIDATE ERinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0727-01','Methylphenidate ER','Trent Gibson','2007591','30','12 18 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Methylphenidate hcl'Cannot add more than 2 records for the same drug name.Methylphenidate hclNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Lisdexamfetamine Dimesylate'Cannot add more than 2 records for the same drug name.insert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0050-88','Lisdexamfetamine Dimesylate','Hai James Le','2007593','30','12 18 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'OXYCODONE/APAP'Cannot add more than 2 records for the same drug name.insert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0523-01','OXYCODONE/APAP','Mark Magnes','2007605','30','12 19 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Oxycodone hcl'New record created successfullySELECT LAST_INSERT_ID() as id FROM drug_info100OXYCODONEinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','100','8515-01','Oxycodone hcl','Mark Magnes','2007606','90','12 19 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0808-01','Amphetamine-Dextro','Samantha Harvey','2007626','60','12 26 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Dexmethylphenidate hcl'New record created successfullySELECT LAST_INSERT_ID() as id FROM drug_info101DEXMETHYLPHENIDATEinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','101','0378-88','Dexmethylphenidate hcl','Naomi Chidolue','2007646','30','12 31 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Dexmethylphenidate ER'Cannot add more than 2 records for the same drug name.Dexmethylphenidate ERNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'OXYCODONE'Cannot add more than 2 records for the same drug name.OXYCODONENew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'METHYLPHENIDATE'Cannot add more than 2 records for the same drug name.METHYLPHENIDATENew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'HYDROCODONE/APAP'Cannot add more than 2 records for the same drug name.HYDROCODONE/APAPNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Azstarys'Cannot add more than 2 records for the same drug name.AZSTARYSinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0286-99','Azstarys','Fiona Jadyn Kilpatrick','2007631','30','12 30 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-DextroAmphet Salts'New record created successfullySELECT LAST_INSERT_ID() as id FROM drug_info102AMPHETAMINE+DEXTRO SALTSinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','102','0948-01','Amphetamine-DextroAmphet Salts','Alexander Chitu-Boyd','2007648','30','12 31 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro ER'Cannot add more than 2 records for the same drug name.Amphetamine-Dextro ERNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Oxycodone-Acetamin'New record created successfullySELECT LAST_INSERT_ID() as id FROM drug_info103OXYCODONE/APAPinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','103','0104-50','Oxycodone-Acetamin','Melissa Baratian','2007642','30','12 31 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Dexmethylphenidate hcl ER'Cannot add more than 2 records for the same drug name.DEXMETHYLPHENIDATE ERinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0009-01','Dexmethylphenidate hcl ER','Brendan Gibson','2007603','30','12 19 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Azstarys'Cannot add more than 2 records for the same drug name.AZSTARYSinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0429-99','Azstarys','Victoria Penake','2007628','30','12 27 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0953-01','Amphetamine-Dextro','Destinee Hood','2007640','30','12 31 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro ER'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTS ERinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','3061-11','Amphetamine-Dextro ER','Destinee Hood','2007639','30','12 31 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro ER'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTS ERinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','3059-11','Amphetamine-Dextro ER','Alexander Chitu-Boyd','2007647','30','12 31 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Oxycodone-Acetaminophen'New record created successfullySELECT LAST_INSERT_ID() as id FROM drug_info104OXYCODONE/APAPinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','104','0103-50','Oxycodone-Acetaminophen','Amanda Ippolito','2007624','84','12 26 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS'Cannot add more than 2 records for the same drug name.insert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0115-01','AMPHETAMINE+DEXTRO SALTS','Lauren Warnke','2007625','60','12 26 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Methylphenidate hcl'Cannot add more than 2 records for the same drug name.Methylphenidate hclNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Azstarys'Cannot add more than 2 records for the same drug name.AZSTARYSinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0286-99','Azstarys','Peyton Maynard','2007217','30','12 21 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro ER'Cannot add more than 2 records for the same drug name.Amphetamine-Dextro ERNew record updated successfullyconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'OXYCODONE'Cannot add more than 2 records for the same drug name.OXYCODONENew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'FENTANYL'Cannot add more than 2 records for the same drug name.insert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','9123-98','FENTANYL','cynthia mayer','2007352','15','11 04 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'METHYLPHENIDATE ER'Cannot add more than 2 records for the same drug name.METHYLPHENIDATE ERNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Fentanyl'Cannot add more than 2 records for the same drug name.FentanylNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro'Cannot add more than 2 records for the same drug name.Amphetamine-DextroNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Methylphenidate ER'Cannot add more than 2 records for the same drug name.METHYLPHENIDATE ERinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0725-01','Methylphenidate ER','charlie hodge','2007348','30','11 04 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro ER'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTS ERinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','3063-11','Amphetamine-Dextro ER','jacob trejo','2007356','30','11 04 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0950-01','Amphetamine-Dextro','presley miller','2007355','30','11 04 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Azstarys'Cannot add more than 2 records for the same drug name.AZSTARYSinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0429-99','Azstarys','anrai mccullough','2007357','30','11 04 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'COTEMPLA XR-ODT'Cannot add more than 2 records for the same drug name.COTEMPLA XR-ODTNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Adzenys XR-ODT'Cannot add more than 2 records for the same drug name.ADZENYS XR-ODTinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0025-30','Adzenys XR-ODT','david cooper','2007374','30','11 07 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0950-01','Amphetamine-Dextro','stephanie gilliam','2007362','30','11 05 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Cotempla XR-ODT'Cannot add more than 2 records for the same drug name.COTEMPLA XR-ODTinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0300-30','Cotempla XR-ODT','brandon basille','2007372','30','11 06 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS ER'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTS ERNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-DextroAmphet Salts'New record created successfullySELECT LAST_INSERT_ID() as id FROM drug_info105AMPHETAMINE+DEXTRO SALTSinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','105','0952-01','Amphetamine-DextroAmphet Salts','sade johson','2007364','30','11 06 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro'Cannot add more than 2 records for the same drug name.Amphetamine-DextroNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Methylphenidate ER'Cannot add more than 2 records for the same drug name.METHYLPHENIDATE ERinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0725-01','Methylphenidate ER','chase fournier','2007353','30','11 04 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS ER'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTS ERNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-DextroAmphet Salts'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0948-01','Amphetamine-DextroAmphet Salts','Vaughne Chavez-Gray','2007584','30','12 17 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Dexmethylphenidate hcl ER'Cannot add more than 2 records for the same drug name.Dexmethylphenidate hcl ERNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro ER'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTS ERinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','3063-11','Amphetamine-Dextro ER','Ashley Martin','2007571','30','12 13 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-DextroAmphet Salts'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0952-01','Amphetamine-DextroAmphet Salts','michell colman','2007360','90','11 06 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Methylphenidate hcl'Cannot add more than 2 records for the same drug name.Methylphenidate hclNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro ER'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTS ERinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','3061-11','Amphetamine-Dextro ER','justin jackson','2007368','60','11 05 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Adzenys XR-ODT'Cannot add more than 2 records for the same drug name.ADZENYS XR-ODTinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0020-30','Adzenys XR-ODT','Clayton Hedin','2007579','30','12 16 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-DextroAmphet Salts'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0948-01','Amphetamine-DextroAmphet Salts','alexander chitu-boyd','2007361','60','11 05 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Cotempla XR-ODT'Cannot add more than 2 records for the same drug name.COTEMPLA XR-ODTinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0300-30','Cotempla XR-ODT','Brandon Basille','2007561','30','12 13 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro ER'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTS ERinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','3061-11','Amphetamine-Dextro ER','stephanie gilliam','2007363','30','11 05 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Vyvanse'New record created successfullySELECT LAST_INSERT_ID() as id FROM drug_info106VYVANSEinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','106','0105-10','Vyvanse','Joanna Geeker','2007563','30','12 13 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0950-01','Amphetamine-Dextro','Joanna Geeker','2007564','30','12 13 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Methylphenidate hcl'Cannot add more than 2 records for the same drug name.Methylphenidate hclNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro ER'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTS ERinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','3061-11','Amphetamine-Dextro ER','justin jackson','2007815','60','02 05 2025','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Oxycodone hcl'New record created successfullySELECT LAST_INSERT_ID() as id FROM drug_info107OXYCODONEinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','107','8515-01','Oxycodone hcl','jeffrey soble','2007844','120','02 10 2025','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-DextroAmphet Salts'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0952-01','Amphetamine-DextroAmphet Salts','emma coleman','2007843','60','02 11 2025','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0808-01','Amphetamine-Dextro','natalia de la guardia','2007851','60','02 12 2025','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro ER'Cannot add more than 2 records for the same drug name.Amphetamine-Dextro ERNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0808-01','Amphetamine-Dextro','laura ulshafer','2007855','90','02 12 2025','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'COTEMPLA XR-ODT'Cannot add more than 2 records for the same drug name.COTEMPLA XR-ODTNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Adzenys XR-ODT'Cannot add more than 2 records for the same drug name.ADZENYS XR-ODTinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0020-30','Adzenys XR-ODT','gregory waggoner','2007848','30','02 11 2025','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Jornay PM'Cannot add more than 2 records for the same drug name.JORNAY PMinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0203-03','Jornay PM','violet reiter','2007816','30','02 05 2025','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Cotempla XR-ODT'Cannot add more than 2 records for the same drug name.COTEMPLA XR-ODTinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0300-30','Cotempla XR-ODT','Henry Haynes','2007548','30','12 11 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Azstarys'Cannot add more than 2 records for the same drug name.AzstarysNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS ER'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTS ERNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro ER'Cannot add more than 2 records for the same drug name.Amphetamine-Dextro ERNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro ER'Cannot add more than 2 records for the same drug name.Amphetamine-Dextro ERNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0953-01','Amphetamine-Dextro','David Zach Hood','2007551','90','12 10 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Methylphenidate LA'New record created successfullySELECT LAST_INSERT_ID() as id FROM drug_info108Methylphenidate LANew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'COTEMPLA XR-ODT'Cannot add more than 2 records for the same drug name.COTEMPLA XR-ODTNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Lisdexafetamine Dimesylate'New record created successfullySELECT LAST_INSERT_ID() as id FROM drug_info109insert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','109','3568-01','Lisdexafetamine Dimesylate','dylan ward','2007829','30','01 11 2025','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Fentanyl'Cannot add more than 2 records for the same drug name.insert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0424-47','Fentanyl','Jeffrey Soble','2007568','15','12 13 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'DEXMETHYLPHENIDATE'Cannot add more than 2 records for the same drug name.DEXMETHYLPHENIDATENew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'MYDAYIS'New record created successfullySELECT LAST_INSERT_ID() as id FROM drug_info110insert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','110','0474-01','MYDAYIS','Joshua Reiter','2007547','30','12 10 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Methylphenidate HCL CD'New record created successfullySELECT LAST_INSERT_ID() as id FROM drug_info111Methylphenidate HCL CDNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0808-01','Amphetamine-Dextro','deborah newton','2007839','60','01 10 2025','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Oxycodone hcl'Cannot add more than 2 records for the same drug name.OXYCODONEinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','8515-01','Oxycodone hcl','Jeffrey Soble','2007570','120','12 13 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0953-01','Amphetamine-Dextro','michell coleman','2007810','90','02 04 2025','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Oxycodone HCL'Cannot add more than 2 records for the same drug name.OXYCODONEinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','8520-01','Oxycodone HCL','Pamela Maier-Grayden','2007573','170','12 13 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-DextroAmphet Salts'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0948-01','Amphetamine-DextroAmphet Salts','ciara catalan','2007803','30','01 03 2025','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro ER'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTS ERinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','3061-11','Amphetamine-Dextro ER','ciara catalan','2007802','30','02 03 2025','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'OXYCODONE/APAP'Cannot add more than 2 records for the same drug name.OXYCODONE/APAPNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro ER'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTS ERinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','3061-11','Amphetamine-Dextro ER','kimberly kellam-rainey','2007828','30','01 07 2025','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Fentanyl'Cannot add more than 2 records for the same drug name.FentanylNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Oxycodone-Acetamin'Cannot add more than 2 records for the same drug name.OXYCODONE/APAPinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0104-50','Oxycodone-Acetamin','kwame mckenzie','2007842','80','01 10 2025','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'OXYCODONE'Cannot add more than 2 records for the same drug name.OXYCODONENew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-DextroAmphet Salts'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0952-01','Amphetamine-DextroAmphet Salts','brennan connelly','2007820','30','02 07 2025','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Methylphenidate CD'Cannot add more than 2 records for the same drug name.METHYLPHENIDATE CDinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','1820-01','Methylphenidate CD','Belal Abbas Abdelsabour','2007615','30','12 23 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-DextroAmphet Salts'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0952-01','Amphetamine-DextroAmphet Salts','lauren warnke','2007819','60','02 06 2025','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Adzenys XR-ODT'Cannot add more than 2 records for the same drug name.ADZENYS XR-ODTinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0025-30','Adzenys XR-ODT','hilary boretz','2007804','30','02 06 2025','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro ER'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTS ERinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','3061-11','Amphetamine-Dextro ER','Adelaide Gorrondona','2007604','30','12 19 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'OXYCODONE'Cannot add more than 2 records for the same drug name.OXYCODONENew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0950-01','Amphetamine-Dextro','joanna geeker','2007824','30','02 06 2025','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'HYDROCODONE/APAP'Cannot add more than 2 records for the same drug name.HYDROCODONE/APAPNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Vyvanse'Cannot add more than 2 records for the same drug name.VYVANSEinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0105-10','Vyvanse','joanna geeker','2007825','30','02 06 2025','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Oxycodone-Acetaminophen'New record created successfullySELECT LAST_INSERT_ID() as id FROM drug_info112OXYCODONE/APAPinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','112','0103-50','Oxycodone-Acetaminophen','Rebecca Barnett','2007621','150','12 24 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Fentanyl'Cannot add more than 2 records for the same drug name.FENTANYLinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','9119-98','Fentanyl','cynthia mayer','2007821','15','02 06 2025','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0953-01','Amphetamine-Dextro','Stephanie Gilliam','2007618','15','12 26 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Dexmethylphenidate hcl ER'Cannot add more than 2 records for the same drug name.Dexmethylphenidate hcl ERNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro ER'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTS ERinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','3061-11','Amphetamine-Dextro ER','Stephanie Gilliam','2007619','30','12 24 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Oxycodone HCL'Cannot add more than 2 records for the same drug name.OXYCODONEinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','8520-01','Oxycodone HCL','pamela maier-grayden','2007838','170','01 10 2025','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'OXYCODONE'Cannot add more than 2 records for the same drug name.OXYCODONENew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Adzenys XR ODT'New record created successfullySELECT LAST_INSERT_ID() as id FROM drug_info113ADZENYS XR-ODTinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','113','0015-30','Adzenys XR ODT','cooper heiden','2007812','30','02 04 2025','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro ER'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTS ERinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','3061-11','Amphetamine-Dextro ER','Justin Jackson','2007600','60','12 19 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro ER'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTS ERinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','3063-11','Amphetamine-Dextro ER','rachel brooks','2007827','30','01 07 2025','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Methylphenidate ER'Cannot add more than 2 records for the same drug name.METHYLPHENIDATE ERinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0727-01','Methylphenidate ER','charlie hodge','2007795','30','01 31 2025','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Lisdexamfetamine Dimesylate'Cannot add more than 2 records for the same drug name.Lisdexamfetamine DimesylateNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-DextroAmphet Salts'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0948-01','Amphetamine-DextroAmphet Salts','vaughne chavez-gray','2007857','30','02 12 2025','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Hydromorphone hcl'Cannot add more than 2 records for the same drug name.HYDROMORPHONEinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','3249-01','Hydromorphone hcl','melissa baratian','2007811','90','02 06 2025','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro ER'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTS ERinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','3063-11','Amphetamine-Dextro ER','sarah hallberg','2007835','30','02 11 2025','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro ER'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTS ERinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','3061-11','Amphetamine-Dextro ER','shae furlong','2007791','30','01 30 2025','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0808-01','Amphetamine-Dextro','mia de la guardia','2007800','60','02 03 2025','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-DextroAmphet Salts'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0952-01','Amphetamine-DextroAmphet Salts','tess warnke','2007785','60','01 29 2025','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Oxycodone-Acetaminophen'Cannot add more than 2 records for the same drug name.OXYCODONE/APAPinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0103-50','Oxycodone-Acetaminophen','rebecca barnett','2007769','150','01 23 2025','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Adzenys XR-ODT'Cannot add more than 2 records for the same drug name.ADZENYS XR-ODTinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0025-30','Adzenys XR-ODT','david cooper','2007774','30','01 24 2025','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0808-01','Amphetamine-Dextro','samantha harvey','2007775','60','01 27 2025','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro ER'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTS ERinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','3061-11','Amphetamine-Dextro ER','destine hood','2007782','30','01 28 2025','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0953-01','Amphetamine-Dextro','destine hood','2007783','30','01 28 2025','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0953-01','Amphetamine-Dextro','erin coleman','2007784','90','01 29 2025','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0950-01','Amphetamine-Dextro','marvin watson','2007740','60','01 16 2025','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Methylphenidate LA'Cannot add more than 2 records for the same drug name.Methylphenidate LANew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Hydrocodone-Acetaminophen'Cannot add more than 2 records for the same drug name.Hydrocodone-AcetaminophenNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro ER'Cannot add more than 2 records for the same drug name.Amphetamine-Dextro ERNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Methylphenidate hcl'Cannot add more than 2 records for the same drug name.Methylphenidate hclNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro ER'Cannot add more than 2 records for the same drug name.Amphetamine-Dextro ERNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro ER'Cannot add more than 2 records for the same drug name.Amphetamine-Dextro ERNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Fentanyl'Cannot add more than 2 records for the same drug name.FentanylNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Methylphenidate hcl'Cannot add more than 2 records for the same drug name.Methylphenidate hclNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro ER'Cannot add more than 2 records for the same drug name.Amphetamine-Dextro ERNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro ER'Cannot add more than 2 records for the same drug name.Amphetamine-Dextro ERNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Dexmethylphenidate hcl ER'Cannot add more than 2 records for the same drug name.Dexmethylphenidate hcl ERNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Methylphenidate hcl'Cannot add more than 2 records for the same drug name.Methylphenidate hclNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Lisdexamfetamine Dimesylate'Cannot add more than 2 records for the same drug name.Lisdexamfetamine DimesylateNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro ER'Cannot add more than 2 records for the same drug name.Amphetamine-Dextro ERNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Azstarys'Cannot add more than 2 records for the same drug name.AzstarysNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0950-01','Amphetamine-Dextro','Marvin Watson','2007599','60','12 19 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Lisdexamfetamine Dimesyl'New record created successfullySELECT LAST_INSERT_ID() as id FROM drug_info114LISDEXAMFETAMINE (VYVANSE)insert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','114','0165-01','Lisdexamfetamine Dimesyl','john joshua reiter','2007751','30','01 22 2025','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro ER'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTS ERinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','3061-11','Amphetamine-Dextro ER','adelaide gorrondona','2007772','30','01 23 2025','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Hydromorphone hcl'Cannot add more than 2 records for the same drug name.HYDROMORPHONEinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','3243-01','Hydromorphone hcl','amanda bush','2007765','130','01 22 2025','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'DEXMETHYLPHEN ER'Cannot add more than 2 records for the same drug name.DEXMETHYLPHEN ERNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Morphine Sulfate ER'Cannot add more than 2 records for the same drug name.MORPHINE SULF ERinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','8330-01','Morphine Sulfate ER','amanda bush','2007766','60','01 22 2025','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro ER'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTS ERinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','3061-11','Amphetamine-Dextro ER','stephanie gilliam','2007764','30','01 21 2025','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Jornay PM'Cannot add more than 2 records for the same drug name.JORNAY PMinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0204-03','Jornay PM','John Caleb Jones','2007595','30','12 18 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0950-01','Amphetamine-Dextro','stgephanie gilliam','2007763','30','01 21 2025','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0808-01','Amphetamine-Dextro','Laura Ulshafer','2007590','90','12 19 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'ADZENYS XR-ODT'Cannot add more than 2 records for the same drug name.ADZENYS XR-ODTNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Hydromorphone hcl'Cannot add more than 2 records for the same drug name.HYDROMORPHONEinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','3244-01','Hydromorphone hcl','meagan lagasse','2007744','180','01 18 2025','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Oxycodone-Acetamin'Cannot add more than 2 records for the same drug name.OXYCODONE/APAPinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0104-50','Oxycodone-Acetamin','Kwame Mckenzie','2007588','80','12 17 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0953-01','Amphetamine-Dextro','aileen lopez','2007742','60','01 17 2025','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro ER'Cannot add more than 2 records for the same drug name.Amphetamine-Dextro ERNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Oxycodone-Acetamin'Cannot add more than 2 records for the same drug name.OXYCODONE/APAPinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0104-50','Oxycodone-Acetamin','tess warnke','2007758','84','01 20 2025','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Dexmethylphenidate hcl'New record created successfullySELECT LAST_INSERT_ID() as id FROM drug_info115DEXMETHYLPHENIDATEinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','115','0378-88','Dexmethylphenidate hcl','brendan gibson','2007747','30','01 17 2025','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Dexmethylphenidate hcl ER'Cannot add more than 2 records for the same drug name.Dexmethylphenidate hcl ERNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Dexmethylphenidate hcl ER'Cannot add more than 2 records for the same drug name.DEXMETHYLPHENIDATE ERinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0009-01','Dexmethylphenidate hcl ER','brendan gibson','2007745','30','01 17 2025','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'OXYCODONE'Cannot add more than 2 records for the same drug name.insert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0005-01','OXYCODONE','John Moore','2007583','28','12 16 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Oxycodone HCL'Cannot add more than 2 records for the same drug name.OXYCODONEinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','8520-01','Oxycodone HCL','gregory bobka','2007768','165','01 22 2025','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Methylphenidate ER'Cannot add more than 2 records for the same drug name.METHYLPHENIDATE ERinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0727-01','Methylphenidate ER','trent gibson','2007759','30','01 20 2025','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Methylphenidate LA'Cannot add more than 2 records for the same drug name.Methylphenidate LANew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Adzenys XR-ODT'Cannot add more than 2 records for the same drug name.ADZENYS XR-ODTinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0020-30','Adzenys XR-ODT','connor mccurdy','2007729','30','01 23 2025','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0953-01','Amphetamine-Dextro','jessica smith','2007771','60','01 23 2025','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'MORPHINE SULF IR'New record created successfullySELECT LAST_INSERT_ID() as id FROM drug_info116insert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','116','0273-11','MORPHINE SULF IR','Debra Robison','2007492','150','12 02 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Cotempla XR-ODT'Cannot add more than 2 records for the same drug name.COTEMPLA XR-ODTinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0300-30','Cotempla XR-ODT','brandon basille','2007706','30','01 23 2025','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro ER'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTS ERinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','3059-11','Amphetamine-Dextro ER','Alexander Chitu-Boyd','2007511','30','12 03 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Lisdexamfetamine Dimesyl'New record created successfullySELECT LAST_INSERT_ID() as id FROM drug_info117LISDEXAMFETAMINE (VYVANSE)insert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','117','0165-01','Lisdexamfetamine Dimesyl','james hai le','2007749','30','01 18 2025','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Jornay PM'Cannot add more than 2 records for the same drug name.JORNAY PMinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0204-03','Jornay PM','caleb john jones','2007719','30','01 17 2025','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-DextroAmphet Salts'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0948-01','Amphetamine-DextroAmphet Salts','Alexander Chitu-Boyd','2007510','30','12 03 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro ER'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTS ERinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','3059-11','Amphetamine-Dextro ER','julie iyamu','2007698','90','01 18 2025','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro ER'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTS ERinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','3063-11','Amphetamine-Dextro ER','Rachel Brooks','2007509','30','12 03 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Oxycodone-Acetamin'Cannot add more than 2 records for the same drug name.OXYCODONE/APAPinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0104-50','Oxycodone-Acetamin','Laura Buxton','2007508','120','12 03 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Adzenys XR ODT'New record created successfullySELECT LAST_INSERT_ID() as id FROM drug_info118ADZENYS XR-ODTinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','118','0015-30','Adzenys XR ODT','Cooper Hedin','2007507','30','12 03 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'DEXMETHYLPHEN ER'Cannot add more than 2 records for the same drug name.DEXMETHYLPHEN ERNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Dexmethylphenidate hcl ER'Cannot add more than 2 records for the same drug name.Dexmethylphenidate hcl ERNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Methylphenidate ER'Cannot add more than 2 records for the same drug name.Methylphenidate ERNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Dexmethylphenidate hcl ER'Cannot add more than 2 records for the same drug name.Dexmethylphenidate hcl ERNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Hydrocodone-Acetaminophen'Cannot add more than 2 records for the same drug name.Hydrocodone-AcetaminophenNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro ER'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTS ERinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','3061-11','Amphetamine-Dextro ER','Paige Hasheider','2007506','30','12 03 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro ER'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTS ERinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','3059-11','Amphetamine-Dextro ER','Paige Hasheider','2007505','30','12 03 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro'Cannot add more than 2 records for the same drug name.Amphetamine-DextroNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Adzenys XR-ODT'Cannot add more than 2 records for the same drug name.ADZENYS XR-ODTinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0020-30','Adzenys XR-ODT','Jonah Blank','2007504','30','12 03 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Methylphenidate ER'Cannot add more than 2 records for the same drug name.METHYLPHENIDATE ERinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0725-01','Methylphenidate ER','belal abbas abdelsabour','2007793','30','01 31 2025','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro ER'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTS ERinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','3061-11','Amphetamine-Dextro ER','Justin Jackson','2007503','60','12 03 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro ER'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTS ERinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','3061-11','Amphetamine-Dextro ER','Destinee Hood','2007496','30','12 02 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Azstarys'Cannot add more than 2 records for the same drug name.AZSTARYSinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0286-99','Azstarys','Fiona Jadyn Kilpatrick','2007495','30','12 02 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-DextroAmphet Salts'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0952-01','Amphetamine-DextroAmphet Salts','Tess Warnke','2007491','60','12 02 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'METHYLPHENIDATE'Cannot add more than 2 records for the same drug name.METHYLPHENIDATENew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Cotempla XR-ODT'Cannot add more than 2 records for the same drug name.COTEMPLA XR-ODTinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0300-30','Cotempla XR-ODT','Liam Henson','2007489','30','12 02 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Cotempla XR-ODT'Cannot add more than 2 records for the same drug name.COTEMPLA XR-ODTinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0300-30','Cotempla XR-ODT','Ryleigh Simmons','2007490','30','12 02 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Dexmethylphenidate hcl ER'Cannot add more than 2 records for the same drug name.Dexmethylphenidate hcl ERNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-DextroAmphet Salts'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0952-01','Amphetamine-DextroAmphet Salts','Emma Coleman','2007562','60','12 12 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Methylphenidate hcl'Cannot add more than 2 records for the same drug name.Methylphenidate hclNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro ER'Cannot add more than 2 records for the same drug name.Amphetamine-Dextro ERNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Methylphenidate ER'Cannot add more than 2 records for the same drug name.METHYLPHENIDATE ERinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0725-01','Methylphenidate ER','Mitsue Harada','2007550','30','12 10 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Hydromorphone hcl'Cannot add more than 2 records for the same drug name.HYDROMORPHONEinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','3249-01','Hydromorphone hcl','Melissa Baratian','2007545','90','12 09 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0950-01','Amphetamine-Dextro','Presley Miller','2007546','30','12 09 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro ER'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTS ERinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','3061-11','Amphetamine-Dextro ER','Kimberly Kellam-Rainey','2007535','30','12 07 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-DextroAmphet Salts'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0948-01','Amphetamine-DextroAmphet Salts','Ciara Catalan','2007515','30','12 04 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS ER'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTS ERNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS ER'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTS ERNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Fentanyl'Cannot add more than 2 records for the same drug name.FentanylNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'OXYCODONE'Cannot add more than 2 records for the same drug name.OXYCODONENew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0953-01','Amphetamine-Dextro','Michell Coleman','2007526','90','12 05 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'JORNAY PM'Cannot add more than 2 records for the same drug name.insert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0202-03','JORNAY PM','Lana McDaniel','2007525','30','12 05 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'FENTANYL'Cannot add more than 2 records for the same drug name.FENTANYLNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Adzenys XR-ODT'Cannot add more than 2 records for the same drug name.ADZENYS XR-ODTinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0025-30','Adzenys XR-ODT','Hilary Boretz','2007518','30','12 04 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro ER'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTS ERinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','3061-11','Amphetamine-Dextro ER','Ciara Catalan','2007514','30','12 04 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Oxycodone-Acetaminophen'Cannot add more than 2 records for the same drug name.OXYCODONE/APAPinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0103-50','Oxycodone-Acetaminophen','Amanda Ippolito','2007516','180','12 03 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'ADZENYS XR-ODT'Cannot add more than 2 records for the same drug name.ADZENYS XR-ODTNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Cotempla XR-ODT'Cannot add more than 2 records for the same drug name.insert into receving(inv,drug_info_id,drug_id,drug_name,csos,po,date_received,qty_received,received_by,physical_count)values('RECEIVING','','0300-30','Cotempla XR-ODT','24x100208','867507410','11 26 2024','30','ei','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Dexmethylphenidate ER'Cannot add more than 2 records for the same drug name.insert into receving(inv,drug_info_id,drug_id,drug_name,csos,po,date_received,qty_received,received_by,physical_count)values('RECEIVING','','0006-01','Dexmethylphenidate ER','24x100208','867507410','11 26 2024','100','ei','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Methylphenidate CD'Cannot add more than 2 records for the same drug name.insert into receving(inv,drug_info_id,drug_id,drug_name,csos,po,date_received,qty_received,received_by,physical_count)values('RECEIVING','','1820-01','Methylphenidate CD','24x100208','867507410','11 26 2024','1','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'OXYCODONE'Cannot add more than 2 records for the same drug name.insert into receving(inv,drug_info_id,drug_id,drug_name,csos,po,date_received,qty_received,received_by,physical_count)values('RECEIVING','','0004-01','OXYCODONE','24x100208','867507410','11 26 2024','200','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Cotempla XR-ODT'Cannot add more than 2 records for the same drug name.Cotempla XR-ODTNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'OXYCODONE'Cannot add more than 2 records for the same drug name.insert into receving(inv,drug_info_id,drug_id,drug_name,csos,po,date_received,qty_received,received_by,physical_count)values('RECEIVING','','0552-01','OXYCODONE','24x100208','867507410','11 26 2024','200','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'ADZENYS XR-ODT'Cannot add more than 2 records for the same drug name.insert into receving(inv,drug_info_id,drug_id,drug_name,csos,po,date_received,qty_received,received_by,physical_count)values('RECEIVING','','0030-30','ADZENYS XR-ODT','24x100214','869053501','12 05 2024','30','ei','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Jornay PM'Cannot add more than 2 records for the same drug name.insert into receving(inv,drug_info_id,drug_id,drug_name,csos,po,date_received,qty_received,received_by,physical_count)values('RECEIVING','','0204-03','Jornay PM','24x100206','866935991','11 22 2024','300','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro'Cannot add more than 2 records for the same drug name.insert into receving(inv,drug_info_id,drug_id,drug_name,csos,po,date_received,qty_received,received_by,physical_count)values('RECEIVING','','0953-01','Amphetamine-Dextro','24x100214','869053501','12 05 2024','400','ei','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'OXYCODONE'Cannot add more than 2 records for the same drug name.insert into receving(inv,drug_info_id,drug_id,drug_name,csos,po,date_received,qty_received,received_by,physical_count)values('RECEIVING','','8000201','OXYCODONE','24x100206','866935991','11 22 2024','300','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'FENTANYL'Cannot add more than 2 records for the same drug name.insert into receving(inv,drug_info_id,drug_id,drug_name,csos,po,date_received,qty_received,received_by,physical_count)values('RECEIVING','','9123-98','FENTANYL','24x100214','869053501','12 05 2024','300','ei','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Oxycodone hcl'Cannot add more than 2 records for the same drug name.insert into receving(inv,drug_info_id,drug_id,drug_name,csos,po,date_received,qty_received,received_by,physical_count)values('RECEIVING','','8515-01','Oxycodone hcl','24x100206','866935991','11 22 2024','200','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Fentanyl'Cannot add more than 2 records for the same drug name.insert into receving(inv,drug_info_id,drug_id,drug_name,csos,po,date_received,qty_received,received_by,physical_count)values('RECEIVING','','9112-76','Fentanyl','24x100214','869053501','12 05 2024','15','ei','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Azstarys'Cannot add more than 2 records for the same drug name.insert into receving(inv,drug_info_id,drug_id,drug_name,csos,po,date_received,qty_received,received_by,physical_count)values('RECEIVING','','0429-99','Azstarys','24x100207','86719683','02 25 2024','100','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-DextroAmphet Salts'Cannot add more than 2 records for the same drug name.insert into receving(inv,drug_info_id,drug_id,drug_name,csos,po,date_received,qty_received,received_by,physical_count)values('RECEIVING','','0948-01','Amphetamine-DextroAmphet Salts','24x100207','86719683','11 25 2024','300','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro ER'Cannot add more than 2 records for the same drug name.insert into receving(inv,drug_info_id,drug_id,drug_name,csos,po,date_received,qty_received,received_by,physical_count)values('RECEIVING','','3061-11','Amphetamine-Dextro ER','24x100207','86719683','11 25 2024','200','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Adzenys XR-ODT'Cannot add more than 2 records for the same drug name.insert into receving(inv,drug_info_id,drug_id,drug_name,csos,po,date_received,qty_received,received_by,physical_count)values('RECEIVING','','0020-30','Adzenys XR-ODT','24x100204','86659198','11 20 2024','30','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'ADZENYS XR-ODT'Cannot add more than 2 records for the same drug name.insert into receving(inv,drug_info_id,drug_id,drug_name,csos,po,date_received,qty_received,received_by,physical_count)values('RECEIVING','','0010-30','ADZENYS XR-ODT','24x100204','86659198','11 20 2024','30','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Cotempla XR-ODT'Cannot add more than 2 records for the same drug name.Cotempla XR-ODTNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'JORNAY PM'Cannot add more than 2 records for the same drug name.insert into receving(inv,drug_info_id,drug_id,drug_name,csos,po,date_received,qty_received,received_by,physical_count)values('RECEIVING','','0202-03','JORNAY PM','24x100214','869053501','12 05 2024','100','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Methylphenidate HCL CD'Cannot add more than 2 records for the same drug name.insert into receving(inv,drug_info_id,drug_id,drug_name,csos,po,date_received,qty_received,received_by,physical_count)values('RECEIVING','','1830-01','Methylphenidate HCL CD','24x100204','86659198','11 20 2024','100','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Adzenys XR-ODT'Cannot add more than 2 records for the same drug name.insert into receving(inv,drug_info_id,drug_id,drug_name,csos,po,date_received,qty_received,received_by,physical_count)values('RECEIVING','','0025-30','Adzenys XR-ODT','24x100211','869053501','12 03 2024','30','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Morphine Sulfate ER'Cannot add more than 2 records for the same drug name.insert into receving(inv,drug_info_id,drug_id,drug_name,csos,po,date_received,qty_received,received_by,physical_count)values('RECEIVING','','0801-01','Morphine Sulfate ER','24x10024','86659198','11 20 2024','200','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Adzenys XR ODT'Cannot add more than 2 records for the same drug name.insert into receving(inv,drug_info_id,drug_id,drug_name,csos,po,date_received,qty_received,received_by,physical_count)values('RECEIVING','','0015-30','Adzenys XR ODT','24x100211','869053501','12 03 2024','30','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Oxycodone-Acetaminophen'Cannot add more than 2 records for the same drug name.insert into receving(inv,drug_info_id,drug_id,drug_name,csos,po,date_received,qty_received,received_by,physical_count)values('RECEIVING','','0103-50','Oxycodone-Acetaminophen','24x100204','86659198','11 20 2024','500','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'METHYLPHENIDATE'Cannot add more than 2 records for the same drug name.insert into receving(inv,drug_info_id,drug_id,drug_name,csos,po,date_received,qty_received,received_by,physical_count)values('RECEIVING','','0480-01','METHYLPHENIDATE','24x100211','869053501','12 03 2024','300','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Azstarys'Cannot add more than 2 records for the same drug name.insert into receving(inv,drug_info_id,drug_id,drug_name,csos,po,date_received,qty_received,received_by,physical_count)values('RECEIVING','','0561-99','Azstarys','24x100205','866682123','11 21 2024','100','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS'Cannot add more than 2 records for the same drug name.insert into receving(inv,drug_info_id,drug_id,drug_name,csos,po,date_received,qty_received,received_by,physical_count)values('RECEIVING','','0853-01','AMPHETAMINE+DEXTRO SALTS','24x100202','866097636','11 19 2024','300','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Adzenys XR-ODT'Cannot add more than 2 records for the same drug name.Adzenys XR-ODTNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-DextroAmphet Salts'Cannot add more than 2 records for the same drug name.insert into receving(inv,drug_info_id,drug_id,drug_name,csos,po,date_received,qty_received,received_by,physical_count)values('RECEIVING','','0952-01','Amphetamine-DextroAmphet Salts','24x100199','864994581','11 12 2024','100','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS'Cannot add more than 2 records for the same drug name.insert into receving(inv,drug_info_id,drug_id,drug_name,csos,po,date_received,qty_received,received_by,physical_count)values('RECEIVING','','2099-01','AMPHETAMINE+DEXTRO SALTS','24x100199','864994581','11 12 2024','300','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Cotempla XR-ODT'Cannot add more than 2 records for the same drug name.Cotempla XR-ODTNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Oxycodone HCL'Cannot add more than 2 records for the same drug name.insert into receving(inv,drug_info_id,drug_id,drug_name,csos,po,date_received,qty_received,received_by,physical_count)values('RECEIVING','','8520-01','Oxycodone HCL','24x100200','865229625','11 13 2024','300','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'METHYLPHENIDATE'Cannot add more than 2 records for the same drug name.METHYLPHENIDATENew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'MORPHINE SULF IR'New record created successfullySELECT LAST_INSERT_ID() as id FROM drug_info119insert into receving(inv,drug_info_id,drug_id,drug_name,csos,po,date_received,qty_received,received_by,physical_count)values('RECEIVING','119','0273-11','MORPHINE SULF IR','24x100211','868599305','12 03 2024','300','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Adzenys XR-ODT'Cannot add more than 2 records for the same drug name.Adzenys XR-ODTNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Cotempla XR-ODT'Cannot add more than 2 records for the same drug name.Cotempla XR-ODTNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Dexmethylphenidate hcl ER'Cannot add more than 2 records for the same drug name.insert into receving(inv,drug_info_id,drug_id,drug_name,csos,po,date_received,qty_received,received_by,physical_count)values('RECEIVING','','0229-01','Dexmethylphenidate hcl ER','24x100196','864204725','11 07 2024','100','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Jornay PM'Cannot add more than 2 records for the same drug name.insert into receving(inv,drug_info_id,drug_id,drug_name,csos,po,date_received,qty_received,received_by,physical_count)values('RECEIVING','','0203-03','Jornay PM','24x100197','864378391','11 08 2024','100','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Lisdexamfetamine Dimesylate'Cannot add more than 2 records for the same drug name.insert into receving(inv,drug_info_id,drug_id,drug_name,csos,po,date_received,qty_received,received_by,physical_count)values('RECEIVING','','0167-01','Lisdexamfetamine Dimesylate','24x100198','864649967','11 11 2024','100','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Dyanavel XR'Cannot add more than 2 records for the same drug name.insert into receving(inv,drug_info_id,drug_id,drug_name,csos,po,date_received,qty_received,received_by,physical_count)values('RECEIVING','','0110-01','Dyanavel XR','24x100209','867735258','11 27 2024','30','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-DextroAmphet Salts'Cannot add more than 2 records for the same drug name.Amphetamine-DextroAmphet SaltsNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro'Cannot add more than 2 records for the same drug name.insert into receving(inv,drug_info_id,drug_id,drug_name,csos,po,date_received,qty_received,received_by,physical_count)values('RECEIVING','','0117-01','Amphetamine-Dextro','24x100195','863804533','11 06 2024','300','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'COTEMPLA XR-ODT'Cannot add more than 2 records for the same drug name.insert into receving(inv,drug_info_id,drug_id,drug_name,csos,po,date_received,qty_received,received_by,physical_count)values('RECEIVING','','0100-30','COTEMPLA XR-ODT','24x100194','86370285','11 05 2024','30','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Hydromorphone hcl'Cannot add more than 2 records for the same drug name.insert into receving(inv,drug_info_id,drug_id,drug_name,csos,po,date_received,qty_received,received_by,physical_count)values('RECEIVING','','3243-01','Hydromorphone hcl','24x100212','868792621','12 04 2024','300','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Oxycodone-Acetamin'Cannot add more than 2 records for the same drug name.insert into receving(inv,drug_info_id,drug_id,drug_name,csos,po,date_received,qty_received,received_by,physical_count)values('RECEIVING','','0104-50','Oxycodone-Acetamin','24x100212','86879261','12 04 2024','500','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'ADZENYS XR-ODT'Cannot add more than 2 records for the same drug name.ADZENYS XR-ODTNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Fentanyl'Cannot add more than 2 records for the same drug name.insert into receving(inv,drug_info_id,drug_id,drug_name,csos,po,date_received,qty_received,received_by,physical_count)values('RECEIVING','','0424-47','Fentanyl','24x100218','870287312','12 12 2024','15','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Cotempla XR-ODT'Cannot add more than 2 records for the same drug name.Cotempla XR-ODTNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'COTEMPLA XR-ODT'Cannot add more than 2 records for the same drug name.COTEMPLA XR-ODTNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Adzenys XR-ODT'Cannot add more than 2 records for the same drug name.Adzenys XR-ODTNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro'Cannot add more than 2 records for the same drug name.insert into receving(inv,drug_info_id,drug_id,drug_name,csos,po,date_received,qty_received,received_by,physical_count)values('RECEIVING','','0808-01','Amphetamine-Dextro','24x100220','870782578','12 16 2024','400','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS ER'Cannot add more than 2 records for the same drug name.insert into receving(inv,drug_info_id,drug_id,drug_name,csos,po,date_received,qty_received,received_by,physical_count)values('RECEIVING','','3064-11','AMPHETAMINE+DEXTRO SALTS ER','24x100220','870782578','12 16 2024','200','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Cotempla XR-ODT'Cannot add more than 2 records for the same drug name.Cotempla XR-ODTNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Oxycodone hcl'Cannot add more than 2 records for the same drug name.Oxycodone hclNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Oxycodone HCL'Cannot add more than 2 records for the same drug name.Oxycodone HCLNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'OXYCODONE/APAP'Cannot add more than 2 records for the same drug name.insert into receving(inv,drug_info_id,drug_id,drug_name,csos,po,date_received,qty_received,received_by,physical_count)values('RECEIVING','','0102-01','OXYCODONE/APAP','24x100219','870532395','12 13 2024','200','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Hydromorphone hcl'Cannot add more than 2 records for the same drug name.insert into receving(inv,drug_info_id,drug_id,drug_name,csos,po,date_received,qty_received,received_by,physical_count)values('RECEIVING','','3244-01','Hydromorphone hcl','24x100216','869679806','12 10 2024','400','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Hydromorphone hcl'Cannot add more than 2 records for the same drug name.insert into receving(inv,drug_info_id,drug_id,drug_name,csos,po,date_received,qty_received,received_by,physical_count)values('RECEIVING','','3249-01','Hydromorphone hcl','24x100216','869679806','12 10 2024','200','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Morphine Sulfate ER'Cannot add more than 2 records for the same drug name.insert into receving(inv,drug_info_id,drug_id,drug_name,csos,po,date_received,qty_received,received_by,physical_count)values('RECEIVING','','8330-01','Morphine Sulfate ER','24x100216','869679806','12 10 2024','200','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'OXYCODONE'Cannot add more than 2 records for the same drug name.OXYCODONENew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Dexmethylphenidate hcl ER'Cannot add more than 2 records for the same drug name.Dexmethylphenidate hcl ERNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Oxycodone hcl'Cannot add more than 2 records for the same drug name.Oxycodone hclNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro'Cannot add more than 2 records for the same drug name.Amphetamine-DextroNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'OXYCODONE'Cannot add more than 2 records for the same drug name.insert into receving(inv,drug_info_id,drug_id,drug_name,csos,po,date_received,qty_received,received_by,physical_count)values('RECEIVING','','0056-01','OXYCODONE','25x100017','878628829','01 30 2025','500','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Lisdexafetamine Dimesylate'New record created successfullySELECT LAST_INSERT_ID() as id FROM drug_info120insert into receving(inv,drug_info_id,drug_id,drug_name,csos,po,date_received,qty_received,received_by,physical_count)values('RECEIVING','120','3568-01','Lisdexafetamine Dimesylate','25x100014','878034690','01 28 2025','100','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro ER'Cannot add more than 2 records for the same drug name.Amphetamine-Dextro ERNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Hydrocodone-Acetaminophen'Cannot add more than 2 records for the same drug name.insert into receving(inv,drug_info_id,drug_id,drug_name,csos,po,date_received,qty_received,received_by,physical_count)values('RECEIVING','','0123-01','Hydrocodone-Acetaminophen','25x100013','877875388','01 27 2025','200','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro'Cannot add more than 2 records for the same drug name.Amphetamine-DextroNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro'Cannot add more than 2 records for the same drug name.Amphetamine-DextroNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro ER'Cannot add more than 2 records for the same drug name.insert into receving(inv,drug_info_id,drug_id,drug_name,csos,po,date_received,qty_received,received_by,physical_count)values('RECEIVING','','3059-11','Amphetamine-Dextro ER','25x100012','877615047','01 24 2025','200','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro ER'Cannot add more than 2 records for the same drug name.insert into receving(inv,drug_info_id,drug_id,drug_name,csos,po,date_received,qty_received,received_by,physical_count)values('RECEIVING','','0188-01','Amphetamine-Dextro ER','25x100012','877615047','01 24 2025','300','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Adzenys XR-ODT'Cannot add more than 2 records for the same drug name.Adzenys XR-ODTNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Hydromorphone hcl'Cannot add more than 2 records for the same drug name.Hydromorphone hclNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Hydromorphone hcl'Cannot add more than 2 records for the same drug name.Hydromorphone hclNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'OXYCODONE'Cannot add more than 2 records for the same drug name.OXYCODONENew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Oxycodone HCL'Cannot add more than 2 records for the same drug name.Oxycodone HCLNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Dexmethylphenidate hcl ER'Cannot add more than 2 records for the same drug name.Dexmethylphenidate hcl ERNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'ADZENYS XR-ODT'Cannot add more than 2 records for the same drug name.ADZENYS XR-ODTNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Dexmethylphenidate hcl'Cannot add more than 2 records for the same drug name.insert into receving(inv,drug_info_id,drug_id,drug_name,csos,po,date_received,qty_received,received_by,physical_count)values('RECEIVING','','0378-88','Dexmethylphenidate hcl','25x100009','876689896','01 20 2025','100','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Lisdexamfetamine Dimesyl'Cannot add more than 2 records for the same drug name.insert into receving(inv,drug_info_id,drug_id,drug_name,csos,po,date_received,qty_received,received_by,physical_count)values('RECEIVING','','0165-01','Lisdexamfetamine Dimesyl','25x100009','876689896','01 20 2025','100','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Adzenys XR-ODT'Cannot add more than 2 records for the same drug name.Adzenys XR-ODTNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Oxycodone HCL'Cannot add more than 2 records for the same drug name.Oxycodone HCLNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Adzenys XR ODT'Cannot add more than 2 records for the same drug name.Adzenys XR ODTNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Fentanyl'Cannot add more than 2 records for the same drug name.FentanylNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Cotempla XR-ODT'Cannot add more than 2 records for the same drug name.Cotempla XR-ODTNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Methylphenidate hcl'Cannot add more than 2 records for the same drug name.insert into receving(inv,drug_info_id,drug_id,drug_name,csos,po,date_received,qty_received,received_by,physical_count)values('RECEIVING','','0479-01','Methylphenidate hcl','25x100006','875767075','01 14 2025','200','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'METHYLPHENIDATE'Cannot add more than 2 records for the same drug name.METHYLPHENIDATENew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'ADZENYS XR-ODT'Cannot add more than 2 records for the same drug name.ADZENYS XR-ODTNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Cotempla XR-ODT'Cannot add more than 2 records for the same drug name.Cotempla XR-ODTNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'COTEMPLA XR-ODT'Cannot add more than 2 records for the same drug name.COTEMPLA XR-ODTNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-DextroAmphet Salts'Cannot add more than 2 records for the same drug name.Amphetamine-DextroAmphet SaltsNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Jornay PM'Cannot add more than 2 records for the same drug name.Jornay PMNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Jornay PM'Cannot add more than 2 records for the same drug name.Jornay PMNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro ER'Cannot add more than 2 records for the same drug name.Amphetamine-Dextro ERNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Oxycodone hcl'Cannot add more than 2 records for the same drug name.Oxycodone hclNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Adzenys XR-ODT'Cannot add more than 2 records for the same drug name.Adzenys XR-ODTNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Adzenys XR ODT'Cannot add more than 2 records for the same drug name.Adzenys XR ODTNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'DEXMETHYLPHEN ER'Cannot add more than 2 records for the same drug name.insert into receving(inv,drug_info_id,drug_id,drug_name,csos,po,date_received,qty_received,received_by,physical_count)values('RECEIVING','','5553-01','DEXMETHYLPHEN ER','25x100002','874414721','01 07 2025','100','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Dexmethylphenidate hcl ER'Cannot add more than 2 records for the same drug name.insert into receving(inv,drug_info_id,drug_id,drug_name,csos,po,date_received,qty_received,received_by,physical_count)values('RECEIVING','','0049-01','Dexmethylphenidate hcl ER','25x100002','874414721','01 07 2025','100','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Dexmethylphenidate ER'Cannot add more than 2 records for the same drug name.Dexmethylphenidate ERNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro'Cannot add more than 2 records for the same drug name.Amphetamine-DextroNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro'Cannot add more than 2 records for the same drug name.Amphetamine-DextroNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro'Cannot add more than 2 records for the same drug name.insert into receving(inv,drug_info_id,drug_id,drug_name,csos,po,date_received,qty_received,received_by,physical_count)values('RECEIVING','','0950-01','Amphetamine-Dextro','25x100002','874414721','01 07 2025','300','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Fentanyl'Cannot add more than 2 records for the same drug name.insert into receving(inv,drug_info_id,drug_id,drug_name,csos,po,date_received,qty_received,received_by,physical_count)values('RECEIVING','','9119-98','Fentanyl','25x100002','874414721','01 07 2025','15','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'FENTANYL'Cannot add more than 2 records for the same drug name.FENTANYLNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'HYDROCODONE/APAP'Cannot add more than 2 records for the same drug name.insert into receving(inv,drug_info_id,drug_id,drug_name,csos,po,date_received,qty_received,received_by,physical_count)values('RECEIVING','','0125-05','HYDROCODONE/APAP','25x100002','874414721','01 07 2025','500','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Hydrocodone-Acetaminophen'Cannot add more than 2 records for the same drug name.Hydrocodone-AcetaminophenNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Lisdexamfetamine Dimesyl'Cannot add more than 2 records for the same drug name.Lisdexamfetamine DimesylNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro'Cannot add more than 2 records for the same drug name.insert into receving(inv,drug_info_id,drug_id,drug_name,csos,po,date_received,qty_received,received_by,physical_count)values('RECEIVING','','0765-37','Amphetamine-Dextro','25x100002','874414721','01 07 2025','100','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro ER'Cannot add more than 2 records for the same drug name.Amphetamine-Dextro ERNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'OXYCODONE'Cannot add more than 2 records for the same drug name.OXYCODONENew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'OXYCODONE'Cannot add more than 2 records for the same drug name.OXYCODONENew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Oxycodone-Acetaminophen'Cannot add more than 2 records for the same drug name.Oxycodone-AcetaminophenNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro'Cannot add more than 2 records for the same drug name.insert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0164-01','Amphetamine-Dextro','Deborah Newton','2007578','60','12 16 2024','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Lisdexamfetamine Dimesyl'Cannot add more than 2 records for the same drug name.insert into receving(inv,drug_info_id,drug_id,drug_name,csos,po,date_received,qty_received,received_by,physical_count)values('RECEIVING','','3569-01','Lisdexamfetamine Dimesyl','25x100014','878034690','01 28 2025','200','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Oxycod+Acetamin'New record created successfullySELECT LAST_INSERT_ID() as id FROM drug_info121insert into receving(inv,drug_info_id,drug_id,drug_name,csos,po,date_received,qty_received,received_by,physical_count)values('RECEIVING','121','0522-01','Oxycod+Acetamin','25x100013','877875388','01 27 2025','200','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Morphine Sulf ER'Cannot add more than 2 records for the same drug name.insert into receving(inv,drug_info_id,drug_id,drug_name,csos,po,date_received,qty_received,received_by,physical_count)values('RECEIVING','','1790-03','Morphine Sulf ER','25x100011','877409158','01 23 2025','60','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'ADZENYS XR-ODT'Cannot add more than 2 records for the same drug name.Adzenys XR-ODTinsert into receving(inv,drug_info_id,drug_id,drug_name,csos,po,date_received,qty_received,received_by,physical_count)values('RECEIVING','','0020-30','ADZENYS XR-ODT','25x100028','881911294','02 18 2025','30','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'COTEMPLA XR-ODT'Cannot add more than 2 records for the same drug name.Cotempla XR-ODTinsert into receving(inv,drug_info_id,drug_id,drug_name,csos,po,date_received,qty_received,received_by,physical_count)values('RECEIVING','','0300-30','COTEMPLA XR-ODT','25x100028','881911294','02 18 2025','30','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS'Cannot add more than 2 records for the same drug name.Amphetamine-Dextroinsert into receving(inv,drug_info_id,drug_id,drug_name,csos,po,date_received,qty_received,received_by,physical_count)values('RECEIVING','','0950-01','AMPHETAMINE+DEXTRO SALTS','25x100028','881911294','02 18 2025','500','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'ADZENYS XR-ODT'Cannot add more than 2 records for the same drug name.ADZENYS XR-ODTNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'LISDEXAMFETAMINE (VYVANSE)'Cannot add more than 2 records for the same drug name.insert into receving(inv,drug_info_id,drug_id,drug_name,csos,po,date_received,qty_received,received_by,physical_count)values('RECEIVING','','0028-09','LISDEXAMFETAMINE (VYVANSE)','25x100027','881321159','02 14 2025','90','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'OXYCODONE'Cannot add more than 2 records for the same drug name.OXYCODONENew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'OXYCODONE/APAP'Cannot add more than 2 records for the same drug name.Oxycodone-Acetaminopheninsert into receving(inv,drug_info_id,drug_id,drug_name,csos,po,date_received,qty_received,received_by,physical_count)values('RECEIVING','','0103-50','OXYCODONE/APAP','25x100027','881321159','02 14 2025','500','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'COTEMPLA XR-ODT'Cannot add more than 2 records for the same drug name.Cotempla XR-ODTinsert into receving(inv,drug_info_id,drug_id,drug_name,csos,po,date_received,qty_received,received_by,physical_count)values('RECEIVING','','0300-30','COTEMPLA XR-ODT','25x100026','881101466','02 13 2025','30','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'COTEMPLA XR-ODT'Cannot add more than 2 records for the same drug name.Cotempla XR-ODTinsert into receving(inv,drug_info_id,drug_id,drug_name,csos,po,date_received,qty_received,received_by,physical_count)values('RECEIVING','','0300-30','COTEMPLA XR-ODT','25x100026','881101466','02 13 2025','30','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS'Cannot add more than 2 records for the same drug name.Amphetamine-DextroAmphet Saltsinsert into receving(inv,drug_info_id,drug_id,drug_name,csos,po,date_received,qty_received,received_by,physical_count)values('RECEIVING','','0948-01','AMPHETAMINE+DEXTRO SALTS','25x100026','881101466','02 13 2025','300','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'ADZENYS XR-ODT'Cannot add more than 2 records for the same drug name.Adzenys XR-ODTinsert into receving(inv,drug_info_id,drug_id,drug_name,csos,po,date_received,qty_received,received_by,physical_count)values('RECEIVING','','0020-30','ADZENYS XR-ODT','25x100024','880675186','02 11 2025','30','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'ADZENYS XR-ODT'Cannot add more than 2 records for the same drug name.Adzenys XR-ODTinsert into receving(inv,drug_info_id,drug_id,drug_name,csos,po,date_received,qty_received,received_by,physical_count)values('RECEIVING','','0020-30','ADZENYS XR-ODT','25x100025','880908859','02 12 2025','30','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'COTEMPLA XR-ODT'Cannot add more than 2 records for the same drug name.COTEMPLA XR-ODTNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS'Cannot add more than 2 records for the same drug name.Amphetamine-DextroAmphet Saltsinsert into receving(inv,drug_info_id,drug_id,drug_name,csos,po,date_received,qty_received,received_by,physical_count)values('RECEIVING','','0952-01','AMPHETAMINE+DEXTRO SALTS','25x100025','880908859','02 12 2025','400','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'LISDEXAMFETAMINE (VYVANSE)'Cannot add more than 2 records for the same drug name.insert into receving(inv,drug_info_id,drug_id,drug_name,csos,po,date_received,qty_received,received_by,physical_count)values('RECEIVING','','0564-01','LISDEXAMFETAMINE (VYVANSE)','25x100025','880908859','02 12 2025','100','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'ADZENYS XR-ODT'Cannot add more than 2 records for the same drug name.Adzenys XR-ODTinsert into receving(inv,drug_info_id,drug_id,drug_name,csos,po,date_received,qty_received,received_by,physical_count)values('RECEIVING','','0025-30','ADZENYS XR-ODT','25x10019','879445906','02 04 2025','30','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Fentanyl'Cannot add more than 2 records for the same drug name.FentanylNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'FENTANYL'Cannot add more than 2 records for the same drug name.FENTANYLNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Fentanyl'Cannot add more than 2 records for the same drug name.FentanylNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'METHYLPHENIDATE ER'Cannot add more than 2 records for the same drug name.insert into receving(inv,drug_info_id,drug_id,drug_name,csos,po,date_received,qty_received,received_by,physical_count)values('RECEIVING','','0727-01','METHYLPHENIDATE ER','25x100022','880158888','02 10 2025','200','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'METHYLPHENIDATE ER'Cannot add more than 2 records for the same drug name.insert into receving(inv,drug_info_id,drug_id,drug_name,csos,po,date_received,qty_received,received_by,physical_count)values('RECEIVING','','0725-01','METHYLPHENIDATE ER','25x100022','880158888','02 10 2025','200','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS ER'Cannot add more than 2 records for the same drug name.Amphetamine-Dextro ERinsert into receving(inv,drug_info_id,drug_id,drug_name,csos,po,date_received,qty_received,received_by,physical_count)values('RECEIVING','','3061-11','AMPHETAMINE+DEXTRO SALTS ER','25x100022','880158888','02 10 2025','400','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Azstarys'Cannot add more than 2 records for the same drug name.AzstarysNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'COTEMPLA XR-ODT'Cannot add more than 2 records for the same drug name.Cotempla XR-ODTinsert into receving(inv,drug_info_id,drug_id,drug_name,csos,po,date_received,qty_received,received_by,physical_count)values('RECEIVING','','0300-30','COTEMPLA XR-ODT','25x100020','879662997','02 05 2025','30','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro'Cannot add more than 2 records for the same drug name.insert into receving(inv,drug_info_id,drug_id,drug_name,csos,po,date_received,qty_received,received_by,physical_count)values('RECEIVING','','0164-01','Amphetamine-Dextro','24x100206','866935991','11 22 2024','300','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AZSTARYS'Cannot add more than 2 records for the same drug name.AZSTARYSNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'COTEMPLA XR-ODT'Cannot add more than 2 records for the same drug name.COTEMPLA XR-ODTNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'ADZENYS XR-ODT'Cannot add more than 2 records for the same drug name.ADZENYS XR-ODTNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Methylphenidate hcl'Cannot add more than 2 records for the same drug name.Methylphenidate hclNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'OXYCODONE/APAP'Cannot add more than 2 records for the same drug name.OXYCODONE/APAPNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Lisdexamfetamine Dimesyl'Cannot add more than 2 records for the same drug name.insert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','3569-01','Lisdexamfetamine Dimesyl','james le','2007867','30','01 14 2025','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro ER'Cannot add more than 2 records for the same drug name.Amphetamine-Dextro ERNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'COTEMPLA XR-ODT'Cannot add more than 2 records for the same drug name.COTEMPLA XR-ODTNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'OXYCODONE/APAP'Cannot add more than 2 records for the same drug name.OXYCODONE/APAPNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS ER'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTS ERNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'COTEMPLA XR-ODT'Cannot add more than 2 records for the same drug name.COTEMPLA XR-ODTNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'HYDROMORPHONE'Cannot add more than 2 records for the same drug name.HYDROMORPHONENew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'HYDROCODONE/APAP'Cannot add more than 2 records for the same drug name.HYDROCODONE/APAPNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'ADZENYS XR-ODT'Cannot add more than 2 records for the same drug name.ADZENYS XR-ODTNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'COTEMPLA XR-ODT'Cannot add more than 2 records for the same drug name.COTEMPLA XR-ODTNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Dexmethylphenidate hcl ER'Cannot add more than 2 records for the same drug name.Dexmethylphenidate hcl ERNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'DEXMETHYLPHEN ER'Cannot add more than 2 records for the same drug name.DEXMETHYLPHEN ERNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Lisdexamfetamine Dimesyl'Cannot add more than 2 records for the same drug name.Lisdexamfetamine DimesylNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'LISDEXAMFETAMINE (VYVANSE)'Cannot add more than 2 records for the same drug name.insert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','0564-01','LISDEXAMFETAMINE (VYVANSE)','tiffany shaw','2007864','30','01 13 2025','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Hydrocodone-Acetaminophen'Cannot add more than 2 records for the same drug name.Hydrocodone-AcetaminophenNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'ADZENYS XR-ODT'Cannot add more than 2 records for the same drug name.ADZENYS XR-ODTNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'MORPHINE SULF ER'Cannot add more than 2 records for the same drug name.MORPHINE SULF ERNew record updated successfullyconnection madeconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS ER'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTS ERNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro ER'Cannot add more than 2 records for the same drug name.Amphetamine-Dextro ERNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Methylphenidate LA'Cannot add more than 2 records for the same drug name.Methylphenidate LANew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Lisdexamfetamine Dimesyl'Cannot add more than 2 records for the same drug name.Lisdexamfetamine DimesylNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro ER'Cannot add more than 2 records for the same drug name.Amphetamine-Dextro ERNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'OXYCODONE'Cannot add more than 2 records for the same drug name.OXYCODONENew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'OXYCODONE/APAP'Cannot add more than 2 records for the same drug name.OXYCODONE/APAPNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS'Cannot add more than 2 records for the same drug name.Amphetamine-Dextroinsert into receving(inv,drug_info_id,drug_id,drug_name,csos,po,date_received,qty_received,received_by,physical_count)values('RECEIVING','','0953-01','AMPHETAMINE+DEXTRO SALTS','25x100029','882352151','02 20 2025','400','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS'Cannot add more than 2 records for the same drug name.Amphetamine-Dextroinsert into receving(inv,drug_info_id,drug_id,drug_name,csos,po,date_received,qty_received,received_by,physical_count)values('RECEIVING','','0808-01','AMPHETAMINE+DEXTRO SALTS','25x100029','882352151','02 20 2025','400','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS ER'Cannot add more than 2 records for the same drug name.insert into receving(inv,drug_info_id,drug_id,drug_name,csos,po,date_received,qty_received,received_by,physical_count)values('RECEIVING','','3063-11','AMPHETAMINE+DEXTRO SALTS ER','25x100029','882352151','02 20 2025','200','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS ER'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTS ERNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro'Cannot add more than 2 records for the same drug name.Amphetamine-DextroNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Amphetamine-Dextro ER'Cannot add more than 2 records for the same drug name.Amphetamine-Dextro ERNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'OXYCODONE'Cannot add more than 2 records for the same drug name.OXYCODONENew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'METHYLPHENIDATE'Cannot add more than 2 records for the same drug name.METHYLPHENIDATENew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS ER'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTS ERNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'METHYLPHENIDATE ER'Cannot add more than 2 records for the same drug name.METHYLPHENIDATE ERNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Methylphenidate hcl'Cannot add more than 2 records for the same drug name.Methylphenidate hclNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'HYDROMORPHONE'Cannot add more than 2 records for the same drug name.HYDROMORPHONENew record updated successfullyconnection madeconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'DEXMETHYLPHENIDATE ER'Cannot add more than 2 records for the same drug name.insert into receving(inv,drug_info_id,drug_id,drug_name,csos,po,date_received,qty_received,received_by,physical_count)values('RECEIVING','','0009-01','DEXMETHYLPHENIDATE ER','25x100030','882802386','02 24 2025','100','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'HYDROMORPHONE'Cannot add more than 2 records for the same drug name.Hydromorphone hclinsert into receving(inv,drug_info_id,drug_id,drug_name,csos,po,date_received,qty_received,received_by,physical_count)values('RECEIVING','','3244-01','HYDROMORPHONE','25x100030','882802386','02 24 2025','200','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'OXYCODONE/APAP'Cannot add more than 2 records for the same drug name.OXYCODONE/APAPNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'DEXMETHYLPHENIDATE ER'Cannot add more than 2 records for the same drug name.DEXMETHYLPHENIDATE ERNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'DEXMETHYLPHENIDATE'Cannot add more than 2 records for the same drug name.DEXMETHYLPHENIDATENew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'METHYLPHENIDATE LA'Cannot add more than 2 records for the same drug name.METHYLPHENIDATE CDinsert into dispensing(inv,drug_info_id,drug_id,drug_name,patient_name,rx,qty_dispensed,date_dispensed,physical_count,dispensed_by)values('DISPENSING','','1820-01','METHYLPHENIDATE LA','maximilian shaffer','2007892','30','02 24 2025','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'METHYLPHENIDATE ER'Cannot add more than 2 records for the same drug name.METHYLPHENIDATE ERNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'METHYLPHENIDATE ER'Cannot add more than 2 records for the same drug name.METHYLPHENIDATE ERNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'METHYLPHENIDATE ER'Cannot add more than 2 records for the same drug name.METHYLPHENIDATE ERNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'OXYCODONE'Cannot add more than 2 records for the same drug name.OXYCODONENew record updated successfullyconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'ADZENYS XR-ODT'Cannot add more than 2 records for the same drug name.ADZENYS XR-ODTNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Hydrocodone-Acetaminophen'Cannot add more than 2 records for the same drug name.Hydrocodone-AcetaminophenNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'METHYLPHENIDATE'Cannot add more than 2 records for the same drug name.METHYLPHENIDATENew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS ER'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTS ERNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'OXYCODONE/APAP'Cannot add more than 2 records for the same drug name.OXYCODONE/APAPNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'HYDROCODONE/HOMATROPINE'Cannot add more than 2 records for the same drug name.HYDROCODONE/HOMATROPINENew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Lisdexamfetamine Dimesyl'Cannot add more than 2 records for the same drug name.Lisdexamfetamine DimesylNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Dexmethylphenidate hcl ER'Cannot add more than 2 records for the same drug name.Dexmethylphenidate hcl ERNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'OXYCODONE/APAP'Cannot add more than 2 records for the same drug name.OXYCODONE/APAPNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'ADZENYS XR-ODT'Cannot add more than 2 records for the same drug name.ADZENYS XR-ODTNew record updated successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Oxycodone HCL 5mg/5ml'New record created successfullySELECT LAST_INSERT_ID() as id FROM drug_info122insert into receving(inv,drug_info_id,drug_id,drug_name,csos,po,date_received,qty_received,received_by,physical_count)values('RECEIVING','122','1174-01','Oxycodone HCL 5mg/5ml','24x0012546','87595879','02 13 2024','473','','')New record created successfullyconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'Lisdexamf DIM CP'New record created successfullySELECT LAST_INSERT_ID() as id FROM drug_info123insert into receving(inv,drug_info_id,drug_id,drug_name,csos,po,date_received,qty_received,received_by,physical_count)values('RECEIVING','123','0566-01','Lisdexamf DIM CP','25x100030','882802386','02 24 2025','100','','')New record created successfullyconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeSELECT COUNT(*) as count FROM drug_info WHERE drug_name = 'AMPHETAMINE+DEXTRO SALTS'Cannot add more than 2 records for the same drug name.AMPHETAMINE+DEXTRO SALTSNew record updated successfullyconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection madeconnection made