PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
Displaying 31 to 32
of 32 total results
- « Previous
- 1
- 2
- 3
- 4
https://dev.mysql.com/doc/refman/5.7/en/stored-routines-syntax.html
MySQL supports a very useful extension that enables the use of regular SELECT statements (that is, without using cursors or local variables) inside a stored procedure. A stored routine is either a procedure or a function. Stored routines are ...
https://dev.mysql.com/doc/refman/5.7/en/ansi-diff-select-into-table.html
The same syntax can also be used inside stored routines using cursors and local variables. For example: INSERT INTO tbl_temp2 (fld_id) SELECT tbl_temp1.fld_order_id FROM tbl_temp1 WHERE tbl_temp1.fld_order_id > 100; Alternatively, you can use SELECT ...