Programmer Think

1. Creating Django projects with pycharms Remember to install mysqlclient (1) Database configuration We found the DATABASES configuration item in the settings.py file of the project, and changed its information to: DATABASES = { 'default': { 'ENGINE': 'django.db.backends.mysql', # Or use mysql.connector.django 'NAME': 'u ...

Advanced Date and time import datetime import time # Introduce time Modular import calendar #Get current date time now=datetime.datetime.now() print(now) #Get the specified date d=datetime.datetime(2019,10,1,12,23,40) print(d) #Date to string d2=d.strftime("%Y/%m/%d %H:%M:%S") print(d2) #String to date s="2020-8-15 2:30:20" d3=datetime.da ...

squid forward agent Principle: a machine that can't access the Internet can access the website that can't be accessed through the agent Here I use my real machine as an agent. The virtual machine accesses the website through the agent Operating System: Red Hat Enterprise Linux Server 7.2 (Maipo) squid installation a ...

  After version 1.9, nginx can act as a port forwarding function, that is, to access the specified port of the server, nginx can act as a port forwarding function to direct traffic to another server, and obtain the return data of the target server and return it to the requester. The function of nginx's TCP proxy is different from that ...

Mysql and Redis operations Mysql development Install mysql and create test library Create table mysql> CREATE TABLE `user` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `name` varchar(20) DEFAULT '', `age` int(11) DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4; mysql> insert into user (name,age)va ...

Catalog 1. Environmental planning 2. binlog is enabled for all Mysql to ensure that the server IDs of all MySQL are different 3. The master database authorizes the master-slave replication user 4. The main database makes the database data fully available, and then pushes the backup file to the slave database 5. Restore backup files from the d ...

Author: Lu Lu Those who love technology and are willing to share are mainly engaged in the research of database related technology. Source: original contribution *Aikesheng is produced by the open source community. The original content cannot be used without authorization. Please contact the editor for reprint and indicate the source. Summ ...

1. Find all information about the latest employee CREATE TABLE `employees` ( `emp_no` int(11) NOT NULL, `birth_date` date NOT NULL, `first_name` varchar(14) NOT NULL, `last_name` varchar(16) NOT NULL, `gender` char(1) NOT NULL, `hire_date` date NOT NULL, PRIMARY KEY (`emp_no`)); Solution: sort order by... Desc according to the entry time in re ...

In order to study whether sql automatic inspection and analysis tools are easy to use, I install and use soar and soar web locally. The preliminary experimental results are summarized as follows: 1. The installation is relatively cumbersome, especially the installation of dependency package of soar web, which involves the download and installat ...

Seata serve installation package Download the Seata Server package, all I have is version 0.9.0 https://github.com/seata/seata/releases wget https://github.com/seata/seata/releases/download/v0.9.0/seata-server-0.9.0.tar.gz Link: https://pan.baidu.com/s/1jlBwCEYM3hn7zQiSpwRijg password: 56vm After 0.9.0 of the official website, there is no ...