Create outfile trigger with appended text

[Pete Tromblee]

Hi,

I have a trigger that exports a record to a csv and this works fine, however I want to add two lines of text to the beginning of the file.

This is my trigger:

CREATE DEFINER=`3pl`@`%` TRIGGER `3pl`.`app_Skus_AFTER_INSERT` AFTER INSERT ON `app_Skus` FOR EACH ROW
BEGIN
Select id,client,sku,qty,printer_name into outfile '/share/labels/labels1.csv'
fields terminated by ';'
lines terminated by '\n'
from app_Skus
where id=new.id;
END


This creates a csv file with the 5 fields I need. Now I want to add these two lines of text the the file for our label printing software:

%BTW% /AF=C:\labelfolder\ManualproductLabel.btw /D=%Trigger File Name% /PRN="IT0312" /R=3 /P
%END%

But I need the text IT0312 to be what is the field called printer_name. Is this possible with a trigger? Currently I export the file and then have a script that writes the data to the file and re-saves it. However this delays the printing of the label by a couple seconds.