Home  >  Q&A  >  body text

Database - java design table prefix meaning

java Why does the Mybatis system add table prefixes when designing tables? Are there any disadvantages in not adding them?

Thanks

世界只因有你世界只因有你2686 days ago725

reply all(4)I'll reply

  • PHP中文网

    PHP中文网2017-06-12 09:23:42

    Obviously to distinguish projects. When there are many database tables, table prefixes can be used to achieve faster search, maintenance, etc.

    reply
    0
  • 给我你的怀抱

    给我你的怀抱2017-06-12 09:23:42

    This is really a poor design. Different databases should be used to distinguish projects!

    reply
    0
  • 给我你的怀抱

    给我你的怀抱2017-06-12 09:23:42

    This is a habit developed by old programmers for future generations haha

    reply
    0
  • PHP中文网

    PHP中文网2017-06-12 09:23:42

    Generally related to business logic.

    For example, system-related tables sys_user, sys_role, etc.
    Query related tables query_money, query_time, etc.

    reply
    0
  • Cancelreply