Posts about MariaDB
MariaDB update query
May 16, 2021 13:00 0 Comment MariaDB
Command prompt, Command prompt, PHP update query script, The UPDATE, command modifies an existing field by changing the value. I, t uses the SET clause to specify the column to modify and to specify the new
MariaDB regular expression
May 16, 2021 14:00 0 Comment MariaDB
MariaDB regular expression, In addition to pattern matching provided by theLIKE clause, MariaDB provides regular expression-based matching through the REGEXP operator. T, he oper
MariaDB table change command
May 16, 2021 14:00 0 Comment MariaDB
Use ALTER to modify the column, Use ALTER to modify the column, Use ALTER to modify the table, The ALTER command provides a way to change the structure of an existing table, which means deleting or adding columns, modifying the index, changing t
MariaDB practical features
May 16, 2021 14:00 0 Comment MariaDB
MariaDB aggregation function, MariaDB aggregation function, Maria DB age calculation, MariaDB string connection, MariaDB date/time function, MariaDB numeric function, MariaDB string function, This chapter contains a list of the most commonly used features, providing definitions, descriptions, and examples., MariaDB aggregation function, The
MariaDB transactions
May 16, 2021 14:00 0 Comment MariaDB
The structure of the transaction, The structure of the transaction, Transactions are sequential group operations. T, hey run as a single cell and are not terminated until all operations in the group are successfully ex
MariaDB backup loading method
May 16, 2021 14:00 0 Comment MariaDB
Use LOAD DATA, Use LOAD DATA, Use MYSQLIMPORT, Use MYSQLDUMP, In this chapter, we'll look at the various backup loading methods. R, estoring a database from a backup is a simple and sometimes very long process.,
MariaDB backup method
May 16, 2021 14:00 0 Comment MariaDB
Backup tools, Backup tools, Using SELECT ... INTO OUTFILE statement, Connectect is used in backups, Other tools, Data is the foundation of business and operations, and with a variety of possible threats (e.g., attackers, system failures, poor upgrades, and mainte
MariaDB empty value
May 16, 2021 14:00 0 Comment MariaDB
NULL operator, NULL operator, Sort the NULL values, NULL function, Insert a NULL value, When using NULL values, keep in mind that they are unknown values. T, hey are not empty strings or zeros, they are valid values. I, n table creation,
MariaDB Join data join statement
May 16, 2021 14:00 0 Comment MariaDB
Command prompt, Command prompt, PHP scripts use JOY, In previous discussions and examples, we examined retrieving multiple values from a single table or from multiple sources. M, ost real-world data oper
MariaDB data type
May 16, 2021 14:00 0 Comment MariaDB
The digital data type, The digital data type, The date and time data type, String data type, A good field definition is critical to optimizing the database. T, he ideal approach requires you to specialize in fields of the type and size you wan
MariaDB ORDER BY sort clause
May 16, 2021 14:00 0 Comment MariaDB
Command prompt, Command prompt, THE ORDER BY clause is used in PHP scripts, As mentioned in the previous discussion, the ORDER BY clause sorts the results of statements. I, t specifies the order in which the data is operated a
MariaDB index and statistics table
May 16, 2021 15:00 0 Comment MariaDB
Create an index, Create an index, Delete the index, Rename the index, Manage the index, Table statistics, Indexes are tools used to speed up record retrieval. T, he index generates an entry for each value in the index column., There are four types of index
MariaDB Temporary Table
May 16, 2021 15:00 0 Comment MariaDB
Create a temporary table, Create a temporary table, Administrative, Delete the temporary table, Some operations may benefit from temporary tables due to speed or one-time data. T, he life of the temporary table ends at the end of the session, whe
MariaDB clone table
May 16, 2021 15:00 0 Comment MariaDB
MariaDB clone table, In some cases, an exact copy of an existing table needs to be generated. C, REATE ... S, elect statements cannot produce this output because it ignore
MariaDB sequence
May 16, 2021 15:00 0 Comment MariaDB
Install the sequence engine, Install the sequence engine, Create a sequence, In version 10.0.3, MariaDB introduced a storage engine called sequence. I, ts ad hoc generates an integer sequence for the operation and then terminat