Programming VIP

Chapter 10_ Create and manage tables Lecturer: Shang Silicon Valley - Song Hongkang (Jianghu person: Master Kang) Official website: http://www.atguigu.com 1. Basic knowledge 1.1 a data storage process Storing data is the first step in processing data. Only by storing the data correctly can we process and analyze it effectively. Otherwise ...

Indexes MySQL's official definition of Index is: Index is a data structure that helps MySQL efficiently obtain data. Extract the sentence trunk to get the essence of Index: Index is a data structure. For details, you can check this blog post (the original blog post has expired, and this blog post is reprinted) https://blog.csdn.net/weichi7549/ ...

mysql database security policy MySQL system itself can set password complexity and automatic expiration policy, which may be less used. Recently, I was informed to adjust the password and began to understand it mysql password complexity policy The MySQL system comes with validate_password plug-in, which can verify the password strength ...

In my blog website, Nacos is used as the configuration and registration center and associated with the database. Since the data, data and website settings are stored in the database, I always want to make a backup. So I found a relatively simple scheduled backup mode. Of course, it is based on linux. Method: use the timer in linux system to ...

1, Centos6 X version of yum image installation 1. If you are using a simplified version of CentOS, you need to install yum first Note: if you have no problem with yum, please skip this step to install Yum by yourself 2. If there is a problem with yum, you need to execute these five lines of commands Note: five lines of commands, five steps ...

From the library, you can view the database you just created: In this database, query the data in the user table: 3, MyCat master slave read / write separation 1. Read write separation principle Read write separation is simply to separate the read and write operations of the database to correspond to different database servers. The mast ...

preface The database table design I mentioned here involves how to organize your business table, how to design, how to redundant fields, etc., but these are my personal views. You are welcome to discuss different views with me in the message area 1, Database table? According to my understanding, database tables are generally divided ...

1. Replicate one more database locally (ignored if you have multiple servers conditionally) 1) Find the mysql instance folder and data folder (usually under C:\Program Files and C:\ProgramData) Directly copy a copy from the library 2) Modify slave library configuration my ini [client] port=3307 [mysqld] port=3307 basedir="C:/Program Files/M ...

MySQL command integration (II) De duplication of query results select distinct ... // Add the distinct keyword after select be careful The distinct keyword can only appear first of all fields join query classification According to grammar SQL92SQL99 According to the connection mode of the table Internal connection: equivalent conn ...

1, Initial experience of MySQL database Basic concepts of databaseDevelopment of databaseIntroduction to mainstream databaseMySQL installation methodOperating MySQL 1. Basic concept of database Data A symbolic record describing somethingIncluding numbers, words, graphics, images, sounds, archives, etcIt is stored in a unified format in ...