Help for this page

Select Code to Download


  1. or download this
    my $statement = <<'__SQL__';
SELECT *
...

my $rv = $sth->execute($client)
     or die $sth->errstr;
  2. or download this
    SELECT *
   FROM t_user_portal
   WHERE f_client = 'lanx'
  3. or download this
    PREPARE stmt1 FROM 'SELECT * FROM t_user_portal WHERE f_client = ?';
SET @client = 'lanx';
EXECUTE stmt1 USING @client;