mysql+models

cmd启动mysql

mysql -h localhost -u root -p

---

1.建立数据库

显示当前存在的数据库

删除一个数据库

---

2. 创建表格

使用数据库

mysql> use mysql_study;
Database changed
mysql> create table contacts
    -> (
    -> name char(20) not null,
    -> number char(13) not null
    -> );
Query OK, 0 rows affected (0.02 sec)

删除数据库

mysql> drop table mytable
    -> ;
Query OK, 0 rows affected (0.01 sec)

mysql> show tables;
+-----------------------+
| Tables_in_mysql_study |
+-----------------------+
| contacts              |
+-----------------------+
1 row in set (0.00 sec)

表格中增删改查

mysql> insert into contacts
    -> (name,number)
    -> values
    -> ('tony',15158235102)
    -> ;
Query OK, 1 row affected (0.01 sec)

mysql> select * from contacts
    -> ;
+------+-------------+
| name | number      |
+------+-------------+
| tony | 15158235102 |
+------+-------------+
1 row in set (0.00 sec)

mysql> insert into contacts
    -> (name,number)
    -> values
    -> ('tom',12345678)
    -> ;
Query OK, 1 row affected (0.01 sec)

mysql> select * from contacts;
+------+-------------+
| name | number      |
+------+-------------+
| tony | 15158235102 |
| tom  | 12345678    |
+------+-------------+
2 rows in set (0.00 sec)

删除操作

mysql> delete from contacts where name="tom";
Query OK, 1 row affected (0.00 sec)

mysql> select * from contracts;
ERROR 1146 (42S02): Table 'mysql_study.contracts' doesn't exist
mysql> select * from contacts;
+------+-------------+
| name | number      |
+------+-------------+
| tony | 15158235102 |
+------+-------------+
1 row in set (0.00 sec)

修改操作

查询操作

mysql> insert into contacts (name,number) values ("dany",13158235102);
Query OK, 1 row affected (0.01 sec)

mysql> select * from contacts;
+------+-------------+
| name | number      |
+------+-------------+
| tony | 13912345678 |
| dany | 13158235102 |
+------+-------------+
2 rows in set (0.00 sec)

mysql> select * from contacts where number=13158235102
    -> ;
+------+-------------+
| name | number      |
+------+-------------+
| dany | 13158235102 |
+------+-------------+
1 row in set (0.01 sec)

2. django中MVC设计模式的含义

把数据存储逻辑，业务逻辑，表现逻辑组合在一起的概念，有时候被称为软件架构的Model-View-Controller（MVC）模式

• Model 代表数据存储层
• View 代表的是系统中选择显示什么和怎么显示的部分
• Controller指的是根据用户输入并需要访问的模型，已决定使用哪个视图的哪个部分

(django中主要是template，弱化了Controller部分)

3. django中数据库的配置

查看是否连接成功

python manage.py shell

---

4. 第一个model

首先配置setting.py函数，在models中建立模型,只有建立好模型才会在数据库中存在

下面两步骤在数据库mysql_study中建立模型的tabel

python manage.py makemigrations

python manage.py migrate

在数据库中查看建立好的表

---