About mysql database migration, the pit encountered by datetime

Migration database is often encountered in work.If you use phpmyadmin to import, you can solve the problem if the database is too small. If it is too large, it will be troublesome. Either it will time out or the file is too large to import.So I chose to use Navicat For Mysql to copy the database In this process, I often encounter a problem: ERR ...

Posted by dannyb785 on Sat, 23 Nov 2019 09:28:42 -0800

How to add and share the function of Youdao cloud notes to your app

Article synchronization from http://javaexception.com/archives/34 How to add and share the function of Youdao cloud notes to your app Question: An open source notebook project before Leanote In, a user feedback wants to add the function of sharing to Youdao cloud notes, so that they can share their millet notes or other Notepad contents to t ...

Posted by conker87 on Sat, 23 Nov 2019 09:06:22 -0800

MongoDB's processing of time: the difference between ISODate and our time zone is 8 hours

In mongoDB database, the time is saved as ISODate type, and orm relationship is mapped as java.util.Date type. The time saved is 8 hours earlier than that of us The original data is: Person [id=11188, name=doctorwho, age=888888,birth=2016-01-01 13:55:00] In MongoDB database: { "_id" : "11188", "_class" : "com.doct ...

Posted by jonnyw6969 on Sat, 23 Nov 2019 08:12:52 -0800

Build Linux:LAMP Environment

Setup of LAMP Environment Install DNS Server Install DNS Service yum install bind -y Configuration of DNS Create Forward Resolution For example, create a forward lookup zone named "lsy.com": Step 1: Create a lookup zone in the main configuration file/etc/named.conf. vim /etc/named.conf listen-on port 53{any ...

Posted by bulgin on Sat, 23 Nov 2019 00:46:29 -0800

Understand how to use JWT and you will be able to implement it with PHP

To implement JWT certification with php, let's first understand what JWT is.What is JWTJWT(json web token) is an open JSON-based standard implemented to pass declarations between network applications.JWT's declarations are typically used to transfer authenticated user identity information between identity providers and service providers in orde ...

Posted by _rhod on Fri, 22 Nov 2019 21:45:57 -0800

Record a series of errors after modifying the size of sga

Record a series of errors after modifying the size of sga once After modifying the sga size of oracle, we encountered a series of errors. 00844 and 00851 error reporting SQL> startup; ORA-00844: Parameter not taking MEMORY_TARGET into account ORA-00851: SGA_MAX_SIZE 2147483648 cannot be set to more than MEM SQL> 01078 error reporting SQ ...

Posted by Manat on Fri, 22 Nov 2019 10:52:06 -0800

Simple rights management php

Forwarded from https://www.cnblogs.com/shenzikun1314/p/6604867.html#4262295   First, the basic theory to understand is whether the relationship between users, roles and privileges is one-to-many or many-to-many.From this, the table is created.   A user can belong to multiple roles, such as Dunchao.He is Sun Li's husband, his child's father, o ...

Posted by billborric on Thu, 21 Nov 2019 19:49:56 -0800

Mybatis Source Parsing - How does SqlSession implement database operations?

Mybatis Source Parsing (IV) - How does SqlSession implement database operations? _If you use a database request operation as a comparison, the first three articles are preparing for the request, and the real operation is what this article will tell you.As with the title, the most central point of this article is that SqlSession implements sourc ...

Posted by chiaki*misu on Thu, 21 Nov 2019 19:15:05 -0800

Database Introduction and MySQL Version 5.7 Compile Installation (Actual!)

Basic concepts of databases Data: Symbolic records describing things are called data. Include numbers, text, graphics, images, sounds, file records, etc. Store in a uniform format as a "record". Table: A table is formed by grouping different records together Is used to store specific data Database: A database is a collection of ...

Posted by fri3ndly on Thu, 21 Nov 2019 18:20:54 -0800

PostgreSQL spatial aggregation performance - administrative area, electronic fence spatial aggregation - time, space thermal map

Label PostgreSQL, spatial aggregation, spatial heat map, administrative region, electronic fence background For a certain time interval (or other conditions), how many objects (space point information) appear in some fences and administrative areas (polygon information), and render these polygons by color depth. for example Example 1. Are ...

Posted by ZephyrWest on Thu, 21 Nov 2019 14:12:51 -0800