I'm trying to:
- create an empty copy of a table
- insert all the data from the original to the copy
query I'm using is:
CREATE TABLE my_schema.account_copy_like LIKE my_schema.account; -- To inherit all table definitions
INSERT INTO my_schema.account_copy_like SELECT * FROM my_schema.account; -- Copying data from another table
The issue here is that the
INSERT INTO... SLEECT * FROM
is not copying as expected, there are some discrepancies on the table information as you can compare on the table size and rows, I was wondering why. It seems that in the copy table it has more rows than the original but it's size is lower?


Asked by Retrosec6
(13 rep)
Oct 17, 2022, 08:09 PM
Last activity: Oct 17, 2022, 08:51 PM
Last activity: Oct 17, 2022, 08:51 PM