Check Constraints in MySQL

Question

Hi guru We have a bunch of tables in Microsoft SQL so that each table has its own check constraint. At the end we have created a partition view that does a "UNION ALL" against these tables. Our attempts to insert into this partition view is quite successful. Select, update and delete all work properly.

We want a similar functionality in MySQL 5.4 too. Is this feasible to create such a structure at all? If yes, where can I find further information.

Thanks in advance.

Answer 1

You want MySQL's merge storage engine.