Add constraint to table creation in SQL
IN MySQL 8 (&gt;= 8.0.16) You can use a CHECK CONSTRAINT
In older Versions you will need an INSERT/UPDATE TRIGGER
That said, you should also normalize your table and use a lookup (or reference/helper) table for an Origin id and a Type id.


CREATE TABLE Product 
( 
    P INT 
  , PType varchar(19)
  , PName varchar(20)
  , Price DECIMAL(8,2)
  , Origin varchar(50)
  , CONSTRAINT CHK_type CHECK ((Ptype = 'meat' AND Origin ='Europe') 
                           OR Ptype &lt;&gt; 'meat' )
);



  

INSERT INTO Product VALUES (1,'meat','Kobe Beef',10000.00,'Japan')


Check constraint 'CHK_type' is violated.




INSERT INTO Product VALUES (1,'apple','Breaburn',10.00,'New Zealand')


✓


db&lt;&gt;fiddle here