I have read about database system concepts, 6th edition, Silberschatz. I will implement the university database system shown in Chapter 2 on MySQL’s OS X. But I’m in the course of creating tables I
Tag: mysql
Mysql’s transaction
The transaction in MySQL is the smallest indivisible unit of work, and the transaction can ensure the integrity of a business
There are multiple SQL statements in a business, and these SQL st
MySQL view
What is a view? For example, if there is a basic table, user 1 can view the data and can view fields 1 and 2, and user 2 can view the fields 3 and 4, then these two users There are different views
MySQL creates a database
After logging in to the MySQL service, we can use the create command to create a database. The syntax is as follows:
CREATE DATABASE database name; The following command simply demonstrates t
MySQL Workbench! Add a prefix for all tables
Is it possible to set the table prefix in the MySQL workbench?
For example: I created a complete pattern (table_1, table_2, table_3,… table_N), and I want Workbench to add a prefix to each table
Mysql – How to choose a line in the case of considering weight?
I have a table that looks like this:
id: primary key
content: varchar< br />weight: int What I want to do is to randomly select a row from the table, but consider the weight. For example, if
MySQL account management
< /p> #code
desc user
select user,host,authentication_string from mysql.user;
#Modify password
update user set authentication_string=password(‘new password’) where user=‘user name’
#After
View Isolation level of MySQL transaction
1. Select the database to view the current transaction isolation sector
select @@tx_isolation;
2. Open the transaction, roll back the transaction
3. Dirty read, phantom read in th
MySQL Optimization: How to avoid back inquiry
Reference: https://www.cnblogs.com/myseries/p/11265849.html
InnoDB has two types of indexes: clustered index (clustered index) index) and ordinary index (secondary index)
The leaf node
How to get the current date and time of MySQL?
Is there a value or command like DATETIME that I can use in manual queries to insert the current date and time?
INSERT INTO servers (
server_name, online_status, exchange, disk_space, networ