the view does not copy data to the table (menu->copy table)

us12mm's profile image us12mm posted 3 years ago in General Permalink

the view does not copy data to the table (menu->copy table) Copying creates an empty table with no data. There was no such problem when copying from the view in HeidiSQL 8. Could something change when copying from the view in the new versions?

version mysql 5.0 windows 10 HeidiSQL 11.0

ansgar's profile image ansgar posted 3 years ago Permalink

v11.0 is outdated. Please use v11.2 and retry.

Also, post a screenshot of the copy table dialog please.

us12mm's profile image us12mm posted 3 years ago Permalink

updated to the latest version 11.2 in the screenshot, there are 0 rows in the data column. Can this be due to the fact that mysql is very old version 5.0?

1 attachment(s):
  • -
us12mm's profile image us12mm posted 3 years ago Permalink

I tried to create the simplest view and it returns empty data when you copy it to the table

3 attachment(s):
  • 1
  • 2
  • 3
ansgar's profile image ansgar posted 3 years ago Permalink

I overread you were trying to copy a view, not a table. A view itself does not have rows, which the dialog is aware of. You can just create the structure copy from a view. Afterwars, you could do a INSERT INTO... SELECT FROM.. to overtake the data.

us12mm's profile image us12mm posted 3 years ago Permalink

thanks. Then I'll rewrite my request. The most interesting thing is that by version 9 of Heidisql, copying data from the view worked.

Please login to leave a reply, or register at first.