SQL for MySQL Developers: A Comprehensive Tutorial and Reference
by Rick F. van der Lans, Diane Cools
Part V. Programming with SQL
SQL can be used in two ways: interactively and preprogrammed. Preprogrammed SQL is used primarily in programs developed for end users who do not have to learn SQL statements, but who work with easy-to-use menus and screens instead.
Previous chapters have assumed interactive use of the language. Interactive means that statements are processed as soon as they are entered; with preprogrammed SQL, statements are included in a program that has been written in another programming language. Most products support, among others, the languages C, C++, Java, Visual Basic, PHP, Perl, and COBOL. These languages are known as host languages. When using preprogrammed SQL, the user cannot immediately see the results of the SQL statements; ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access