FredGrit

2022年5月15日

Lost connection to MySQL server during query (MySQL error code: 2013, SQLState: HY000 )

摘要： SHOW VARIABLES LIKE 'wait_timeout'; SET SESSION wait_timeout = 999999; SHOW variables LIKE 'NET_read_timeout'; SET SESSION net_read_timeout = 1000; SH 阅读全文

posted @ 2022-05-15 01:46 FredGrit 阅读(130) 评论(0) 推荐(0)

C++ insert into mysql Got a packet bigger than 'max_allowed_packet' bytes (MySQL error code: 1153, SQLState: 08S01 )

摘要： 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 阅读全文

posted @ 2022-05-15 00:08 FredGrit 阅读(66) 评论(0) 推荐(0)

2022年5月14日

C++ insert into table in bulk

摘要： 1.Create table in mysql CREATE TABLE `mt` ( `BookIndex` int NOT NULL AUTO_INCREMENT, `BookId` bigint NOT NULL, `BookName` varchar(100) NOT NULL, `Book 阅读全文

posted @ 2022-05-14 23:48 FredGrit 阅读(96) 评论(0) 推荐(0)

C++ cppconn insert into mysql tables

摘要： #include <iostream> #include <cppconn/driver.h> #include <cppconn/resultset.h> #include <cppconn/statement.h> #include <cppconn/exception.h> #include 阅读全文

posted @ 2022-05-14 22:46 FredGrit 阅读(108) 评论(0) 推荐(0)

C++ mysql

摘要： 1.Install C++ connector sudo apt install libmysqlcppconn-dev 2. #include <iostream> #include <cppconn/driver.h> #include <cppconn/resultset.h> #includ 阅读全文

posted @ 2022-05-14 02:19 FredGrit 阅读(107) 评论(0) 推荐(0)

Ubuntu create database and tables in mysql

摘要： 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 阅读全文

posted @ 2022-05-14 02:13 FredGrit 阅读(57) 评论(0) 推荐(0)

Ubuntu install mysql

摘要： 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 阅读全文

posted @ 2022-05-14 01:37 FredGrit 阅读(192) 评论(0) 推荐(0)

C++ pass function via <functional> function and invoke via function address

摘要： #include <iostream> #include <functional> int callFunction55(int x, int y, function<int(int, int)> func); void invokeCall56(int x, int y); int sum57(i 阅读全文

posted @ 2022-05-14 00:01 FredGrit 阅读(53) 评论(0) 推荐(0)

2022年5月13日

C++ pass function and arguments as parameter via function address * symbol

摘要： #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, 阅读全文

posted @ 2022-05-13 19:50 FredGrit 阅读(40) 评论(0) 推荐(0)

2022年4月24日

C++ call deconstructor explicitly

摘要： //Util.h #ifndef Util_H #define Util_H #include <chrono> #include <ctime> #include <fstream> #include <functional> #include <iostream> #include <threa 阅读全文

posted @ 2022-04-24 22:35 FredGrit 阅读(54) 评论(0) 推荐(0)

公告