MySQL data definition language (DDL)

SQL consists of the following four parts: 1 data definition language (DDL): DROP, CREATE, ALTER and other statements. 2 data operation language (DML): INSERT, UPDATE and DELETE statements. 3 data query language (DQL): SELECT statement. 4 data control language (DCL): GRANT, REVOKE, COMMIT, ROLLBACK and other statements. DDL(Dat ...

Posted on Mon, 23 Mar 2020 11:50:59 -0400 by majik-sheff

Centos7 installation configuration Apache (httpd) + php+mysql+phpMyAdmin

1, Install mysql Execute command:  wget http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm   rpm -ivh mysql-community-release-el7-5.noarch.rpm Execute Yum - y install MySQL MySQL server MySQL devel, and the installation is successful. Use the command again and get the following inf ...

Posted on Sun, 15 Mar 2020 05:42:47 -0400 by powah

nginx load balancing instance

Example overall framework:   Use VMware to build 5 Centos7 virtual machines (including clients), system version: CentOS Linux release 7.2.1511. The nginx version, MariaDB server version, PHP FPM version and PHPMyAdmin version of the instance are 1.12.2, 5.5.56, 5.4.16 and 4.0.10.20 respectively. All virtual machines in this instance have turne ...

Posted on Wed, 01 Jan 2020 00:14:30 -0500 by mubeena

Use of sql-parser component in phpMyAdmin

Author's introduction: Engineer Chen Miaotengxun phpMyAdmin is an open source database management tool based on Web-side operation, supporting the management of MySQL and MariDB databases. phpMyAdmin's program is mainly developed with php and javascript. Its installation and use are relatively simple and many related introductions are not ...

Posted on Sat, 20 Apr 2019 06:36:33 -0400 by dj-kenpo