[MySQL database] Chapter 5: views and variables
5 others
5.1 view
View: MySQL provides view function from version 5.0.1. Virtual tables (used as ordinary tables) are dynamically generated when using views. Only sql logic is saved, and query results are not saved.
Application scenario:
Multiple places use the same query resultsThe sql statements used in the query results are complex
Bene ...
Posted on Wed, 27 Oct 2021 20:02:58 -0400 by Mohit_Prog
vue import sql editor
Some configuration items of sql editor
(for more configuration items, refer to: https://blog.csdn.net/JLU_Lei/article/details/80259697 )
event listeners
Trigger usage: editor.on('chang ', () = > {}) Cancel trigger method: ediotr.off('change ')
"Changes": triggered every time the editor content changes "beforeChange" ...
Posted on Mon, 25 Oct 2021 23:00:12 -0400 by noguru
mybatis study notes (Diary)
The core object of MyBatis
SqlSessionFactory is a very important object in the Mybatis framework. It is a compiled memory image of a single database mapping relationship. Its main function is to create an instance of SqlSession.SqlSessionFactory object, which can be built through SqlSessionFactoryBuilder object.
The code is as follows: ...
Posted on Sun, 24 Oct 2021 00:48:14 -0400 by Jeller
Of Mysql database management -- SQL statement
1, Introduction to SQL language
SQL statements are used to maintain and manage the database, including data query, data update, access control, object management and other functions.
SQL language classification
DDL: data definition language, which is used to create database objects, such as libraries, tables, indexes, etc.DML ...
Posted on Fri, 22 Oct 2021 03:09:59 -0400 by Anidazen
SQL implements continuous login days and maximum login days
SQL implements continuous login days and maximum login days
Title: calculate the number of consecutive login days of users Problem extension: users who log in for 3 consecutive days, maximum login days, etc
The field user id and login time date given in sheet1 are shown in the following table:
1. Cleaning data
Because it is the calculation ...
Posted on Thu, 21 Oct 2021 00:17:19 -0400 by PHP Newb
Basic database operation
1. Increase
1. Create a database named text. Note that the ` ` symbol is the symbol below the Esc key in the upper left corner of the keyboard, not a comma. (if you use SQLyog to create a list, remember to refresh the list!!!)
Format: create database database name
CREATE DATABASE `text`
2. Create a table
CREATE TABLE IF NOT EXISTS `studen ...
Posted on Fri, 15 Oct 2021 16:35:26 -0400 by Hikari
Experiment 3 of Database Principle -- data integrity and security control
Experimental purpose
Master various integrity definition methods of basic tables.Master the creation and use of users.Master the method of SQL statement for security control of database and table.
Experimental content
Use the graphical user interface to add the following constraints and indexes to the Student library, and verify the default ...
Posted on Fri, 15 Oct 2021 16:17:43 -0400 by prasad_deba
mysql index usage
Prepare environment
create index idx_seller_name_sta_addr on tb_seller(name,status,address);
1) . full value matching is the most efficient
explain select * from tb_seller where name='Xiaomi Tech ' and status='1' and address='Beijing'
2) . leftmost prefix rule If you index multiple columns, follow the leftmost prefix rule. This means that ...
Posted on Thu, 14 Oct 2021 18:36:04 -0400 by NeMoD
SQL classic 50 question exercise
The 50 questions of SQL are widely circulated on the Internet. They are a classic and comprehensive set of questions. Recently, they have just joined the data development engineer, and SQL needs to be strengthened. Therefore, naturally, they can't miss this set of questions. Each question is written by themselves. If they can't, they have seen ...
Posted on Mon, 11 Oct 2021 23:07:51 -0400 by jl5501
[50 commonly used MySQL statements] if you are not familiar with these 50 sql statements, don't say you will MySQL [suggest collection]
This article mainly introduces 50 SQL query skills and query sentence examples. Taking student table, curriculum table, grade table and teacher table as examples, this paper explains the writing methods of SQL sentences under different needs. Friends in need can refer to it. It is suggested that comrades who often use MySQL collect them.
Stude ...
Posted on Mon, 11 Oct 2021 21:50:53 -0400 by keyurjbhatt