Re: How to make small tables from big table? (SELECT INTO doesn't seem to work)

[Peter Brawley]

> I get the error message: "Error Code 1327 Undefined variable new_table"

As you should. The variable has not been declared. Note such vars can be declared only in stored routines; you would need to use a user var, eg @new_table. See the manual for discussion of the differences between user vars and declared vars.

Notice the diffs amongst SELECT INTO..., SELECT INTO DUMPFILE..., SELECT INTO OUTFILE..., and SELECT INTO TABLE.... MySQL supports the first three of those (https://dev.mysql.com/doc/refman/5.7/en/select-into.html), not the last one; to select into a table use Create Table Select ...