MySQL

Numeric Typeinteger Type  tinyint  smallint  Mediumint  Int|integer bigint　　Attention:1, how to choose the data type, our principle is: enough on the line! As much as possible to choose to occupy the small memory of the integral type, but also more

In the daily operation of Linux, the backup of MySQL database is a very important part. With regard to MySQL backup and recovery, it is more traditional to use the Mysqldump tool. Today introduce another MySQL backup tool Innobackupex, use it to do

Ubuntu 16.04 LTS installation nginx/php 5.6/mysql 5.7 (LNMP) with Laravel1, MySQL Installation "Install MariaDB"MARIADB is a branch of MySQLFirst, update the upgrade system$ sudo apt update$ sudo apt upgradeInstall MARIADB:$ sudo apt install mariadb-

Today in the MySQL, when a sudden appearance of this error message, it was forced, but after careful observation of the cause of the foreign key, this is due to delete the table when there is a foreign key association when there is a delete error,

First, operation and status　　When using the MySQL client to connect to localhost local database, the connection is not up, error. (You can connect to a database using Tomcat, but it takes a long time to request.) ）Ii. Causes and SolutionsOn the

MySQL Benefits:Easy to use, low cost, easy to expand, replication leadingThe life cycle of MySQL:MySQL server listener 3306 port > Authenticate Access user > create MySQL thread > Check memory (qcache) > Parse sql> generate query plan > Open Table >

I am a living example, the University of Instrumentation major, 12 after graduating the first job is a circuit board test. Because the project is exposed to the database of things, purely when the advanced point of the Excel table with.At that time

　　1. "Cause of the incident"Today in the project, found to provide the client interface time is very slow, reached more than 2 seconds, I first time, grabbed the interface, looked at the operation of SQL, found to be 2 SQL slow, accounted for more

Overview of the changes made by Spark 2.0 you can refer to the official website and other information, here no longer repeat Since the spark1.x SqlContext is integrated into the sparksession in spark2.0, the use of Spark-shell client operations

Unified Character Set guaranteed not garbled: suggested Chinese and English environment Choice UTF81.Linux system language /etc/sysconfig/i18nLang= "Zh_cn.utf8"2.mysql client Temporary:Set names UTF8;Permanent:configuration file

1. When Union union makes multiple query statements, the number of result columns required for multiple queries must be the same. At this point, the result of the query is based on the column name of the first SQL statement and the Union is

How to completely uninstall MySQL and delete it from your Mac (including all databases) do the following: Open terminal window Use mysqldump to back up your database with a text file! Stopping the database server sudo

MySQL Database Import and Export, mysql Database Export 1. Import Database Enter: mysql -u username -p test   Note: Username is the database user name, Test is the target database, /Home/data/test. SQL is the path and name of the Backup Press enter

When MySQL optimizes the Table, it prompts the solution for Table is already up to date. mysqlalready When phpMyAdmin is used in the background to optimize the database, it is displayed as "Table is already up to date ". Many may be worried about

Mysql datetime query exception troubleshooting, mysqldatetime Query An error occurred while querying mysql datetime. Exception: Value '2017-00-00 00:00:00 'can not be represented as java. SQL. Timestamp (0000 11:38:40) Description: non-null

Graphic tutorial on modifying the initial password of Mysql5.7.11 in windows, and the initial password of mysql5.7.11 Mysl was installed last week but cannot be logged in. It took a long time for me to find the solution. Thank you for the

Mysql too connector connections solution, mysqlconnections Mysql error prompt too many ons,I recently encountered this error and solved it by checking the information on the Internet. Here I will record it to help friends who need it, The solution

Mysql 5.5 installation and configuration simple tutorial, mysql5.5 The following is the MySQL installation process. It is installed using an executable file! 1. Open the downloaded mysql Installation FileMysql-5.0.27-win32.zip,

Solve the problem that mysql enters the password to crash, mysql enters the password to crash Before starting this article, make sure that your mysql password is correct. Let's take a look at it later. 1. First, go to cmd and switch to the MySQL

When a foreign key is added to MySQL, the following error occurs: 1215 Cannot add the foreign key constraint, 1215 constraint Preface This article mainly covers ERROR 1215 (HY000): Cannot add foreign key constraint when creating a table, if you are