# 1526 Manual Does Not Specifically Point Out That SQL SELECT INTO Clause Overwrites Specified Table

---

I was not aware, that the "SELECT xx1, xx2 INTO TABLEyy... is actually (re-)creating TABLEyy, without any indexes. I called EmptyTable just before I called my SQL SELECT statement with the INTO clause.

The manual could be a little bit preciser in regard to the creation of the result table.