Programmer Group

/**Create table **/ /**Create table 1**/ CREATE TABLE `product` (   `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,   `amount` INT(10) UNSIGNED DEFAULT NULL,   PRIMARY KEY  (`id`) ) ENGINE=INNODB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8; /**Create table 2**/ CREATE TABLE `product_details` (   `id` INT(10) UNSIGNED NOT NULL,   `weight` INT(10) UNS ...

The following script is from the network, and the copyright belongs to the original author (it is recommended to automatically back up at night, and use cron to plan tasks) #!/bin/bash #Save the number of backups and backup the data for 7 days number=7 #Backup save path backup_dir=/var/erp/data/mysql #date dd=`date +%Y-%m-%d-%H-%M-%S ...

Author: Yang Taotao This article introduces the use of MySQL parameter join ﹣ BUFFER ﹣ size in the INNER JOIN scenario, which is not included in OUTER JOIN. Before discussing the BUFFER, let's first understand the INNER JOIN classification of MySQL. If it is subdivided according to the retrieval performance, whether it is two or more inner jo ...

1. Install MySQL driver Installation mode: open the command line and execute the go command: go get -u github.com/go-sql-driver/mysql 2. Connect MySQL To build a connection, the format is: "user name: password @ tcp(IP: port) / database? charset=utf8" Open the database, the forme ...

Guide reading Usually, we call last? INSERT? Id() to get the latest auto increment ID after executing an INSERT, but this is not very reliable. When the last INSERT id() function has no additional parameters or expressions, it returns an unsigned BIGINT. By default, it returns the value after the last INSERT of the au ...

Requirements: when developing business reports, it is necessary to read data from MySQL database, then write it to the database, and run batches using scheduled tasks. Analysis: ① considering performance; ② MySQL is not as convenient and powerful as Oracle. To sum up, thread pool is used to insert MySQL database in batch Submission Scheme. Thi ...

Source code: GitHub point here || GitEE point here Update progress (6 sections in total): 01: brief introduction of project technology selection and schematic description of structure 02: business architecture design, system hierarchical management 03: database selection, business data design and planning I. database selection 1. Database ...

Basic operation methods of redis 1.redis Connections for: //Instantiate redis $redis = new Redis(); //Connect $redis->connect('127.0.0.1', 6379); //Check whether the connection is successful echo "Server is running: " . $redis->ping(); // Output result Server is running: +PONG 2.redis operation Strng (string): // Set the value of ...

Log in to liunx to get administrator permission sudo -i cd /home/maxiaolin Install jdk yum -y install java java -version Install mysql Check if mysql is installed rpm -qa | grep mysql >>mysql-libs-5.1.73-7.el6.x86_64 Uninstall mysql RPM - E -- nodes mysql-libs-5.1.73-7.el6.x86_ (the option you see) / / strong delete mode. If you use the a ...

Mysql installation Download and install Download and install MySQL's official Yum Repository wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm Yum installation source yum -y install mysql57-community-release-el7-10.noarch.rpm Install Mysql yum -y install mysql-community-server Set Mysql to power on systemct ...