Programmer Think

The original content of GreatSQL community cannot be used without authorization. Please contact Xiaobian and indicate the source for reprint.In the near future, we plan to create a docker image of GreatSQL to facilitate community users to use GreatSQL.The environment for making docker images is based on CentOS 7.9:[root@greatsql]# cat /etc/redh ...

LAMP Architecture Overview LAMP architecture is one of the mature enterprise website application modes at present. It refers to a complete set of systems and related software working together, which can provide dynamic web site services and its application development environment. LAMP is an abbreviation, including Linux operating system, ...

catalogue 1, What is JDBC 2, Working principle and advantages of JDBC 3, JDBC Usage Summary 1. Create database Connection 2. Create operation command Statement 3. Use the operation command to execute SQL 4. Process ResultSet 5. Release resources Specific implementation code: 4, JDBC common interfaces and classes 1.JDBC API 2. Databa ...

1, Input / output class (1) PHP realizes search and query function 1. After obtaining the data input by users, the website connects to the database to retrieve the information input by users, and then returns the search results to users, so as to realize the function of search and query. 2. Code example (1) index home page, search box <!DOC ...

🏷️ The current chapter is [MySQL basics] 07: view 🤖 🏷️ More: MySQL basic tutorial , take you to start MySQL database on a zero basis! 💪 🏷️ Welcome to praise 👍 Collection 🌟 Attention ❤️ Leaving a message. ✍️ Concept of view A virtual table composed of data queried by one or more tables in a database according to specific cond ...

MySQL transactions must meet the A (atomicity) C (consistency) I (isolation) D (persistence) principle. Among them, isolation is to minimize the impact of concurrent transactions on each other. The highest isolation level can ensure that concurrent transactions do not affect each other.   in the actual application process, in order to ada ...

pojo: public class User { private Integer id; private String name; private String pwd; setter and getter.... } Database: 1. Gets the value of the self incrementing primary key Mapping file: <!-- UserMapper Interface public void addUser(User user); --> <insert id="addUser" parameterType="com.workhah.pojo.Us ...

Let's answer the questions before moving on. Two days ago, a little partner asked a question privately and said: What should I do if some tables have sub database and sub table, and the other tables have no sub database and sub table? How can I access normally? This is a typical problem. We know that sub database and sub table are for so ...

1, Basic concepts of database 1. What is a database database is a warehouse used to organize, store and manage data. 2. Common database and classification Common databases include MySQL database, Oracle database (charging), SQL Server database (charging) and Mongodb database. Among them, MySQL, Oracle and SQL Server belong to traditional d ...

Today is the last day of 2021. I wish you all a happy New Year's day in advance. This is also the last article in 2021. Later, I will bring you more articles about Doris. At the same time, I hope Doris will take off in 2022, successfully graduate from Apache incubator into a top-level project, and bring you a faster, more stable and more ecolog ...