Description,
CodePudding user response:
"A character's product name list contains its id_manufacturer" look not to understand what you mean, first to describe the problem clearly, to solve it,CodePudding user response:
Table ps_product id_manufacturer, there is A list of name list ps_product_lang have another table name, want to set A list of name contains A character products it id_manufacturer for 3, how do I write SQL statements,- assuming tables ps_product and ps_product_lang through A connection, the SQL statement is as follows:
The update ps_product
The set id_manufacturer=3
The from ps_product inner join ps_product_lang
On ps_product. A=ps_product_lang. A
And ps_product_lang. Name like 'A %'
- never debugging, ha ha, their test, look at the help documentation should be will be
CodePudding user response:
name like 'A %' is A beginning, middle contain should be name like '% A %' ,CodePudding user response:
Two table relationship field?