Programmer Think

Basic knowledge A data storage procedure: Create data - > confirm field - > create data table - > insert data MySQL database system from large to small is: database server, database, data table, row and column. Naming rules for identifiers The database name and table name shall not exceed 30 characters, and the variable name s ...

catalogue 1. Basic SELECT 2.SQL statement related concepts 3.SQL statement execution sequence 4. Select columns 5. Arithmetic operators 6. Column alias 7. De duplication of lines 8. Display the structure of the table 9. Select a restricted data row 10.ORDER BY clause 11. Limit the number of rows of records 1. Basic SELECT Synt ...

Time storage of mysql advanced part Reproduced in guide: https://javagude.cn/database/mysql/some-thoughts-on-database-storage-time/ timestamp is better than datatime 1.datatime will cause time zone problems 2.datatime8 bytes timestamo4 bytes 1. Remember not to store dates in strings I remember doing this when I was in college, and ...

1 cluster 1.1 concept of cluster Today, with the development of the Internet, the magnitude of data is also growing exponentially, from GB to TB to PB. It is more and more difficult to operate the data. The traditional relational database can not meet the needs of fast query and data insertion. One database server can not meet the stor ...

JDBC programming steps 1, Get link method 1.1 mode 1: use Dirver interface Driver driver=new com.mysql.jdbc.Driver(); //jdbc:mysql protocol //localhost:ip address //3306: default MySQL port number //test: Database String url="jdbc:mysql://localhost:3306/test"; //The properties interface is used to read configuration files in the for ...

catalogue 1. Configuring mysql for cas server 2. cas server custom password encryption method 3. The cas server can customize the theme, that is, the login page, or other pages 4. The cas server adds fields to the form submitted during login 5. cas server custom login verification 6. cas server custom return exception 7. The cas server uses aj ...

Indexes: It is a data structure that helps MySQL obtain data efficiently; It can be understood as a sorted fast lookup data structure. Basic commands for indexing: reference resources Suitable for index creation The primary key automatically creates a unique index; Fields frequently used as query criteria should be indexed The fields assoc ...

1, Pull MySQL image Get the latest MySQL image through the terminal docker pull mysql/mysql-server 2, Create the directory corresponding to the MySQL database container configuration file We create a group of directories under the current user to store MySQL container configuration files (this step can be omitted under Linux). Refer to the ...

introduction All presentations are based on the table student. The student creation statement is as follows: create table if not exists Student( id int, name varchar(20), math float, english float, chinese float ); I newly added 1. Single row data + full column insertion insert into Table name values(Corresponding value o ...

When developing JAVA projects, we need to interact with the database. At the beginning of database programming, we choose JDBC, which is the API for how to interact between the database and JAVA programs, but the steps are cumbersome. Today, we will learn about the latest database framework, MyBatis. It is a semi-automatic persistence layer fra ...