Programming VIP

0 storage engine introduction myisam storage: if the table does not have high transaction requirements and is mainly query and addition, we consider using myisam storage engine, such as posting table and reply table in bbs Regular defragmentation is required (because the deleted data still exists): optimize table_ name; InnoDB storage: ...

I What is LAMP? LAMP environment is an abbreviation of (Linux+Apache+ MySQL+PHP). It is a group of open source software commonly used to build dynamic websites or servers. At the same time, LNMP(Linux+Nginx+ MySQL+PHP) environment architecture is most contacted. Different from it, Apache is used as web page service and Nginx is used as web pag ...

1.1 command line startup service net start service name net stop service name However, the dos window must be opened as an administrator 1.2 connecting to the server local local host host -h username user name -u password password -p port port -P(Capitalize) Database connection succeeded dos commands do not need semicolons, ...

catalogue 1, Integer 2, Decimals 3, Character type 4, Date type Numerical type integer decimalFixed point numberFloating point numbercharacterShorter textchar,varcharLong texttext, blob (long binary data)Date type 1, Integer Classification:    tinyintsmallintmediumintint/integerbigint1 byte2348 characteristic: If you do not ...

preface This is my first attempt to install mysql on the server. I have recorded and summarized the problems encountered. I hope I can prompt people who encounter the same problems. If I can't solve your problem, continue to refuel, and I will be able to find a solution. Du Niang is forced Here will be a blog for reference. Thank you for sh ...

1, What is partition ###### 1 and what is partition table Partitioned table is to divide the data of the same table into multiple storage locations according to some rules. Partitioned storage of data improves the performance of the database. The data to be stored is physically multiple files, but logically it is still a table. Any operation o ...

1. Explanation of NoSQL (non relational database) Why use Nosql Big data age - > springboot + springcloud The beautiful era of stand-alone Mysql! In the 1990s, the number of visits to basic websites was small, and only a single database was enough. Bottleneck of the whole website: 1. If the amount of data is too large, one m ...

catalogue preface On the effect! User registration and login page Retrieve team information Chart making: The histogram shows the winning rate information of each team: The pie chart shows the number of games played by each team The line chart shows the average score of each team Implementation of administrator operation epilogue ...

Use Spring's @ Transactional annotation to control the scenarios in which transactions do not take effect I don't know if my friends have such an experience. When they are happy to write business code, suddenly the transaction in a method seems to fail. Then, when debug ging tracks the code, it is found that after the execution of the first st ...

1. Index type BTREE : b-tree , b+tree , b*tree RTREE FULLTExT HASH 2. Differences and relations between clustered index and auxiliary index difference: Generally, the primary key is selected to generate the cluster index. There can only be one table. If there is no primary key, the unique key is selected, and the hidden ...