mysql表怎么增加栏_在MYSQL的栏内建立表格

Apologies if I am mistaken, but is there any way to create a table inside a column in MySql?

Brief: I have a table named test_table which contains a column named name test_column. Now I want to create a table inside test_column. Is this possible?

解决方案

You would create a "child" table with an id that is referenced in the column of the main table. You wouldn't create a "table" in a column.

For example

Table 1

columm_pk int

column_fk int

table 2

column_pk (this is what goes in table 1)

other columns as needed.

then you just join the tables based on that fk id. You can have multiple fk column in the first table that link to different child tables. You can also look in to SET data types in MySql although I wouldn't recommend them.

btw, If your question is MySql specific then you shouldn't use the oracle tags.