学习猿地 python教程 django教程3 Django后台管理及模型关系

  ```python
LANGUAGE_CODE = 'zh-Hans'
TIME_ZONE = 'Asia/Shanghai'
USE_I18N = True
USE_L10N = True
USE_TZ = False
  ```
    5,找admin.py配置后台
```python
# Register your models here.
class UsersAdmin(admin.ModelAdmin):
  # 要展示的字段
  list_display = ('id','username','age','sex','email','addtime')
  #list_editable 设置默认可编辑字段
  list_editable = ['username', 'age','email']
  #list_per_page设置每页显示多少条记录，默认是100条
  list_per_page = 10
  #ordering设置默认排序字段，负号表示降序排序
  ordering = ('id',)
  #过滤器
  list_filter =('username', 'age', 'email')
  #搜索字段
  search_fields =('username', 'age', 'email')
  # select * from users where username like '%ab%' or age like '%ab%' or email like '%ab%';
  # 详细时间分层筛选
  date_hierarchy = 'addtime'
admin.site.register(Users,UsersAdmin)
```
\d //
create procedure p1()
begin
set @i=0;
while @i<20000 do
insert into myadmin_users values(null,concat('user:',@i),123,'1234567',concat('user:',@i,'@qq.com'),20,@i%2,'2019-08-08 15:35:09.15560');
set @i=@i+1;
end while;
end;
//
\d ;