I. Characteristics of a transactionAtomicity, consistency, isolation, persistenceSecond, the isolation level of the transaction1. Non-submitted reading (read uncommitpeatableted)Infamous dirty read, other transactions uncommitted, still readable to2,
Recently learned about the use of MySQL data implementation of the principle of the active structure, in the previous concurrent access to a low scene, generally a high performance of the server as a MySQL data, can meet the business of add and
The operation of the database user is done in the MySQL library, so you need to go to the MySQL library to see the users and addresses in the database.Here are two ways to create a user's password at the same time, the difference is the second we
Multi-Table QueryReasons to use multi-table association queries: query data is published in several tablesMerging result sets :merging the result set is a two the query results of the SELECT statement are merged together, and the result set is a
One, MySQL data type
The type of data field defined in MySQL is important for database optimizationMySQL supports multiple types and can be broadly divided into three categories: numeric, DateTime, and string (character) types
Second,
1. Statement: SELECT @rownum: [email protected]+1 as rownum, orderstate.*From (SELECT @rownum: =0) R, Orderstate;Execution Result:2. Revelation: Through this operation I am more aware that the view is the use of SQL queries using similar outer joins,
ObjectiveUsing C # to invoke the CMD window implementation to modify the database passwordImplementation ideas:Get to the root directory of MySQL by connecting to the database via ODBC first. Call cmd according to the path of the root directory,
When using JMeter for performance or interface testing, often need to connect to the database, then how to use JMeter to connect to the database, following the MySQL database as an example to make a brief explanation:The first step: click the
Backup structure1. Backing Up the table structure- - - > a.sql2. Back up all the table structures of the database- - - > b.sql3. Back up all table structures for multiple databases- - - -- databases db1 DB2 ... > C.sql4. Backing up the table
There are times when data collation needs to be specified for its own rules, such as 1>3>2>0, so you need to specify the collation when fetching data, as follows:SELECT ' user ' from the user WHERE ' User_status ' in (0,1,2,3) ORDER by FIELD (' User_
INT (m), M is the tube of what use?As an extension to the Ansi/iso SQL92 standard, MySQL also supports the integer types TINYINT, Mediumint, and BIGINT listed in the table above. Another extension is that MySQL supports arbitrarily specifying a
6th, optimize the configuration https://www.cnblogs.com/musings/p/5913157.html1: The server reads the configuration file, which can be queried using the following commandAdmin@iZwz92c0zpe8t65qe996ckZ:~$ which mysqld/usr/sbin/ MysqldUsing the MYSQLD
Suppose there are two kinds of tables: test_on_position and Address tables, Address Table storage addresses, test_on_position store members and their usual addresses, the data are as follows:Address Table:Test_on_position table:1. The left join
Tag: Date user starts the address of the message instead of the statement does not perform the basic implementationfirst, Data Control Language (DCL)1, the data control, in fact, is "Assigning permissions"-related to users.2, the main problem is
Parameters
The value of the in parameter must be specified when the stored procedure is called, and the value of the parameter modified in the stored procedure cannot be returned as the default value.
out : This value can be changed
Source Address: https://www.jb51.net/article/140939.htmUsing Scrapy to crawl some of the data on the web, stored in the MySQL database, want to use Django to show the data, see on the web is using the Django models and Makemigration,migrate commands
MARIADB is a branch of MySQL source code, and as Oracle buys Sun,mysql it falls into the hands of a relational database. After realizing what Oracle would do with the MySQL license (MySQL was acquired by Sun and Oracle), Michael, the father of MySQL,
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service