05 2022 档案
摘要：1. sudo -i; 2. cd /var/lib/mysql/;ls -lct; 3.Delete binlog files rm -rf binlog.* 4. ls -lct; 5.Then check the space via df -h; As the above snapshot i
阅读全文
摘要：1.New notepad++,edit as below,save as exec.bat; .\ConsoleApplication1.exe 100; 2.Powershell run the exec.bat; .\exec.bat; 3.Stop the executed bat prog
阅读全文
摘要：// ConsoleApplication1.cpp : This file contains the 'main' function. Program execution begins and ends there. // #pragma comment(lib, "rpcrt4.lib") #i
阅读全文
摘要：//Util.h#ifndef Util_H #define Util_H #include <functional> #include <iostream> #include <mysql/mysql.h> #include <random> #include <sstream> #include
阅读全文
摘要：#ifndef Util_H #define Util_H #include <functional> #include <iostream> #include <mysql/mysql.h> #include <sstream> #include <string.h> #include <uuid
阅读全文
摘要：1.filter column which has number select group_concat(table_name) from information_schema.tables where table_schema='db' and table_name REGEXP '[[:digi
阅读全文
摘要：#include <chrono> #include <fstream> #include <iostream> #include <mysql/mysql.h> #include <sstream> #include <string.h> #include <uuid/uuid.h> #inclu
阅读全文
摘要：1.h1.cpp #include <chrono> #include <iostream> #include <mysql/mysql.h> #include <sstream> #include <string.h> #include <uuid/uuid.h> using namespace
阅读全文
摘要：1.Source code in h1.cpp #include <iostream> #include <mysql/mysql.h> using namespace std; void mysqlClientInsert2(); int main(int args, char **argv) {
阅读全文
摘要：1. cpp #include "Model/Util.h" #include <functional> #include <string_view> #include <experimental/source_location> #include <cppconn/driver.h> #inclu
阅读全文
摘要：1.Install mysqlclient sudo apt-get install mysql-client 2.Add #include <mysql/myql.h> and cpp file #include <iostream> #include <mysql/mysql.h> using
阅读全文
摘要：SHOW VARIABLES LIKE 'wait_timeout'; SET SESSION wait_timeout = 999999; SHOW variables LIKE 'NET_read_timeout'; SET SESSION net_read_timeout = 1000; SH
阅读全文
摘要：1.cd /etc/mysql/ sudo vim mysql.conf.d 2 3.Move to mysqld.cnf and enter; 4.add the follow clause and add its max_allowed_packet value to 1000M max_all
阅读全文
摘要：1.Create table in mysql CREATE TABLE `mt` ( `BookIndex` int NOT NULL AUTO_INCREMENT, `BookId` bigint NOT NULL, `BookName` varchar(100) NOT NULL, `Book
阅读全文
摘要：#include <iostream> #include <cppconn/driver.h> #include <cppconn/resultset.h> #include <cppconn/statement.h> #include <cppconn/exception.h> #include
阅读全文
摘要：1.Install C++ connector sudo apt install libmysqlcppconn-dev 2. #include <iostream> #include <cppconn/driver.h> #include <cppconn/resultset.h> #includ
阅读全文
摘要：1.Check status sudo systemctl mysql status; 2.If not started mysql service sudo service mysql start; sudo service mysql status; 3.Then log in mysql vi
阅读全文
摘要：1, sudo apt update 2. sudo apt upgrade 3. sudo apt install mysql-server 4.Check version mysql --version 5. sudo mysql_secure_installation And failed,i
阅读全文
摘要：#include <iostream> #include <functional> int callFunction55(int x, int y, function<int(int, int)> func); void invokeCall56(int x, int y); int sum57(i
阅读全文
摘要：#include <iostream> #include <functional> using namespace std; int sum41(int x,int y); int multiply42(int x,int y); int passFuncAddress43(int x,int y,
阅读全文
