It’s just establishing a connection to the database before going through the scores table and retrieving the top five scores and their respective players. Go into the SQL tab and enter the following SQL command to create this table: Since the goal is just to display the player’s name and their score, you can leave the table at that. Next, create a table containing the data needed. Open your database management program of choice and create a new database, giving it the name highscores.įigure 1: Creating a new database in WAMP using phpMyAdmin If you’re more comfortable with other database management and creation tools, then those should work just as well for this project. This demonstration uses WampServer and phpMyAdmin to create the database, PHP for server scripts, and of course, Unity and C# for app creation. A variety of tools will be used to accomplish this. Within the app itself, the top five players and their scores will be displayed. An app will be created that can receive the high scores stored within a MySQL database as well as put new data into it. With this in mind, a demonstration is in order. While a single-player focused adventure game may not need database integration, a massive racing game with thousands of players might.

Can the two work together? As is so often the case in the world of programming, the answer is a resounding “yes.” As far as the games industry is concerned, databases are most useful in applications that require items like leader boards, stat tracking, and more. The two seem to have very different goals, with one focusing on managing a database while the other is built primarily for the creation of video games. SQL is the language of data management, and Unity is a game engine.

Using MySQL with Unity - Simple Talk Skip to content

Can unity cloud build make final build