title: mysql concat and insert into not working
body: <p>i have a code in stored procedure which adds "PID-" to the id number, so if id number is 1, the result shoulb be PID-1. but it's not working.</p>
  
  <p>Here's the code:</p>
  
  <pre><code>DROP PROCEDURE `inserproducts`//
  CREATE DEFINER=`root`@`localhost` PROCEDURE `inserproducts`(pid int,pname varchar(50),pdesc varchar(50),psupp varchar(50),pdate date,pquant int)
  begin
  insert into products(productid,productname,proddescription,supplier,lastpurchasedate,quantityleft)
          values(select concat('PID',pid,pname),pdesc,psupp,pdate,pquant));
  
  select pid=last_insert_id();
  end
  </code></pre>
  
  <p>how can i join insert into and concat together? Please help me with this one.</p>