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
Category: Database
The database is a warehouse that organizes, stores and manages data according to the data structure. It was created more than 60 years ago. With the development of information technology and the market, especially after the 1990s, data management is no longer just It is to store and manage data, and transform it into various data management methods required by users. There are many types of databases, from the simplest tables that store various data to large-scale database systems that can store massive amounts of data. They have been widely used in all aspects.
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
Talking about Mysql Multi-Table Operation
Field operation create table tf1( id int primary key auto_increment, x int, y int);# Modify alter table tf1 modify x char(4) default”;alter table tf1 change ym char(4) default”;# Add mysql>: alte
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
Mysql string intercept
MySQL string interception functions: left(), right(), substring(), substring_index(). There are mid(), substr(). Among them, mid() and substr() are equivalent to the substring() function, and the f
MySQL installation
1.mysql download Select the corresponding version download address Here we download mysql-8.0.17-winx64
Unzip and create the root directory after unzip my.ini and data folder
basedir: