Definition and usage of cursors in MySql

Create a Cursor First create a data table in MySql: CREATE TABLE IF NOT EXISTS `store` (     `id` int(11) NOT NULL AUTO_INCREMENT,     `name` varchar(20) NOT NULL,     `count` int(11) NOT NULL DEFAULT '1',     PRIMARY KEY (`id`)   ) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7;      INSERT INTO `sto ...

Added by powergen on Tue, 21 May 2019 22:49:25 +0300

Read-Write Separation of Mysql Master-Slave Configuration

I. Several schemes for master-slave replication of MySQL Database read-write separation is an indispensable and important function for large-scale systems or high-volume Internet applications. From the database point of view, for most applications, from centralization to distribution, the most basic requirement is not the bottleneck of data s ...

Added by cap2cap10 on Tue, 21 May 2019 03:18:58 +0300

C++ ADO operates mysql database

For software development, in fact, it means dealing with data constantly, so the operation of database is indispensable. Next, it introduces how to use ADO to establish ODBC data source to access MySQL database in VC development. From the way of database programming I come into contact with, I think it is difficult and error-prone to develop a ...

Added by sholtzrevtek on Mon, 20 May 2019 22:52:22 +0300

Dictionary of python data type‘

1. Why need dictionary type >>> list1 = ["name", "age", "gender"] >>> list2 = ["fentiao", 5, "male"] >>> zip(list1, list2) >>>userinfo=dict(zip(list1, list2)) // Combining the two lists through zip built-in functions [('name', 'fentiao'), ('age', 5), ('gender', 'male')] >>> list ...

Added by Hooker on Mon, 20 May 2019 02:02:12 +0300

MySql Learning Notes: JOIN

Prerequisite: Create two relational tables:  CREATE TABLE t_blog(         id INT PRIMARY KEY AUTO_INCREMENT,         title VARCHAR(50),         typeId INT ); CREATE TABLE t_type(         id INT PRIMARY KEY AUTO_INCREMENT,         name VARCHAR(20) ); The table data are as follows: 1. Acquisition of Public Parts A and B MySql provides an int ...

Added by erichar11 on Sun, 19 May 2019 16:27:05 +0300

SpringBoot Unofficial Tutorial | Part 4: SpringBoot Integration JPA

For reprinting, please indicate the source:http://blog.csdn.net/forezp/article/details/70545038  This article is from Fang Zhipeng's blog The full name of JPA is Java Persistence API.JPA describes the mapping relationship of object-relational tables through JDK 5.0 annotations or XML, and persists the runtime entity objects to the database. ...

Added by Chef-Mars on Sun, 19 May 2019 12:17:31 +0300

Linux System Diagnosis Tips (15): How to Fix File System Damage with Start-Stop Problems

Digression Let's start with what file systems are and what tools are needed. file system Nowadays, there are many kinds of storage and complex stacks. But the user's direct interface is still file system . For Linux and the open source community, a lot of software is also dependent. file system . MySQL and PostgreSQL databases, for example, c ...

Added by mortona on Sun, 19 May 2019 08:56:28 +0300

Python Learning Notes _02: Using Tkinter to Connect MySQL Database to Realize Login Registration Function

1 Environmental Construction 1.1 Python installation 1.2 MySQL Environment Construction 1.3 Install MySQLdb 2. Realization 2.1 Landing Interface 2.2 Registration Interface 2.3 Specific implementation of part of the code   1 Environmental Construction 1.1 Python installation This paper implements part of Python environment: Python 2.7.1 ...

Added by sasi on Sun, 19 May 2019 06:33:34 +0300

mysql linux c api and notes

Commonly used linux C API Multithread related routines Common mysql statements Problems encountered Start mysql service to report errors Import file error reporting Commonly used linux C API MYSQL *conn = mysql_init(void); //Initialize mysql and return mysql handle //iferr(!conn) conn = mysql_real_con ...

Added by kpmonroe on Sun, 19 May 2019 05:54:15 +0300

mysql+mycat read-write separation

Environmental Science 192.168.2.118 mysql-master/mycat 192.168.2.119 mysql-slave Configure jdk tar -zxf jdk-8u151-linux-i586.tar.gz mv jdk1.8.0_151 /usr/java/ Configure environment variables and take effect vim /etc/profile export JAVA_HOME=/usr/java/ export CLASSPATH=$CLASSPATH:$JAVA_HOME/lib:$JAVA_HOME/jre/lib export ...

Added by foreknowapparel on Sun, 19 May 2019 01:48:47 +0300