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
在数据库中查看建立好的表
