The table is as follows: Code when Unity reads and calls: If you want to view another table in the database, instead of using Table[1] directly, you need to change the table name in Code: using System.Collections; using System.Collections.Generic; using UnityEngine; using MySql.Data.MySqlClient; using System.Data; using System; public class getGameUserAccount : MonoBehaviour { // Start is called before the first frame update void Start() { mySqlCon(); } // Update is called once per frame void Update() { } public void mySqlCon() { //Database login data string conStr = "server=localhost;User Id = root;password=123456;Database=gamerdata;charset=utf8"; //Establish connection //Call MySqlConnection while instantiating, pass in parameters //I personally think the parameters here are directly input in CMD, the string format is directly similar to typing it into cmd MySqlConnection myCon = new MySqlConnection(conStr); //Open the connection myCon.Open(); //Insert data, where useraccount is the table name and the table format is in brackets/* //The comment here is because you cannot add values with the same primary key MySqlCommand myCmd = new MySqlCommand("insert into useraccount(id,nickname,password) values (4,'list','testList')", myCon); if (myCmd.ExecuteNonQuery() > 0) { Debug.Log("Query Success!"); } */ //Query data string selStr = "select * from useraccount"; MySqlCommand mySelect = new MySqlCommand(selStr, myCon); DataSet ds = new DataSet(); try { MySqlDataAdapter da = new MySqlDataAdapter(selStr, myCon); da.Fill(ds); Debug.Log(ds.Tables[0].Rows[0][0]); Debug.Log(ds.Tables[0].Rows[0][1]); Debug.Log(ds.Tables[0].Rows[0][2]); Debug.Log(ds.Tables[0].Rows[0][3]); //Table[0].Rows[0][0] Debug.Log("Query Success!"); } catch (Exception e) { throw new Exception("SQL:" + selStr + "\n" + e.Message.ToString()); } myCon.Close(); } } This is the end of this article about how to read tables when Unity connects to MySQL. For more information about how to read table content when Unity connects to MySQL, please search for previous articles on 123WORDPRESS.COM or continue to browse the following related articles. I hope you will support 123WORDPRESS.COM in the future! You may also be interested in:
|
<<: Detailed explanation of the sticky position attribute in CSS
>>: 12 Javascript table controls (DataGrid) are sorted out
1. What is a transaction? A database transaction ...
Implementation ideas The outermost is a big circl...
Introduction I will write about the problem I saw...
Database modification or deletion operations may ...
Maybe everyone knows that js execution will block...
Table of contents 1. Background 2. Prerequisites ...
Table of contents Preface Creation steps Create a...
Table of contents The basic principle of MySQL ma...
Preface Slow system calls refer to system calls t...
Table of contents Preface 1. Split a string 2. JS...
This article uses examples to illustrate the opti...
Why doesn't your height:100% work? This knowl...
The div+css layout to achieve 2-end alignment is ...
<br />Sometimes you may be asked questions l...
A Thorough Analysis of HTML (14) Special Characte...