INSERT INTO data (skey, svalue) VALUES ('Stuff', 'Ge 1:1-more &stuff& here ');

##</code><code>##

$dbh->do("INSERT OR REPLACE INTO data (skey, svalue) VALUES ('Stuff', 'Ge 1:1-more &stuff& here ''');");

##</code><code>##

$VAR1 = {
          'Stuff' => {
                       'svalue' => 'Ge 1:1-more &stuff& here \'',
                       'skey' => 'Stuff'
                     }
        };

##</code><code>##

$dbh->do(
    q/INSERT OR REPLACE INTO data (skey, svalue) VALUES ('Stuff', 'literal dollar sign: $, literal single quote: '', literal ampersand: &');/
);

##</code><code>##

my $sth = $dbh->prepare(
    'INSERT OR REPLACE INTO data (skey, svalue) VALUES (?, ?);'
);
$sth->bind_param(1, $skey);
$sth->bind_param(2, $svalue);
$sth->execute();