MySQL

1. Modify the table name ALTER TABLE test rename test1;2. Add a row of ALTER TABLE test ADD column name varchar (ten) not null;3. Delete the row ALTER TABLE test drop column name;4 Modifying the column type ALTER TABLE test modify name varchar

Sub-query classificationScalar Quantum query: Query results are single rowColumn query: More than one rowRow subquery: Multi-column single rowTable subquery: Multi-row multi-columnSub-query support rulesSelect scalar Quantum QueryFrom "Join" Table

Today to learn MySQL user management, accidentally the root user in the Mysql.user table is deleted, and then can not log in MySQL, the web found the solution of Linux, I made a simple modification, changed to my Windows edition , The recovery

How MySQL modifies the passwordIf you forget your password--skip-grant-tables1. Alter useralter user [email protected] ' localhost ' identified by ' xxxx! ';2. GrantShow grants for [email protected] ' localhost '; GRANT USAGE on * * to ' test ' @ '

http://blog.csdn.net/u012408083/article/details/52734762MySQL command line query garbled encoding problemWhen using database Tools to query data display data is normal, Chinese is normal, using the command query, Chinese display garbledTo view the

The operation and maintenance of MySQL database mainly includes the setting of user rights, backup and recovery of database.I. Granting permissionsGrant permission list on the Library name. Table name to User name @ Source Address {identified by '

First of all:Use show variables like "%colla%"; show varables "%char%"; these two commands view the character set settings of the database and the server sideIf the view is gbk2312, or GBK, then can only support Simplified Chinese, traditional and

Import pymysql#s LINK Database conn = pymysql.connect ( host = ' 127.0.0.1 ', #被连接数据库的ip地址 port = 3306, #数据库服务端端口号 user = ' root ', #用户名 password = ' 123456 ', #密码 database = ' db1 ', #选择库 charset = ' UTF8 ' #

cd/usr/Localwgethttp//repo.mysql.com//mysql57-community-release-el7-7.noarch.rpmRPM-IVH mysql57-community-release-el7-7. noarch.rpmYum Install-Y mysql-serversystemctl start mysqld.servicesystemctl status Mysqld.servicecd/etc andVIMY.CNF and add at

1. mysql OverviewMySQL was originally a relational database management system developed by "MySQL AB" (rdbms-relation databases Management systems). MySQL is not only the most popular open source database, but also the fastest growing database in

MySQL Master-slave configuration MySQL Master-Slave introduction Preparatory work Configure the Primary Configuration from Test Master-Slave synchronization MySQL Master-Slave introductionMySQL master-slave is also called

Delete the data in the table, using delete. The format is:Delete from table name where remove condition; Example: Delete a record whose name is Zhang San in the student table.Delete from where="Zhang San"; Clears the data in the table, saves

A few days ago to learn some basic knowledge of MySQL database, understand the background database of some basic data operations: adding and removing changes, for the project before and after the data transfer has some concepts, summed up some MySQL

/* time:2017.01.02--2017.01.04* AUTHOR:WJ* Function: Connect the database, read the picture from the database and display (succeeded)*/"Reference link"MySQL deposit image +QT read in the database read the picture-lpdpzc column-Blog channel-csdn.net

1. Missing components[Email protected] support-files]# mysql_convert_table_format-uroot-p123456-e MyISAM USER ABCCan ' t locate dbi.pm in @INC (@INC contains:/usr/local/lib64/perl5/usr/local/share/perl5/usr/lib64/perl5/vendor_perl/

Query: Field Select field 1, Field 2, Field 3 from table name where condition"+" sign: Only for numeric calculations select 1+2 or select 1+ ' 2 '"CONCAT": Used for connection string CONCAT (character 1, character 2), such as a select CONCAT (12)

phpMyAdmin Construction StepsHint: This environment needs to be built under the condition of LNMP or lamp environment1. Download the source packagewget https://files.phpmyadmin.net/phpMyAdmin-4.6.4-all-languages.tar.gz2. Extract the source package

Common Database-related operations Common Database Operations:   1. Import and export data Method 1:1. Export query results: select statement into outfile 'Save path + file'2. Import query results: load data local infile 'Storage path + file

The decimal value in the mysql stored procedure is automatically rounded to this pitfall, mysqldecimal Let me say a few other things: I use Microsoft for my daily work. The SQL service stored procedure is very powerful and I am also very used to

Use Xtrabackup to back up and restore the database, Install Xtrabackup wget https://www.percona.com/downloads/XtraBackup/Percona-XtraBackup-2.4.9/binary/redhat/7/x86_64/percona-xtrabackup-24-2.4.9-1.el7.x86_64.rpmyum install percona-xtrabackup-24-2.4