Timeline for Create new sql table based on a query from another table MariaDb
Current License: CC BY-SA 4.0
7 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Oct 7, 2021 at 20:30 | vote | accept | mike_gundy123 | ||
| Oct 6, 2021 at 16:10 | comment | added | Rick James | @mike_gundy123 - See also mysql.rjweb.org/doc.php/deletebig#optimal_reload_of_a_table | |
| Oct 6, 2021 at 15:44 | comment | added | mike_gundy123 | Also for the truncate table option I just need to create the table once (with all the indexes chosen out) and I can constantly just truncate and add into it no problem? | |
| Oct 6, 2021 at 15:30 | comment | added | mike_gundy123 | Na, that's not the case. My table is only being updated once a day | |
| Oct 6, 2021 at 15:22 | comment | added | Rick James | @mike_gundy123 - Lots of rows coming in; many queries summarize the things like "number of items sold and the revenue from that -- for a specified day or week or whatever". | |
| Oct 6, 2021 at 13:18 | comment | added | mike_gundy123 | Hey thanks for the comment, The truncate table will work for me, and what do you mean by data warehouse? | |
| Oct 6, 2021 at 1:01 | history | answered | Rick James | CC BY-SA 4.0 |