如何使 Mysql 中的整个表与 phpmyadmin 中另一表中的一个数据变量相关联？
期望的结果：
我希望ticket_table（ticket_table、ticket_description、type_menu、status_menu、priority_menu）中的所有变量一次与一个project_name相关联。我希望每次提交新的工单时，ticket_table 中的所有数据变量都将被提交并与项目名称相关联。
项目表
---------------------------------------
id | project_name | description
---------------------------------------
1 | Project 1 | This is a description of what project one is
2 | Project 2 | This is a description of what project two is
3 | Project 3 | This is a description of what project three is
票证表
--------------------------------------------------------------------------
id | ticket_title | ticket_descr | type_menu | priority_menu | status menu
--------------------------------------------------------------------------
1 | Name of tik | Desc of tik | Issue | Low | Open
2 | Name of tik | Desc of tik | Bug | High | Resolved
3 | Name of tik | Desc of tik | Other | Med | In Progress
Desired outcome:
I want all the variables from ticket_table (ticket_table, ticket_description, type_menu, status_menu, priority_menu) to correlate to one project_name at a time. I would like every time there is a new ticket submitted, all the data variables from ticket_table will be submitted and correlated to a project_name.
project_table
---------------------------------------
id | project_name | description
---------------------------------------
1 | Project 1 | This is a description of what project one is
2 | Project 2 | This is a description of what project two is
3 | Project 3 | This is a description of what project three is
ticket_table
--------------------------------------------------------------------------
id | ticket_title | ticket_descr | type_menu | priority_menu | status menu
--------------------------------------------------------------------------
1 | Name of tik | Desc of tik | Issue | Low | Open
2 | Name of tik | Desc of tik | Bug | High | Resolved
3 | Name of tik | Desc of tik | Other | Med | In Progress
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论