如何在mysql的现有表中添加另一个字段 [英] How to add another field in an existing table in mysql
问题描述
好的,我有这些桌子
Okay, I have these table
我这里还有另外一张桌子:
and I also have another table right here:
因此,idAlbum在Gallery表中,对此的查询是什么? 我想从一个表的一个字段中选择数据,然后将其插入到另一个表的一个字段中.
So,idAlbum is in the gallery table, what is the query for this? I want to select the data from one field in one table and insert it into a field in another table.
推荐答案
如果要在PhpMyAdmin中的现有表中添加字段,请在查看其数据的同时单击结构"选项卡,并在表结构的底部有一个不错的选择框:在表的[开始/结束]处添加[数字]字段.单击右侧的按钮并处理表格.
If you want to add a field in existing table in PhpMyAdmin, click "Structure" tab while viewing its data, and at the bottom of table structure you have nice box: "Add [number] fields at the [beginning / ending] of a table. Click the button on the right and processd with forms.
这篇关于如何在mysql的现有表中添加另一个字段的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!