MySQL

The script that checks whether mysql master and slave are normal is learning myslq master and slave, and wants to use a simple script to test whether the master and slave are normal. 01 #! /Bin/bash0203while getopts "h: u: p: P:" arg # The colon

Mysql database learning-3. Table creation, deletion, and change Create table mytbl (id int auto_increment not null, name char (10) not null, birth date not null, wight int, sex enum ('F ', 'M'); create table mytbl (id int auto_increment not null,

Mysql database learning-4, integrity constraints primary key create table feng(teamno int not null,playerno int not null,division char(6) not null,primary key(teamno))create table feng(teamno int not null primary key ,playerno int not null,division

MySQL learning footprint record 06 -- Data Filtering -- LIKE with percent sign (%) and underscore (_) wildcard 1. the LIKE operator * % indicates the number of times any character is matched (> = 0). To facilitate observation, all data in the

Among the many functions in the MYSQL database, there are two functions used for connection: MysQL-connect () and MySQL _ pconnect (). Syntax: int MySQL-connect (string [hostname] (: [Port, string [username], string [password]) int MySQL _ pconnect (

Innodb_file_per_table conversion between the shared tablespace and the exclusive tablespace is achieved through this parameter. If it is OFF, it indicates that the exclusive tablespace is used. [by default, the tablespace used is the shared

MySQL scheduled task event due to some business needs, we may need to regularly clear some discarded data in the database, you can use mysql stored procedures and events to complete. The following example regularly clears the data of a specified

[SQL] MySQL uses mysqlbinlog for Incremental backup and recovery detailed explanation of the Incremental backup process (1) Configure My. cnf file (my. INI file), enable binary backup: [SQL] log-bin = D:/Program Files (x86)/MySQL/mylog/juelog here

The following describes how to solve the Mysql data rollback error. You can refer to the following two methods for MYSQL transaction processing. 1. Use begin, rollback, and commit to start a transaction rollback transaction to roll back the commit

The MYSQL service cannot be started, and the message 1067 solution has to vomit that the mysql version is too unstable. After restarting the MYSQL service, it will crash. Baidu has a lot of blogs and can modify my. ini files. Nima doesn't work.

MySQL review notes I [SQL] # view the databases that contain show databases; # use test with the name test; # The simplest (tinyint is 3 bytes by default, but it can be explicitly specified as 1 byte; unsigned must follow) create table tb0 (id int

MySQL review notes II 1. Set the password for the root administrator account. Generally, the default password for MySQL is null. If you have not set the root password before, use the mysqladmin command, you can use the following mysqladmin command

Mysql enable remote access permission using the root user to log on to mysql 1. Execute the following command in the mysql command line: [plain] # mysql> grant all privilegeson *. * TO 'root' @ '%' with grant option; 2. restart the mysqld service: [

Step 1: Change the address of the mysql data storage to the default path/var/lib/mysql/, and change it to/data/mysql/data. mysql> show variables like '%dir%';+-----------------------------------------+----------------------------+| Variable_name

Big file cross-network transmission skills O & m dba cross-network transmission of large files, such as the same as the kitchen in the toilet, the general good method is not obvious, and the advantages and disadvantages of the method may be very

Some insert/update operations of mysql may use the following statements when inserting data using conditions in MySQL. Create a simple table for testing: CREATE TABLE `books` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `name` VARCHAR(200) NOT NULL,

Mysql operator (job) Create Table tmp15, including varchar type field note and int type field price, use the operator to calculate different fields in the table; use logical operators to perform logical operations on data; mysql> create table tmp15 (

Mysql 1130 error solution 1. error 1130-Host 'ipaddr 'is not allowed to connect to this MySQL server 2. The cause of the problem is that no authorization is granted, therefore, access is denied. SQL code # mysql-uroot-p Enter password: Welcome to

Shell preliminary: mysql regularly resends local data every day and replaces remote database data 01mysql regularly resends local data every day, to replace the remote database data 02, You need to import the tb_a table in the ser_a database on 192.1

Mysql ifnull function uses mysql ifnull (expr1, expr2) If expr1 is not NULL, IFNULL () returns expr1, otherwise it returns expr2. IFNULL () returns a number or string value, depending on the context in which it is used. [sql] mysql> select IFNULL(1,0