Some of the statements in the table are not covered here because they are more appropriately discussed in other chapters.
For example, operations to be performed from the command line.
This chapter points out such equivalences where appropriate.
This chapter builds on that material to go into more detail on several areas of SQL implemented by My SQL.
It discusses how to refer to elements of databases, including the rules for naming and the case sensitivity constraints that apply.
That is not true for SQL keywords, function names, or column and index names, all of which can be referred to in varying lettercase style throughout a query.
The process of updating or editing a record or row of a table makes use of the trusty mysql_query() function.
These queries are send as a string to the My SQL server.
To create a table in a My SQL database, use the "" sets the transfer of data between PHP and My SQL to be made with UTF-8 encoding.
In the syntax shown below we see that the UPDATE procedure requires the SET and WHERE definitions to pinpoint the changes.
The statement below would require that all 4 fields of the specified row be passed to the processing script.
The first variant is more simple, in this lesson it's presented the exec method.