FredGrit

2023年9月9日

摘要： mysql 5.7.16 installer download url for once click installation https://cdn.mysql.com/archives/mysql-installer/mysql-installer-community-5.7.16.0.msi 阅读全文

posted @ 2023-09-09 22:10 FredGrit 阅读(22) 评论(0) 推荐(0)

Linux commands

摘要： 1.Ubuntu install vscode; sudo snap install --classic codecode --version; 2.update upgrable upgrade sudo apt update; sudo apt list --upgradable; sudo a 阅读全文

posted @ 2023-09-09 21:57 FredGrit 阅读(45) 评论(0) 推荐(0)

Uninstall mysql completely from ubuntu

摘要： sudo systemctl stop mysql; sudo apt purge mysql-server mysql-client mysql-common mysql-server-core-* mysql-client-core-*; sudo rm -rf /etc/mysql /var/ 阅读全文

posted @ 2023-09-09 01:57 FredGrit 阅读(24) 评论(0) 推荐(0)

2023年9月8日

mysql create procedure with in parameters ,call procedure

摘要： //create procedure statementdelimiter $$ use db $$ drop procedure if exists insertIntoT1Table; create procedure insertIntoT1Table(in num int) begin de 阅读全文

posted @ 2023-09-08 20:38 FredGrit 阅读(17) 评论(0) 推荐(0)

2023年9月4日

mysql create table ,store procedure,call sp

摘要： use db; 'CREATE TABLE `t1` ( `id` bigint NOT NULL AUTO_INCREMENT, `name` varchar(40) NOT NULL DEFAULT '''', `author` varchar(40) NOT NULL DEFAULT '''' 阅读全文

posted @ 2023-09-04 21:20 FredGrit 阅读(20) 评论(0) 推荐(0)

2023年8月7日

centos generate uuid,install libuuid-devel,compile -luuid

摘要： //install libuuid-devel sudo yum install libuuid libuuid-devel #include <iostream> #include <stdio.h> #include <uuid/uuid.h> char *uuid_value=(char*)m 阅读全文

posted @ 2023-08-07 11:10 FredGrit 阅读(191) 评论(0) 推荐(0)

2023年8月2日

difference between store procedures and functions

摘要： Functions can't modify anything and must have at least one parameter. They also have to return a result. Stored procedures don't need a parameter, may 阅读全文

posted @ 2023-08-02 18:50 FredGrit 阅读(15) 评论(0) 推荐(0)

2023年7月21日

linux cpp g++ mysqlconnector

摘要： 1.install mysql in ubuntu; 2install mysqlconnector; sudo apt install libmysqlclient-dev 3.complete code #include <algorithm> #include <chrono> #includ 阅读全文

posted @ 2023-07-21 18:58 FredGrit 阅读(44) 评论(0) 推荐(0)

2023年7月20日

cpp generate uuid via rand() and test speed which is 4 times+ faster than libuuid

摘要： // main.cpp #include <algorithm> #include <chrono> #include <cstdio> #include <cstdlib> #include <cstdint> #include <ctime> #include <fstream> #includ 阅读全文

posted @ 2023-07-20 06:32 FredGrit 阅读(20) 评论(0) 推荐(0)

2023年7月19日

cpp generate uuid by random

摘要： #include <cstdio> #include <cstdlib> #include <ctime> #include <cstdint> uint32_t rand32() { return ((rand() & 0x3) << 30) | ((rand() & 0x7fff) << 15) 阅读全文

posted @ 2023-07-19 11:46 FredGrit 阅读(32) 评论(0) 推荐(0)

公告