Merge virtually two mysql tables
Is there a way to merge two tables in MySQL virtually so I could query and insert data? (which is basicly splitted)
exp.
table
- id
- active
- foo
table_meta
- table_id
- language
- text
What I'd like to do is using something like this instead of sql-join
INSERT INTO 开发者_如何学Pythontable_join SET active = 1, language = 'en';
Assuming you're on mySQL 5.1.x, here is a reference on what is allowed with regards to an insertable or updatable view.
精彩评论