Timeline for How to create a new table from other tables that are related to each other?
Current License: CC BY-SA 4.0
6 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Dec 17, 2019 at 2:23 | answer | added | Rick James | timeline score: 1 | |
| Dec 17, 2019 at 1:10 | vote | accept | Vinicius Gabriel | ||
| Dec 16, 2019 at 17:10 | comment | added | Vinicius Gabriel |
@RickJamesOkay, maybe my explanation was not clear, but referring to the keys, I was wondering how I can dynamically insert them together with the create table structure CREATE TABLE IF NOT EXISTS table_name AS SELECT ~ select from other tables ~ . I couldn't create the keys in the same table creation query in this case, just inserting the keys after the table creation.
|
|
| Dec 16, 2019 at 16:37 | comment | added | Rick James |
Let's see SHOW CREATE TABLE. PRIMARY KEY and FOREIGN KEY (or INDEX) are important for performance, but not a requirement for JOINing.
|
|
| Dec 16, 2019 at 12:48 | answer | added | Akina | timeline score: 1 | |
| Dec 16, 2019 at 12:26 | history | asked | Vinicius Gabriel | CC BY-SA 4.0 |