<div>
Is this a stored function? If so, check the SQL code that calls this function and make sure &quot;contact&quot; is not already used as an alias in there within the same session.
</div>


Is this a stored function? If so, check the SQL code that calls this function and make sure "contact" is not already used as an alias in there within the same session.

<div>
Hi,<br />
This is not stored function at all. I am running it under phpmyadmin.<br />
<br />
Thanks
</div>


Hi,
This is not stored function at all. I am running it under phpmyadmin.

Thanks

<div>
What is the scenario I don't understand your question are you updating using two tables ?? can you post image for your table??
</div>


What is the scenario I don't understand your question are you updating using two tables ?? can you post image for your table??

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I am using following SQL <br />
<br />
update email a, contact b<br />
set a.email = &nbsp;CONCAT('abcd+' ,b.first_name,', ',b.last_name, '@gmail.com') &nbsp;<br />
where a.contact_id=b.id<br />
<br />
I have an error <br />
&nbsp;#1442 - Can't update table 'contact' in stored function/trigger because it is already used by statement which invoked this stored function/trigger.<br />
<br />
There are no triggers on the table.<br />
<br />
Thanks
</div>
</div>


Hi,

I am using following SQL 

update email a, contact b
set a.email =  CONCAT('abcd+' ,b.first_name,', ',b.last_name, '@gmail.com')  
where a.contact_id=b.id

I have an error 
 #1442 - Can't update table 'contact' in stored function/trigger because it is already used by statement which invoked this stored function/trigger.

There are no triggers on the table.

Thanks

MySQL Table update returning error

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

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.