#查看所有数据库
show databases;
#使用/打开teacher数据库
use teacher;
#删除teacher数据库
drop teacher;
#查看物理引擎
show engines;
#查看当前默认存储引擎
show variables like'storage_engine'%;
#修改默认存储引擎
default-storage-engine=innodb;
这里以info表为例
#查看表结构
desc info;
#查看所有表
show databases;
#删除表
drop info;
#插入一条数据
insert into info (name,sex,salary) vaules('慧妹妹'.'男'.10000);
#查询全部数据
select from info ;
#修改慧妹妹性别和工资数据
update info set sex='男',salary=9999 where name='慧妹妹';
#删除编号为1的人的信息
delete from info where id=1;
数据库与Unity连接
导入插件到Unity:
using System.Collections;
using System.Collections.Generic;
using UnityEngine;
using MySql.Data.MySqlClient;
/*
*文件描述:
*创始人:
*创建时间:
*修改时间:
*版本:1.0
*/
public class Test : MonoBehaviour
{
void Connect()
{
//1.创建连接对象
string a = "server=localhost;database=student;userid=root;password=root;";
MySqlConnection con = new MySqlConnection(a);
//2.打开连接
con.Open();
//3.创建操作指令对象
//string sql = "insert into info (name,sex,age,salary) values('甘肃','男',19,10000)";
//string sql = "update info set age=18 where name'甘肃'";
//string sql = "delete from info where id=2";
string sql = "select *from info";
MySqlCommand com = new MySqlCommand(sql, con);
//4.执行操作
// if (com.ExecuteNonQuery()>0)
// {
//print("操作成功");
// }
// else
// {
//print("操作失败");
// }
//4.获取读对象
MySqlDataReader reader = com.ExecuteReader();
//5.循环从数据库数据
while (reader.Read())
{
int id = reader.GetInt32("id");
string name = reader.GetString("name");
string sex = reader.GetString("sex");
float salary = reader.GetFloat("salary");
print(id + "\t" + name + "\t" + sex + "\t" + salary);
}
//6.关闭(释放)资源
reader.Close();
con.Close();
}
void Start()
{
Connect();
}
void Update()
{
}
}