MySQL character set and collation Beijing MySQL DBA learning

dba

MySQL provides a variety of character set and collation choices, where character set settings and data storage are related to the interaction of the client with the MySQL instance, and the collation and string comparison rules are related. The

MySQL modified column NOT NULL error invalid use of NULL value

Scenario: MySQL adds a parent_id column to the table and sets it to not NULL, saving the Times wrong invalid use of NULL value.Cause of error: Because the parent_id of the existing data column is null, the setting conflicts with not NULL.Workaround:

MySQL naming, design, and usage specification MySQL naming, design and use code

Database environment Dev: Development environment, development of read-write, can modify table structure. Developers can modify the table structure and can modify the data at will, but need to ensure that other development colleagues are

You should upgrade to MySQL 5.5.0 or later. phpMyAdmin

I've been tossing lamp lately. "You should upgrade to MySQL 5.5.0 or later" when deploying the phpMyAdmin from the official download.The reason is that I installed the MySQL database version too low. Solution Ideas: 1, upgrade the MySQL

Detailed MySQL benchmark and sysbench tools

Detailed MySQL benchmark and sysbench toolsSource: https://www.cnblogs.com/kismetv/archive/2017/09/30/7615738.htmlObjectiveAs a background development, it is necessary to benchmark the database to master the performance of the database. This article

06-mysql Database----Table Operations

This section holds Storage Engine Introduction (Learn) Table additions and deletions to change One, storage engine (Learn)The first few sections we know that MySQL built in the Library = = = folder, the table in the Library = = =

MySQL Development advanced Article series 31 Tools (MySQL connection tool and MyISAM table compression tool)

A. mysql Connection toolAmong the tools provided by MYSQ, the DBA uses MySQL most frequently. MySQL here refers to the client tool that connects the database.1.1 Connection options-U,--user=name specified user name-P,--password[=name] Specify

MySQL datetime type generates JavaScript date object on the Web end

The server reads the comment table and returns the result set to the caller. The caller converts the result set to a JSON string list using JSON. dumps and returns it to the Web Front-end. After the datetime field dumps, it becomes a string

Java note 03: MySQL database and JDBC programming 01

JDBC is a standard solution for accessing the database system using Java. It treats different APIs of different databases separately from standard SQL statements to implement database-independent Java operation interfaces. For developers, using the

Install MySQL multi-instance in Linux as the data backup server to back up multiple master instances to one slave multi-instance

1. Download the MySQL source code version from the MySQL official website [must be the source code version] 2. follow these steps: Code Type Linux Command Line Copy code The Code is as follows: [note] adding a MySQL group and a user # Groupadd

Solve the connection between the client and the remote server (MySQL): XXX. XXX is not allowed to connect to this MySQL Server

Switch from csdn, but the original post has something wrong. I corrected it a little. 1. Create a new user, floydlee.[Root @ rainfish root] # useradd-G MySQL floydlee[Root @ rainfish root] # MySQL 2. Enter mysql. Format: grant permission on

Basic knowledge: Mysql Data Type and column type (1)

We need to convert all kinds of information in the real world into something that computers can understand. The converted information forms data. For example, a person's birth date is May 23, 1987, and his height is 170 cm. Data not only consists of

MySQL replication and temporary table (temporary table)

When creating a temporary table, you can use the temporary keyword. For example:   create temporary table tmp_table(name varchar(10) not null,passwd char(6) not null) The temporary table is only visible to the current connection. When the

MySQL database backup solution details

Original article taken from: Simplified. In the event of a system crash, you must be able to restore as much data as possible from your table to the State at the time of the crash. Sometimes it is the MySQL administrator who causes damage. The

In MySQL, the show syntax is used to obtain detailed information about the table column and the entire database.

Show databases; Show tables from db_name; Show columns from table_name from db_name; Show index from talbe_name [from db_name]; Show status; Show variables; Show [full] processlist; Show table status [from db_name]; Show grants for user; In

Detailed parsing of MySQL DELETE syntax

The following articles mainly describe the detailed parsing of MySQL DELETE syntax. First, we start with the example of single table syntax and multi-Table syntax, if you are very interested in the MySQL DELETE syntax, you can read the following

MySQL Delete record Delete and Truncate statements

YSQL provides the delete and truncate statements to delete data. Definition of the delete statement: Most of the children who often deal with databases use delete statements to delete data. Now let's take a look at the definition of the delete

Mysql database encoding problem (modify the database, table, and field encoding to utf8)

Because the utf8 character set is currently the most suitable character set for conversion between different character sets, although you may not be able to correctly view the content in the database on the command line tool, I still strongly

Mysql SKIP-NAME-RESOLVE errors cause User Permissions

Log on to mysql to view the process information.Copy codeThe Code is as follows:Show processlist;A large number of processes are found to be in the login status.By default, the skip-name-resolve option is not used when mysql is started. In this way,

MySQL INNODB Table Corruption repair process Sharing

I suddenly received an alarm from MySQL. I crashed from the database and restarted continuously. I opened the error log and found that a table was broken. If the innodb table is damaged, you cannot use repair table or other commands to repair myisam.

Total Pages: 3233 1 .... 185 186 187 188 189 .... 3233 Go to: GO

Contact Us

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

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.