MySQL

#访问控制# #登录mysqlMysql-u root-p# #查看所有用户Select User from Mysql.user# #创建用户CREATE USER ' username ' @ ' host ' identified by ' password ';# #删除用户Note that you must explicitly give the hostname of the accountDrop user ' test ' @ ' localhost ';#

Create a tableCREATE TABLE Test (ID Int (TEN) NOT null primary key auto_increment,MD5 varchar (30),subkey Int (15)) Engine=innodb;Modify TableAdding columnsALTER TABLE test add column num int;modifying columnsALTER TABLE test modify column num

First of allTo add a pymysql module:Code:Import Pymysqldb = Pymysql.connect (host="LocalHost", User="Root", password="123456", db="World", port=3306)# Open Database connectioncur = db.cursor ()# get an action cursor using the

The importance of the security of the database does not need me to repeat it. In addition to doing a secure backup, the first thing we need to do is to do our database permissions control, as far as possible to protect our database against

Aggregation Functionsaggregation : Aggregates the scatter together.aggregate function : operation on the column, the returned result is a single value, except COUNT, will ignore null valuecount: Counts the number of record rows for which the

Server hardware optimization:1 Better CPU SelectionMySQL has some work that only uses single-core CPUs, such as replicate and SQL. The number of CPU cores is not as good as possible, the server used by MySQL5.5 cannot exceed 32 cores, otherwise

The recently-online system has newly hung a disk, and the MySQL data directory under the system disk needs to be migrated to the data disk.After some investigation, MySQL used the precompiled binary tar.gz package when it was installed. There are

import sysreload(sys)sys.setdefaultencoding( "utf-8" )import requestsimport jsonimport pymysqlconn = pymysql.connect(host=‘localhost‘,port=3306,user=‘root‘,password=‘root‘,db=‘toutiao‘,charset=‘utf8‘)cursor = conn.cursor()url =

1. If you want to use a function in a MySQL statement, be sure to remember that there is no space allowed between the function name and the parentheses following it. Having space-time lattices can cause syntax errors.2. If you have entered several

Connect MySQL database command: mysql-u root-pCreating MySQL Database: Create databaase XX library;To create a MySQL table:CREATE TABLE Db_xx Tables (ID int primary KEY auto_increment,Name varchar (+) is not NULL,Address varchar (+) is not

1. Include table headermysql -h${1} -P${2} -u${3} -p${4} -Dpom_${5} --default-character-set=utf8 -B -e > result.csv2. Without the table headmysql -h${1} -P${2} -u${3} -p${4} -Dpom_${5} --default-character-set=utf8 -B -N -e > result.csv3. Separating

String functions (which are primarily used to process strings):Cancat (str1, str2, ... strn) connection string str1, str2 ..., strn as a string;Insert (str, x, Y, instr) starts the string str from position x, and the substring of Y strings is

The on DUPLICATE key update syntax is not a standard syntax for SQL, and if specified at the end of a sentence, it updates the contents of the database according to the specified primary key or uniquely labeled indexThe specific action is to see if

Directory Migration Shutting down the database serviceservice mysqld stop Copy Databasemv /var/lib/mysql /data/mysql# 或者使用cp -a复制# 这两个命令都会带权限到新目录去 Modifying a configuration file/etc/my.cnf[mysqld]#datadir=/var/lib/mysql

MYSQL User's authorizationWhy authorize?MySQL's default user is root, because root is too large, but also for security reasons, generally only in the management of the database, if you want to connect a MySQL database in the project, it is

A view is a virtual table that does not actually store data and stores a "functional relationship."Grammar:CREATE VIEW name as SELECT statement.Why does a view store a function relationship?When referencing a view, it looks for related fields based

MySQL master-slave synchronization principleTransfer from Blog Park-aiapple:http://www.cnblogs.com/aiapple/p/5792939.htmlmaster-Slave formMySQL master-slave replication flexibility One Master one from Primary master replication One

MySQL: database entry, mysql database entry 1. What is a database? -- Data storage warehouse Database technology is a very important technology in the computer application field. It was developed at the end of 1960s and is the latest technology of

About mysql startup --- mysqld_safe mysqld from pid file * ended, Let me first talk about how to install mysql: 1. At the beginning, installing mysql is a software package that can be decompressed. I decompress it, copy it to the/usr/local/directory,

MySQL Stored ProcedureA storage routine is a set of SQL statements stored on the database server. You can run these SQL statements by calling a specified name in the query.The SQL statement needs to be compiled and then executed, while the Stored