Database

10 awesome C language open source projects worth learning

Hello everyone, my name is Wheat. Today I will share with you 10 awesome C language [open source projects] . Webbench Tinyhttpd cJSON CMockery Libev [Memcached] Lua [SQLite] UNIX v6 NETBSD 1. Webbench WebbenchIt is a very simple website [stress testing] tool used under linux. It uses the fork()simulation of multiple clients accessing our settings …

10 awesome C language open source projects worth learning Read More »

[MySQL learning articles] — Stored procedure

Article directory [MySQL learning articles] — Stored procedure What is a stored procedure? Stored procedure syntax Stored procedure with return value Stored procedure with if…else if… Select branch case while loop loop loop [MySQL learning articles] – stored procedures What is a stored procedure? A stored procedure is a collection of operations of a group …

[MySQL learning articles] — Stored procedure Read More »

Understanding and Practice of Database-Stored Procedure

background The concept of the stored procedure is similar to the sh script in linux, that is, it can execute multiple commands at the same time, and can pass in parameters, etc. practice create process create procedure procedure_name() begin select name from t_user; select name from t_user; end; delete a process drop procedure procedure_name Calling …

Understanding and Practice of Database-Stored Procedure Read More »

Unable to load authentication plugin ‘caching sha2 password

When I use DBeaver to connect to MySQL, I get an error, the error is as follows: Unable to load authentication plugin ‘caching_sha2_password Finally found the problem, because of some changes in MySQL8 and MySQL5. This is a problem with the mysql 8.0 version, because mysql 8.0 uses the caching_sha2_password authentication mechanism by default – …

Unable to load authentication plugin ‘caching sha2 password Read More »

The Implementation Method of SQL Server Database Backup and Restoration Operation

1. Perform a full backup of the database student Note : All experiments below are based on this table ✈ Click to view Log in to SQL Server with an administrator account and run SQL Server [Explorer] ; choose one of the following methods; Method 1: Backup using Explorer (1) Open the [Object Explorer], find …

The Implementation Method of SQL Server Database Backup and Restoration Operation Read More »

SSM integrates redis

Because there is an old [SSM] project, I want to integrate redis for caching, but I used springBoot before, so I will record the integration process here. 1. First add the relevant dependencies in [pom.xml :] <!– redis–> <dependency> <groupId>redis.clients</groupId> <artifactId>jedis</artifactId> <version>2.10.1</version> </dependency> <dependency> <groupId>org.springframework.data</groupId> <artifactId>spring-data-redis</artifactId> <version>2.1.8.RELEASE</version> </dependency> 2. Then create the redis.properties file in …

SSM integrates redis Read More »

Oracle get the value of dynamic sql EXECUTE IMMEDIATE.. INTO..

BEGIN     DECLARE         ls_sql VARCHAR2(4000);         ln_cnt INT;     BEGIN         ln_cnt := 0;         ls_sql := 'select count(*) from  (select 1 from dual) a ';         EXECUTE IMMEDIATE ls_sql             INTO ln_cnt;         DBMS_OUTPUT.PUT_LINE(ln_cnt);          END; END; output ORACLE EXECUTE IMMEDIATE usage EXECUTE …

Oracle get the value of dynamic sql EXECUTE IMMEDIATE.. INTO.. Read More »