Cursussen/Courses Codesnippets     Top 
B4A-JSON - MySQL database


1. MySQL workbench
To create a MySQL (or MariaDB) database you can use the MySQL workbench tool (see for a link in the Introduction - 1. References).
We will be using the same structure as in the B4A-lists tutorial but now we use a MySQL database.
With the MySQL workbench tool you can produce the following database schema:
And then from within the MySQL workbench tool you can generate the database 'translations'. Make sure that Uwamp is started and that you have created a connection to the MySQL server in the MySQL workbench tool (menu Database / Connect to database). You can find more information on this in the MySQL workbench tutorial (see link in the introduction).


2. PHPMyAdmin
With the PHPMyAdmin tool you can check if the database is created. This tool is also available in the Uwamp tool.
This is the database structure in PHPMyAdmin: