Commodity management system

Commodity management system (stored in database) brief introduction For the first time, if there is an error in my blog, I can send a private letter. Thank you for your correction. If you can write, I hope you can pay attention to it, and will continue to update the learning process and make progress together. The source code is at the end ...

Added by Ind007 on Thu, 10 Mar 2022 06:28:32 +0200

Synchronize Oracle database data to mysql database (how to synchronize Oracle database backup dmp to mysql)

Oracle database dmp to mysql format 1, Background The customer of the first project is oracle database, which needs to import a table data to the mysql database of the self research system. Party A has given the dmp file in oracle format! Treatment idea: ① . install Oracle database. ② Import the dmp file in Oracle format provided by Party A i ...

Added by SulleyMonstersInc on Thu, 10 Mar 2022 04:45:39 +0200

Use the nebula spark connector and the nebula algorithm in the Nebula K8s cluster

This article was first published in Nebula Graph Community official account##Solution ideasThe most convenient way to solve the problem that K8s cannot connect to the cluster after deploying the Nebula Graph cluster is to run the nebula algorithm / Nebula spark in the same network namespace as the nebula operator, and fill in the MetaD domain n ...

Added by ssidellq on Thu, 10 Mar 2022 04:45:51 +0200

mysql learning notes

Where query and fuzzy query Function: retrieve qualified values in data Logical operator operatorgrammardescribeand &&a and b || a&&bLogic and, both are true, and the result is trueor ||a or b || a || bLogical or, one of which is true, the result is trueNot !not a || !aLogical negation where statement example 1. Find an inte ...

Added by timon on Thu, 10 Mar 2022 03:09:14 +0200

Mysql advanced operation commands

Data table advanced operations Clone the table and generate the data records of the data table into a new table Method 1: use like create table test like info; #Using the LIKE method, copy the KY08 table structure to generate the test01 table insert into test select * from info; Method 2: direct cloning However, direct cloning ca ...

Added by Tindo on Wed, 09 Mar 2022 14:38:02 +0200

In depth analysis of MySQL Partition function

=Horizontal partition (by row according to column attribute)= Take a simple example: a table containing ten-year invoice records can be divided into ten different partitions, and each partition contains the records of one year. Mode of horizontal partition: Range – this mode allows DBA s to divide data into different ranges. For e ...

Added by tobimichigan on Wed, 09 Mar 2022 13:13:19 +0200

[Redis] 4. Explain three special data types in detail: Geospatial, hyperlog and Bitmap

These three special data types are not a new type; The bottom layer is one of the five types; For example: Zset, String 1. Geospatial geographic location geo: geographical location[ ˈ spe ɪʃ l] spatial Positioning of friends, people nearby, taxi distance calculation? Redis's Geo is in redis3 Version 2 is launched! This function c ...

Added by donbonzo on Wed, 09 Mar 2022 12:00:22 +0200

Calculation of ring ratio and N kinds of posture year-on-year

When doing data analysis, we often hear the concepts of year-on-year and month on month. When publishing statistical data, enterprises and organizations usually like to compare the previous historical data with the year-on-year and month on month data to illustrate the changes of the data. For example, the Bureau of Statistics announced that in ...

Added by unreal128 on Wed, 09 Mar 2022 07:46:56 +0200

[project practice] implementation of login and registration business (front end + back end + database)

This example is based on Vue JS and mint UI implementation. catalogue 1, Creation of database 2, Connection between back-end interface and database 3, Front end code implementation 1. Relevant codes of registration page 2. Effect of registration page 3. Relevant codes of login page 4. Landing page effect 4, Demo login 5, Project fil ...

Added by medar on Wed, 09 Mar 2022 07:15:08 +0200

mysql5.7 minor version upgrade - windows

mysql5.7 minor version upgrade - windows Application scenario: upgrade mysql 5.7.20 to the latest 5.7.31, Windows Environment Download link on the official website: https://dev.mysql.com/downloads/mysql/5.7.html Note: mysql data must be backed up before operation to avoid problems during installation and can be remedied 1, Close and delete ...

Added by Neumy on Wed, 09 Mar 2022 05:29:59 +0200