MySQL

Add MySQL module to PHP times errorConfigure:error:mysql Configure failed. Please check the Config.log for more information.Workaround:[email protected] mysql]$/configure--with-php-config=/usr/local/bin/php-config --with-mysql-dir

String functionsSelect concat (' Hello ', ' word ', ' my ')  myname; // concat ()    link character functions    output  hellowordmy  myname is the alias Select lcase (' MYSQL ');                     //lcase ()     Convert to lowercase       Output  

Monitor MySQL with a MySQL template from Zabbix1. Installing the Zabbix Agent[Email protected] ~]# RPM-IVH http://repo.zabbix.com/zabbix/3.2/rhel/7/x86_64/zabbix-agent-3.2.0-1.el7.x86_64.rpm [[Email protected] ~]# rpm--import/etc/pki/rpm-gpg/rpm-gpg-

Server-side commands:DDL: Data definition language, primarily used to manage database components such as tables, indexes, views, users, stored proceduresCREATE, ALTER, DROPDML: Data manipulation language, mainly using the data in the management

Environment:3306 Main Library3307 from Library1 Setting the Server-id value and turning on the Binlog function parameterEdit the configuration file for MySQL/data/3306/my.cnf[mysqld]Server-id = 6----Each machine or instance Sever-id used for

27 using Mysqladmin to close a databasemysqladmin-uroot-poldboy123 shutdownPs-ef |grep MySQLMySQL forgot password re-change password:mysql> mysqld_safe--skip-grant-tables--user=mysql--defaults-file=/data/3306/my.cnf >/dev/null

Roborframework operating MySQL data:1. Need to install package robotframework_databaselibrarysudo pip install-t/usr/local/lib/python2.7/site-packages/robotframework_databaselibrary---Specified to be installed in/usr/local/lib/

One. Create user command:' username '@'host'password';Description Username: The user name you will create Host: Specifies on which host the user can log on, if localhost is available to the local user, if you want the user to be able to

#显示定时任务SHOW EVENTS;#查看是否开启定时器SHOW VARIABLES like ' Event_scheduler ';#开启定时器 (Admin user required)SET GLOBAL event_scheduler = on;#创建事件, 12-31 days a year 00:00:00 executionThe DROP event IF EXISTS "event name";DELIMITER//"Event name" of the CREATE

Issue: Calling the MySQL stored procedure in Java encountered the following error:" noaccesstoprocedurebodies=true " to has driver generate parameters that represent INOUT strings irregardless of actual parameter typesWORKAROUND: The Execute

Transaction characteristics ACIDAtomicity: atomicityA transaction must be considered an indivisible minimum unit of work, all operations in the entire transaction either commit successfully or all fail back, and for a transaction it is not possible

One day Ops suddenly said that the wireless Terminal Channel page interface is very large, memcache cache is only to come. Causes the MySQL concurrency query to be too large, causes the server to keep going down, only can restart the machine

1. Judging ApacheFirst execute the command to find the httpd path ps aux | grep httpdIf the httpd path is/USR/LOCAL/APACHE/BIN/HTTPDThen execute the following command/usr/local/apache/bin/httpd-v | grep "Server_config_file"To find the configuration

1.2003-can ' t connect to MySQL server on ' localhost ' (10060)Shut down the firewall.2.1067-invalid default value for ' state 'Modify the database (you must delete to modify, the next selection box that enters the name when you create the database

Unzip the downloaded MySQL into the specified directory (e.g. D:\mysql)Installation ServicesAt the command line, enterD:\mysql\bin\mysqld-installnet start MySQLUninstall ServiceAt the command line, enternet stop MySQLD:\mysql\bin\mysqld-removeUnder

Watch_course_sql="""SelectDate_format (From_unixtime (a.createtime/ +) ,'%%y-%%m-%%d%%t') Regtime, A.username fromBskuser awhereA.usernameinch (Selectusername frombskchapterlistwhereLessonid= (SelectID fromBsklesson

querying data for the current week SELECT Name,submittime from the Enterprise WHERE Yearweek (Date_format (submittime, '%y-%m-%d ')) = Yearweek (now ());query last week's dataSELECT Name,submittime from the Enterprise WHERE Yearweek (Date_format

Method 1: Use the Set password command    First log in to MySQL.  Format:mysql> set password for user name @localhost = password (' new password ');  Example:mysql> set password for [email protected] = password (' 123 ');  Method 2: Use Mysqladmin   

Mysql 1449: The user specified as a definer ('root' @ '%') does not exist solution, 1449 definerAn error is reported when The program calls The view of The database and directly opens The view in The database. For example, mysql 1449: The user

SQL is required and SQL is requiredAggregate functions 1. AVG () function Input:SELECT AVG (Prod_price) ASAvg_priceFROMProducts Output: Warning: only used for a single columnAVG () can only be used to determine the average value of a specific