FredGrit

2022年12月4日

摘要： 1. show create table tb2;show create table tb3; 2.desc tb2;desc tb3; 3.select count(Idx) from tb2; select count(Idx) from tb3; desc tb2;desc tb3;selec 阅读全文

posted @ 2022-12-04 21:25 FredGrit 阅读(21) 评论(0) 推荐(0)

mysql Lost connection to MySQL server during query

摘要： SET GLOBAL connect_timeout = 6000;SHOW VARIABLES LIKE "%timeout"; 阅读全文

posted @ 2022-12-04 20:15 FredGrit 阅读(79) 评论(0) 推荐(0)

linux commands

摘要： Find and delete files greater than a given size from the Linux command line sudo -u root sh -c 'cd ./snapd/cache/ && find . -size +100M -exec rm -rf { 阅读全文

posted @ 2022-12-04 19:41 FredGrit 阅读(137) 评论(0) 推荐(0)

cpp mysql libmysqlcppconn-dev create table and insert multiple values into the table

摘要： //Util.h #pragma once #include <chrono> #include <ctime> #include <dirent.h> #include <fstream> #include <iostream> #include <thread> #include <unistd 阅读全文

posted @ 2022-12-04 18:12 FredGrit 阅读(44) 评论(0) 推荐(0)

Got a packet bigger than 'max_allowed_packet' bytes,cpp mysql insert multiple values and exceed maximum capacity

摘要： You can also log into MySQL console and run the following command to set max_allowed_packet size for the duration of the session. set global net_buffe 阅读全文

posted @ 2022-12-04 16:45 FredGrit 阅读(36) 评论(0) 推荐(0)

2022年12月3日

cpp mysql ubuntu

摘要： 1.Install libmysqlcppconn-dev sudo apt-get install libmysqlcppconn-dev 2. //MySQLHelper.h #include <iostream> #include <mysql_connection.h> #include < 阅读全文

posted @ 2022-12-03 22:13 FredGrit 阅读(49) 评论(0) 推荐(0)

Cpp serialize class in vector collection and define the serialize method in class via jsoncpp

摘要： //Model/Book.cpp #include <iostream> #include <jsoncpp/json/json.h> using namespace std; class Book { public: int Idx; double Id; char *Abstract; char 阅读全文

posted @ 2022-12-03 19:32 FredGrit 阅读(23) 评论(0) 推荐(0)

cpp template class defined in .h files and implemented in cpp files

摘要： //MathHelper.h #ifndef _MathHelper_H #define _MathHelper_H #include <iostream> #include <random> #include <stdio.h> using namespace std; template <cla 阅读全文

posted @ 2022-12-03 19:24 FredGrit 阅读(22) 评论(0) 推荐(0)

cpp list files end with suffix and list them respectively

摘要： #include <chrono> #include <ctime> #include <dirent.h> #include <fstream> #include <iostream> #include <thread> #include <unistd.h> #include <uuid/uui 阅读全文

posted @ 2022-12-03 19:19 FredGrit 阅读(23) 评论(0) 推荐(0)

2022年12月2日

jsoncpp serialize class in vector

摘要： //Book.h #include <iostream> #include <jsoncpp/json/json.h> using namespace std; class Book { public: int Idx; unsigned long long Id; char *Name; char 阅读全文

posted @ 2022-12-02 11:45 FredGrit 阅读(25) 评论(0) 推荐(0)

公告