Re: PREPAREd statement

Note that the second example is more useful than the first if you will be using it more than once in a program. You can prepare it once and execute many times after changing the values in myrec. When a statement is prepared, the server parses the statement to check for syntax and determines an execution plan. By preparing once and executing many times, you cut down on the amount of work the server has to do.