Re^6: Splitting the records into multiple worksheets

in reply to Re^5: Splitting the records into multiple worksheets
in thread Splitting the records into multiple worksheets

$dbh->do("INSERT INTO ExcelData SET name = '$name', data = $data");

I would not advocate that approach. Far safer to use placeholders.

🦛

Comment on Re^6: Splitting the records into multiple worksheets Download Code

Replies are listed 'Best First'.
Re^7: Splitting the records into multiple worksheets by Bod (Parson) on Feb 21, 2021 at 19:33 UTC
I do limit the privileges of the script's DB account to SELECT, INSERT, UPDATE, DELETE and CREATE TEMPORARY TABLE	[reply]
Re^8: Splitting the records into multiple worksheets by marto (Cardinal) on Feb 21, 2021 at 21:22 UTC
Which is enough to cause serious problems.... hence the tried and tested safe methods of working.	[reply]
Re^9: Splitting the records into multiple worksheets by Bod (Parson) on Feb 21, 2021 at 23:54 UTC
tried and tested safe methods of working I have never heard of this methodology...are you referring to something like this or is there something else I need to discover?	[reply]
Re^10: Splitting the records into multiple worksheets by marto (Cardinal) on Feb 22, 2021 at 07:41 UTC

In Section Seekers of Perl Wisdom