MySQL databases are relational data management systems that require a server to reside in. We interface with these databases with user accounts established by the database administrator. We use MySQL syntax, which is a specific query language, to read, write, and modify the database. In this recipe, you will learn how to connect to a MySQL database, how to read it, and how to modify it.
You will need to know the specific address of your database, the username, the password, and the port number.
Use the following information to integrate the MySQL database interaction into your mobile app:
To connect to a MySQL database, we use the following code. Be sure to replace each
_____
with your actual data:global dbID local dbAddress, dbName, dbUser, dbPassword put "_____" into dbAddress put "_____" into dbName put "_____" into dbUser put "_____" into dbPassword put revOpenDatabase("MySQL", dbAddress, dbName, dbUser, dbPassword) into dbID
Our second major function...