开发者

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.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜