<div>
Please rephrase your question. Post a concise and complete example. Include sample data..
</div>


<div>
Is the product ID numeric or alphanumeric? &nbsp;You want a trigger to fire on an insert to the table or an update to the table or both events? &nbsp;When you say &quot;attaching +0001,&quot; do you mean to append to the value of product ID four characters of &quot;0001&quot;? &nbsp;I want to make sure you aren't talking about prepending it or mathematically adding the value of 0001 to the ID.<br />
<br />
This gives information about creating triggers:<br />
<br />
<a href="http://dev.mysql.com/doc/refman/5.0/en/create-trigger.html" rel="ugc">http://dev.mysql.com/doc/refman/5.0/en/create-trigger.html</a>
</div>


<div>
Dear Phil<br />
The product ID is alphanumeric.<br />
The situation is like this<br />
<br />
Product : Apple<br />
Product ID : UID903456790090<br />
<br />
Product : Orange<br />
Product ID :UID903456790093<br />
<br />
These two products have the first 10 character same.<br />
I am displaying only the first 10 to the customer for some reason.<br />
When I am displaying it if the customer calls in and says the product ID he will be able to say only the first 10<br />
So my search string on the database will retrieve two records.<br />
So am planning to attach a sequence to the product ID with 0001 for the first record and any duplicate product ID for the first 10 character will have it 0002. I will be creating a separate column for this sequence and while displaying it in the website I will be attaching them.
</div>


<div>
<div class="content wysiwyg-content">
I have a website where the Users enter the product information by Single entry or through the batch upload of CSV file. In both cases the records get inserted to the same table which is in My SQL database.<br />
The information is then retrieved and shown in the website too. &nbsp;There is a product id column which has 20 characters. But when we are displaying it in the website we show only the first 10 records. As the next 10 are critical and is not displayed. Though the product ID is a unique column the first 10 characters are not unique. So I will be attaching product id +0001 when the information is displayed outside. So I prefer to insert a column in the existing table. The column will get update with product id +0001 on the first entry. Whenever there is a duplicate record gets inserted in the product id by matching the first 10 characters the sequence should be predicted +0002.<br />
So I need a trigger and sequence code in mysql for this. Please help.
</div>
</div>


I have a website where the Users enter the product information by Single entry or through the batch upload of CSV file. In both cases the records get inserted to the same table which is in My SQL database.
The information is then retrieved and shown in the website too.  There is a product id column which has 20 characters. But when we are displaying it in the website we show only the first 10 records. As the next 10 are critical and is not displayed. Though the product ID is a unique column the first 10 characters are not unique. So I will be attaching product id +0001 when the information is displayed outside. So I prefer to insert a column in the existing table. The column will get update with product id +0001 on the first entry. Whenever there is a duplicate record gets inserted in the product id by matching the first 10 characters the sequence should be predicted +0002.
So I need a trigger and sequence code in mysql for this. Please help.

Trigger in My SQL

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

MySQL Server

Web development can range from developing the simplest static single page of plain text to the most complex web-based internet applications, electronic businesses, and social network services using a wide variety of languages and standards, including the familiar HTML, JavaScript and jQuery, ASP and ASP.NET, PHP, ColdFusion, CSS, PHP, Flex and Flash, but also the implementation of a broad list of standards including XML, WSDL, SSDL, VoiceXML and many more.