Django 版本: 1.8.0
一、查询表中指定字段
使用格式 QuerySet对象.values("字段1","字段2")
实现SQL中查询指定字段的功能:
mysql> DESC auth_permission; +-----------------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------------+--------------+------+-----+---------+----------------+ | id | int(11) | NO | PRI | NULL | auto_increment | | name | varchar(255) | YES | | NULL | | | content_type_id | int(11) | NO | MUL | NULL | | | codename | varchar(100) | NO | | NULL | | +-----------------+--------------+------+-----+---------+----------------+ 4 rows in set (0.01 sec) mysql> SELECT name -> FROM auth_permission; +---------------------------+ |