search

Home  >  Q&A  >  body text

java - 这种情况下,MySQL如何设置主子表?

1.上传车辆图片,图片张数不确定。
2.图片的名字保存在数据库中。
3.我设计的车辆表中的图片字段只能存放一个图片名字呀?
4.领导说让我用主子表来控制(因为上传的图片张数不确定,可能1张,也可能10多张),请问怎么设计主子表呀?

大家讲道理大家讲道理2892 days ago339

reply all(1)I'll reply

  • PHPz

    PHPz2017-04-18 09:15:02

    For one-to-many relationships, when you first start designing database tables, it is best to use a modeling tool, which will be more intuitive and convenient for future updates and maintenance
    For example, mysql official workbench, navicat

    Vehicle table
    car_id
    car_name

    Example data:
    1, Cadillac CT6
    2, Cadillac ATSL

    Vehicle image table
    car_image_id
    car_id
    image_name
    image_path

    Sample data:
    1,1,ct62016_1.jpg,cardfs/product/g22/M0A/7D/64/t_autohomecar__wKjBwVbNEOWAfW0JAAmCPGxu0pg006.jpg
    2,1,ct62016_2.jpg,cardfs/product/g20/M0B/21 /6D/t_autohomecar__wKgFWVanZ -KAYVICAAg690Apro4477.jpg
    3,2,xxxxx
    4,2,xxxxx
    4,2,xxxxx

    reply
    0
  • Cancelreply