Sample Header Ad - 728x90

INSERT INTO... SELECT * FROM not copying data correctly

0 votes
1 answer
471 views
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? Original table copy table
Asked by Retrosec6 (13 rep)
Oct 17, 2022, 08:09 PM
Last activity: Oct 17, 2022, 08:51 PM