Timeline for How to create a new table from other tables that are related to each other?
Current License: CC BY-SA 4.0
8 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Dec 17, 2019 at 4:30 | comment | added | Akina | @ViniciusGabriel The destination table structure is dynamic fully. After create you may alter it - change fields definitions, add keys, etc. Of course, you may insert structure definition into the query - but in that case you must know the final structure (you cannot define it partially). | |
| Dec 17, 2019 at 1:11 | comment | added | Vinicius Gabriel |
i tested and it worked, thanks! Also, would I like with this script already define primary keys or strangers? Or only after creating the table with the alter table?
|
|
| Dec 17, 2019 at 1:10 | vote | accept | Vinicius Gabriel | ||
| Dec 16, 2019 at 17:17 | comment | added | Akina |
But in my case, all tables have relationship with each other, with Join, would result in 2 columns of the same name right? Look carefully - in my example column names id and field_1 are not unique over all tableset. The only restriction - if fieldnames in seeparate tables are identical, they ARE joined.
|
|
| Dec 16, 2019 at 17:07 | comment | added | Vinicius Gabriel | Hmmmmm, nice ideia. But in my case, all tables have relationship with each other, with Join, would result in 2 columns of the same name right? One being the primary key of one table and its foreign key in another correct table? Still would give error when creating the table due to having two columns with the same name, or I'm wrong | |
| Dec 16, 2019 at 13:24 | history | edited | Akina | CC BY-SA 4.0 |
added 718 characters in body
|
| Dec 16, 2019 at 13:19 | history | edited | Akina | CC BY-SA 4.0 |
added 718 characters in body
|
| Dec 16, 2019 at 12:48 | history | answered | Akina | CC BY-SA 4.0 |