Programming VIP

-- Download directory cd /. mkdir study cd study -- download MySQL7 Version of wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.26-linux-glibc2.12-x86_64.tar.gz -- download MySQL8 Version of wget https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.16-linux-glibc2.12-x86_64.tar.xz -- decompression tar -zvxf mysql-5.7.26-linux-g ...

prepare 1. Confirm that binlog is enabled show variables like 'log_%'; After execution, log in the red box below_ Bin on means binlog is on 2. Prepare database tables and data for operation CREATE TABLE `study`.`tb_class` ( `id` int(11) NOT NULL, `name` varchar(255) DEFAULT NULL, `score` int(255) DEFAULT NULL, `grade` varcha ...

day27 Today's content 1. multi-table query 2. thing 3. DCL multi-table query # Create department table CREATE TABLE dept( id INT PRIMARY KEY AUTO_INCREMENT, NAME VARCHAR(20) ); INSERT INTO dept (NAME) VALUES ('Development Department'),('Marketing Department'),('Finance Department'); # Create employee table CREATE TABLE emp( id INT PRIM ...

Overview of LAMP architecture Introduction to LAMP LAMP is the acronym of Linux operating system + Apache Web server + MySQL database server + PHP (or Perl, Python) web programming language. They are all independent programs, but together they can be used to build open source software for dynamic websites or servers. Function of each com ...

I Problem description When copying the table data of a large table, the waiting time is too long, and it stops at the foreground by CTRL+C. mysql> create table fact_sale_new as select * from fact_sale; ^C^C -- query aborted ^C^C -- query aborted ERROR 2013 (HY000): Lost connection to MySQL server during query No connection. Trying to ...

preface Today, Xiao Wang, a programmer, was scolded by his boss and his salary was deducted by 1k. The reason is that a project has been launched. The customer asked to add a new user to the database and give the user some permissions. However, Xiao Wang is a little rusty in this regard, which is the reality of Baidu, resulting in low work ef ...

DML data manipulation language of MySQL core knowledge MySQL deep analysis table data addition Create table Employee list of a company create table employee( empno int primary key comment 'Employee number', ename carchar(20) commenr 'Employee name', job carchar(20) commenr 'Employee position', mgr int comment 'Employee super ...

catalogue     1. mysql website and download the installation package 2. Click to unzip to the directory you want to store 3. Configure SQL 4. Create front end engineering catalog 5. mysql database and table creation 6. Service and debugging interface   1. mysql website and download the installation package Download address: https:// ...

SQL statement 1. What is SQL? SQL:Structured Query Language, or Structured Query Language. That is, it defines the rules for operating all relational databases. Each database operates in a different way, called a dialect. Note: If you do not have a MySQL database installed, you can refer to the article MySQL(1) | Detailed installation a ...

select city,name,age from t where city='Hangzhou' order by name limit 1000;I-1 full field sorting execution process1. Initialize sort_buffer: confirm to put the name, city and age fields;2. Find the first primary key id that meets the condition of city = 'Hangzhou' from the index City, that is, the id in the figure_ X；3. Go to the primary key ...