# antelope

**Repository Path**: fengxingkeji_python/antelope

## Basic Information

- **Project Name**: antelope
- **Description**: No description available
- **Primary Language**: Python
- **License**: MIT
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2017-04-16
- **Last Updated**: 2020-12-19

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

#antelope
# python django command
 python manage.py startapp
 python manage.py makemigrations myapp
 python manage.py migrate
 python manage.py createsuperuser
# Set Mysql's default codeset
 ## query mysql db's codeset.
 show variables like 'collation_%'
 ## change mysql db's codeset.
  <code>
  [mysql]
   <p>default_character_set=utf8</p>
  [mysqld]
   <p>character_set_server=utf8</p>
   <br/>重启mysql
   </code>
### change databases' code set.
* alter database airfield character set utf8;

* alter TABLE myapp_flight CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;

## mysql manual
### mysql installation
  1) mysqld --initialize-insecure  --user=mysql
  2) mysqld --console
  3) mysql -uroot -p
  4) mysql@localhost fenghuang
   mysql@'%'  fenghuang
   create database airfield;


### create user
    create user mysql@'localhost' identified by 'mysql';
### grant privileges
    grant all privileges on airfield.* to mysql;

### frequently used mysql sql command.
* DROP DATABASE IF EXISTS userdb;
* CREATE DATABASE userdb;
* USE userdb;
* CREATE TABLE user(id int(11)NOT NULL AUTO_INCREMENT,
userName varchar(20) DEFAULT NULL,
userPwd varchar(20) DEFAULT NULL,
PRIMARY KEY (id)
)ENGINE=MyISAM DEFAULT CHARSET=uft8;
* INSERT INTO user(id,userName,userPwd)VALUES(1,'admin','admin');