打开cmd
cd C:\Program Files\MySQL\MySQL Server 8.0\bin打开安装目录
mysql -uroot -p06090623 进入Mysql
回到python APP的models.py
>_< 添加表,创建一个类
class UserInfo(models.Model):
mailbox = models.CharField(max_length=32)
password = models.CharField(max_length=64)
checksum = models.CharField(max_length=64)
上传
python manage.py makemigrations
python manage.py migrate
回到cmd
mysql>show databases;查看已有数据库
mysql>CREATE DATABASE test;创建新数据库
mysql>use text;打开创建好的数据库
mysql> show tables;
+----------------------------+
| Tables_in_test |
+----------------------------+
| auth_group |
| auth_group_permissions |
| auth_permission |
| auth_user |
| auth_user_groups |
| auth_user_user_permissions |
| django_admin_log |
| django_content_type |
| django_migrations |
| django_session |
| tryagain_userinfo |
+----------------------------+
11 rows in set (0.01 sec)
mysql> desc tryagain_userinfo;
+----------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------+-------------+------+-----+---------+----------------+
| id | bigint | NO | PRI | NULL | auto_increment |
| mailbox | varchar(32) | NO | | NULL | |
| password | varchar(64) | NO | | NULL | |
| checksum | varchar(64) | NO | | NULL | |
+----------+-------------+------+-----+---------+----------------+
4 rows in set (0.00 sec)
>_< 表中新增列
回到Python,在表中新增列,上传:
选择1 手动输入值
或者:
设置默认值newrow = models.IntegerField(null=True,blank=True)
或者允许为空newrow = models.IntegerField(default=2)
再上传。
使用 Mysql WorkBench
1.从首页连接一个数据库。
2.检查server status。
使用mysql workbench点击server status的错误提示,这是为什么呢?
TRuntimeError: Target host is configured as Windows, but seems to be a different OS. Please review the connection settings.
在windows设置中心-区域-其他日期、时间和区域设置-区域-管理-更改系统区域设置里面把“Beta版:使用Unicode UTF-8提供全球语言支持"的选项勾选,重启电脑