When we are working with the Joomla! database, we need be aware of and follow certain naming conventions. If we are creating an extension that will store data in the database, it is important to extend the database correctly. More information on extending the database with components is available in Chapter 5, Component Design.
When we install Joomla!, we configure the database settings which include the Database Prefix. This prefix (the default is
jos_ ) is prepended to every table name when the table is created; its purpose is to allow a single database to manage multiple Joomla! installations.
When we write SQL queries, to accommodate the variable table prefix, we must use a symbolic prefix that is substituted ...