Basic configuration of LAMP architecture
catalogue 1, LAMP introduction and overview 1. Overview of lamp platform 2. Build LAMP platform sequence 3. Advantages of compilation and installation 4. Main functions of each component 2, Install Apache 3, Install MYSQL IV Install PHP 5, Installation Forum 1, LAMP introduction and overview 1.UTF-8...
Posted by lihman on Thu, 04 Nov 2021 18:22:51 +0530
Install MySQL using yum under Centos7
MariaDB is installed in CentOS by default. This is a branch of MySQL. However, MySQL should be installed in the system to meet the needs, and MariaDB can be directly overwritten after installation. 1 download and install the official Yum Repository of MySQL [root@localhost ~]# wget -i -c http:/UTF-8...
Posted by dave420 on Fri, 05 Nov 2021 05:01:58 +0530
30 MYSQL exercises
CREATE TABLE DEPT( DEPTNO int PRIMARY KEY, DNAME VARCHAR(14), LOC VARCHAR(13) ); INSERT INTO DEPT VALUES (10,'ACCOUNTING','NEW YORK'); INSERT INTO DEPT VALUES (20,'RESEARCH','DALLAS'); INSERT INTO DEPT VALUES (30,'SALES','CHICAGO'); INSERT INTO DEPT VALUES (40,'OPERATIONS','BOSTON'); DEPTNO -- UTF-8...
Posted by glossary on Fri, 05 Nov 2021 06:30:07 +0530
She spent the night helping her build a personal website - using Docker to implement internal and external network isolation website deployment on a single node (Nginx, Wordpress, MySQL)
1. Foreword after graduation, my colleague's sister Qiqi applied to work as a project assistant in our company and was divided into a project team with me. Qiqi's own congenital conditions are very good. She looks good. She is 1.65 tall and thin. IT's a medium to upper level as a whole. She usUTF-8...
Posted by jkrystof on Sat, 06 Nov 2021 15:22:43 +0530
JDBC transaction, cascading query, connection pool, optimistic lock and pessimistic lock
JDBC advanced 1. Batch processing Sometimes when we need to perform a large number of additions, deletions and modifications, we can use jdbc It can effectively improve the execution efficiency. Implementing batch processing can use Statement And PreparedStatement Complete, usually used in use UTF-8...
Posted by Elhombrebala on Sat, 06 Nov 2021 18:11:33 +0530
[ crazy God Theory ] mysql self-study summary chapter 4 ~ 6
preface This is the self-study notes of crazy God's mysql, which is only for reference, learning and continuous updating The following is a video learning link: https://www.bilibili.com/video/BV1NJ411J79W 4. DQL query statement (most important) 4.1,DQL (Data Query Language) All query operationUTF-8...
Posted by Courbois on Sat, 06 Nov 2021 21:11:25 +0530
[mysql stored procedure]
Stored procedures and functions Stored procedures and functions: similar to methods in java Benefits: 1. Improve code reusability 2. Simplify operation stored procedure Meaning: a set of precompiled SQL statements to understand batch processing statements 1. Improve code reusability 2. SimplifUTF-8...
Posted by llirik on Sun, 07 Nov 2021 02:39:58 +0530
Complete SQL commands. Each command has examples. Beginners can become gods after reading it!
Hello everyone, this is the network technology dry goods circle. Today we bring you a list of SQL commands. Each command will be accompanied by examples, which is undoubtedly a blessing for SQL beginners and even Xiaobai!SELECTSELECT is probably the most commonly used SQL statement. It is used UTF-8...
Posted by Confessions on Sun, 07 Nov 2021 02:45:11 +0530
MySQL text processing function
In the use of MySQL, sometimes it is inevitable to use text processing functions. These functions provide convenience for data processing and conversion. The tables used in this paper are as follows Create table statement, click to view create table departments ( dept_no char(4) not null primarUTF-8...
Posted by number67a on Mon, 08 Nov 2021 05:36:38 +0530
Today, I'll teach you how to write mysql_ to_ A batch script for redis.
Application: it is inevitable to use these things when using redis and mysql for data synchronization. Query the data from mysql and insert it into redis. It is applicable to preloading data in big data and batch import. It is an indirect call method. Before startup, msql data is directly synchUTF-8...
Posted by LukeO on Mon, 08 Nov 2021 10:24:06 +0530