[The road to java learning] (mysql article) 002.mysql grouping query and join query
Single Line Processing Function
Data processing functions are also known as one-line processing functions
Features of one-line processing functions: one input corresponds to one output.
As opposed to single-line processing functions, multiline processing functions. (Multi-line processing function features: multiple inputs, corresponding to o ...
Added by edmore on Sun, 06 Feb 2022 19:17:52 +0200
python operation excel import data to mysql
Requirement: the exchange code of excel is imported into mysql, with a total of 30W pieces of data. Navicat has its own functions. It can directly import excel data into mysql. There are too many databases and manual operation is very troublesome. A script is written with python.
Use pip to import xlrd,pymysql library. ...
Added by uncleronin on Mon, 06 Apr 2020 19:22:11 +0300
High salary test required: 3 steps to teach testers to crack sub query
Testers often check whether the data in the database is correct due to work reasons. At this time, they need to frequently use multi table queries.
In multi table query, inner join is the most widely used, followed by sub query.
Why are subqueries widely used in work? The reason is that subqueries ...
Added by j152 on Wed, 04 Mar 2020 10:41:09 +0200
The Mac's Navicat installation crashes
The purpose of this paper is to discuss the advantages of navicat. If there is any infringement, please contact me to delete it immediately.
Download address
Mac version Navicat Premium 12 v12.0.23.0 official website download address: ...
Added by khjart on Mon, 19 Aug 2019 14:53:01 +0300