MySQL

MySQL disables auto-commit settings,Add the following sentence to the My.ini fileinit_connect= ' SET autocommit=0 'But there is a problem, the root user of the autocommit variable query, this value is still 1, that is, also automatically committedA

Today when you back up a file in source mysqldump, you find that the import process reported the following error:ERROR 1231 (42000): Variable ' time_zone ' can ' t is set to the value of ' NULL 'ERROR 1231 (42000): Variable ' sql_mode ' can ' t is

Today's statistics show that a table uses table partitioning to take this opportunity to record.1. What is a table partition?Table partitioning refers to the decomposition of a table in a database into smaller, easier-to-manage parts according to

As a result of just learning Linux, choose the interface of the more friendly Ubuntu for research. Command line + visualization for beginners, the combination is relatively good, the graphical interface as a command line of a transition can be more

View MySQL Database current encodingMysql-uroot-pxxxUse tigercity;Show variables like ' character_set_database ';MariaDB [lottery]> Show variables like ' character_set_database ';+------------------------+--------+| variable_name | Value |+----------

/* 1. First solve the Internet 1-1. Refer to the Networked status file # cd/etc/sysconfig/network-scripts # vi ifcfg-eth0 1-2. Edit the Networking form See figure 1-2 1-3. Restart Network # service Network Restart | /etc/init.d/network Restart 2.

0x01Two directions of MySQL:Development DBA: Database Design (e-r diagram), SQL development, built-in functions, storage history (stored procedures and storage functions), triggers, Time Scheduler (event Scheduler)Operations----> Management DBA:

TestUnlock the main MySQL first> unlock tables;Delete a table> Use db1; > show tables; > drop table help_category;Go and see it from MySQL.> Use db1; > Show tables;No help_category.///////////////////////////////////////////////////////////////////

1.linux commands to start MySQL:Mysqladmin start/ect/init.d/mysql start (front of MySQL installation path)2.linux Restart MySQL command:Mysqladmin restart/ect/init.d/mysql Restart (front of MySQL installation path)3.linux the command to turn off

Playing with Oracle is a bit more focused on the shared pool, especially the library cache, which can really get a lot of performance gains after using bound variables (precompiled SQL). Now after the turn to MySQL, especially innodb a lot of things

Create database: Root user, create database name;--p drop database name;Select database use database name;Numeric typeMySQL supports all standard SQL numeric data types.These types include strict numeric data types (INTEGER, SMALLINT, Decimal, and

Introduction: Principle and mechanism of master-slave replicationto implement replication, you must first open The binary log(bin-log) function on the Master side , otherwise it cannot be implemented. Because the entire replication process is

Just finished the course design, also indicates that the holiday is coming soon. This course design is not difficult, nothing is to make a XXX system, to realize the user's Register, login, menu management, super users and so on some functions, so

drop table Tbl_name Physical deletion. No backup, no binary logDeleting files in the system does not erase the data in the store, but only identifies the block blocks that can be reused for redistribution.So the recovery of data is still hopeful.

As a Java developer, a database backup estimate is a must-learn.Unfortunately, I have been doing business logic processing of front and back, database operation is not how to contact.Today saw a bat file, is a DOS file copy and MySQL data backup

Share a small case in a job: Windows hosts use SQLyog to log in to the MySQL database (built on a Linux system), resulting in an error, as they often use host names on Windows to access resources, Telnet, and so on. Thought Linux should also be

How to Use mysqldump to back up MySQL Data, MySQL's mysqldump tool supports single-threaded operations. Multiple tables are exported one by one without a parallel machine, which makes it unable to quickly back up data. Mydumper is a utility that

Detailed installation process of source code in the latest version of MySQL5.7.101 ,: Package: http://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.10.tar.gz You can download wget or remote upload from a local pc to linux. Installation document

Create user authorization in Mysql and create user authorization in mysql 1. Create a user: Command: create user 'username' @ 'host' identified by 'Password '; Description: username-the username you will create, host-specifies the host on which the

Query in English Original article link: http://www.cnblogs.com/lyhabc/p/3732942.html This section describes basic queries in MYSQL (MYSQL official reference manual) The basic syntax of select in MySQL: Select attribute list from Table Name and