void Start() { try { MySqlDB mysql = new MySqlDB(); //mysql.CreateTableAutoID("momo",new string[]{"id","name","qq","email","blog"}, new string[]{"int","text","text","text","text"}); //mysql.InsertInto("momo",new string[]{"name","qq","email","blog"},new string[]{"xuanyusong","289187120","*****@*****.**","xuanyusong.com"}); //mysql.InsertInto("momo",new string[]{"name","qq","email","blog"},new string[]{"ruoruo","34546546","*****@*****.**","xuanyusong.com"}); //DataSet ds = mysql.SelectWhere("momo",new string[]{"name","qq"},new string []{"id"},new string []{"="},new string []{"1"}); DataTable dt = mysql.SelectLimitLines("momo",0,100); if(dt != null) { foreach (DataRow row in dt.Rows) { foreach (DataColumn column in dt.Columns) { Debug.Log(row[column]); } } } //mysql.UpdateInto("momo",new string[]{"name","qq"},new string[]{"'ruoruo'","'11111111'"}, "email", "'*****@*****.**'" ); //mysql.Delete("momo",new string[]{"id","email"}, new string[]{"1","'*****@*****.**'"} ); mysql.Close(); }catch(Exception e) { Error = e.Message; } }
void Start() { Application.runInBackground = true; //Screen.SetResolution(804, 673, false); mysqldb = new MySqlDB(); DataTable dt = mysqldb.SelectLimitLines(tableName, startLine, 1); linesPerFrame = int.Parse(dt.Rows[0][1].ToString()); startLine++; InvokeRepeating("ReadOneFrameFromMySql", 0f, interval); }