MySQL

Conditional statementsdelimiter \\CREATE PROCEDURE proc_if ()BEGIN      declare i int default 0;   if i = 1 THEN       SELECT 1;   ELSEIF i = 2 THEN       SELECT 2;   ELSE       SELECT 7;   END IF;END\\delimiter ;Looping statementsWhile

One, MySQL adds a time interval for the date: Date_add ().1. Example:Set @dt = Now ();Select Date_add (@dt, Interval 1 day); -Plus 1 daysSelect Date_add (@dt, interval 1 hour); -Plus 1 hoursSelect Date_add (@dt, interval 1 minute); -Plus 1

mysql,mysqldump,php connecting to MySQL service often prompts the following error:ERROR 2002 (HY000): Can ' t connect to local MySQL server through socket '/var/lib/mysql/mysql.sock ' (2)There are typically two reasons for this problem:1. The MySQL

Generation of database table design, generation of SQL statements, generation of database projects, generation of MySQL database First, training purposes through comprehensive training to further consolidate and deepen the basic knowledge and

Note: In the case of CentOS 7, you can use MARIADB instead because the MySQL database has been removed from the default program list: Installation commands Related commands for MARIADB database Systemctl start mariadb

1. Install PHPyum install -y php php-mysql2, Installation Percona-zabbixyum install -y https://www.percona.com/downloads/percona-monitoring-plugins/percona-monitoring-plugins-1.1.7/binary/redhat/7/x86_64/percona-zabbix-templates-1.1.7-2.noarch.rpm3,

Why use incremental backups?There are two ways to fully backup, one is to use tar to package the data file, and the other is to use mysqldump for a full backup. The problem with a full backup is easy to see, every time the data content is backed up,

1, Connection MySQL format: mysql-h host address-u user name-P user Password1. Connect to MySQL on this machine. First open the DOS window, then enter the directory Mysql\bin, and then type the command Mysql-u root-p, enter after the prompt you to

Add by Zhj: In the MySQL5.6 of some parameters have been increased, see http://dev.mysql.com/doc/refman/5.6/en/server-system-variables.html Original:/http mageedu.blog.51cto.com/4265610/1062628 Marco Education Linux Operations training  autocommit={0

Damn it. MySQL does not have a specialized processing function for UNIX timestamps, so if you encounter time groupings and you are using an integer UNIX timestamp, only the other date types that are converted to MySQL!From_unixtim () converts a Unix

Recently need to do JSP project, deployed in Ubuntu, the weekend time to configure the Nginx + PHP + mysql + phpmyadmin + tomcat environment, from the Windows C # turn around, how much some do not adapt, estimated to go the whole stack direction. By

1. Prerequisites: Sufficient space. If you have already installed IIS, uninstall or disable IIS. Actually, it is to close any port 80Program. 2. Software preparation = Apache Version: apache_2.2.6-win32-x86-no_ssl.msi Role: Web Server =

Switch from csdn, but the original post has something wrong. I corrected it a little. 1. Create a new user, floydlee.[Root @ rainfish root] # useradd-G MySQL floydlee[Root @ rainfish root] # MySQL 2. Enter mysql. Format: grant permission on

1. What does "NDB" mean?It means: "Network Database". NDB (also called NDB Cluster or NDBCLUSTER), you can use it to allow MySQL to support clusters. 2. What is the difference between cluster and replication?In the replication system, a MySQL master

SQL statement, mysql database, SQL statement mysql SQL statement to insert data in one table and specific data (fixed constants) into another table insert into wm_jobpoint_allstatus(CODE,pointstatus,housestatus,roomstatus,workstatus) select code,0,1,

  [Content Overview] This book is designed and implemented by a MySQL expert from Sun's Chinese Engineering Institute. The author divides the complex MySQL kernel into multiple functional subsystems to resolve various difficulties in understanding

Author/Translator: ye Jinrong (Email: imysql@imysql.cn), source: http://imysql.cn, reproduced please indicate/translator and source, and cannot be used for commercial purposes, offenders must investigate.0. Preface This article mainly

Oracle released the MySQL reference architecture for large-scale scalable Website Infrastructure White Paper, which provides a recommended topology for websites of different types and sizes that use MySQL as data storage. Provides four types of

CentOS 5.4 pptp + freeradius2 + mysql + daloradius perfect integration (illustrated) I. Install related configuration packages 1. Install httpd, mysql, and php related packages [plain] 1. [root @ localhost ~] # Yum-y install httpd-devel mysql-server

Add the remote user admin password as password grant all privileges on *. * TO admin @ localhost identified by \ 'password \ 'with grant option grant all privileges on *. * TO admin @ \ "% \" identified by \ 'password \ 'WITH GRANT OPTION Add a