MySQL Forums
Forum List  »  Stored Procedures

Re: Stored Procedure to create table
Posted by: Mike Demaris
Date: July 15, 2022 11:10AM

If I understand correctly, move the data using SELECT INTO OUTFILE, then LOAD INFILE into a intermediate table, then insert from there into the new tables?

By table glut, it sounds like you're not a fan of storing large amounts of machine data, correct? I don't see how this is unavoidable, as the HMI stores this data in such a format. Obviously we do not need to keep the data for long periods of time, however, depending on the nature of the data and the frequency interval some of this data will need to kept around longer.

I'm glad you clarified the Prepare a bit, as I was unclear as to why sometimes the DECLARE statement is used without the @ symbol, and some statements do not seem to like certain variables. The other issue regarding the @var, is I understand it to be a larger scoped variable, as in usable outside the procedure, which caused me to wonder why it's used within the procedure.

Options: ReplyQuote

Written By
Re: Stored Procedure to create table
July 15, 2022 11:10AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.