随笔分类 -  MySQL

MySQL dump and pump
摘要：mysqldump -u root -p async_mysql_test > async_mysql_test_backup.sql create database if not exists async_mysql_test_backup; mysql -u root -p async_mysq 阅读全文
posted @ 2026-02-04 20:59 FredGrit 阅读(4) 评论(0) 推荐(0)
MySQl accessed by ssh in win11
摘要：1.Open PowerShell via administrator role,then run to confirm whether the ssh has been installed in win11 ssh -V 2.Access mysql via ssh, prerequisite y 阅读全文
posted @ 2025-10-07 21:28 FredGrit 阅读(10) 评论(0) 推荐(0)
MySQL InnoDB all data is stored in the PRIMARY key (clustered index). Each row in the table is physically ordered by the PRIMARY KEY
摘要：'CREATE TABLE `t1` ( `id` int NOT NULL AUTO_INCREMENT, `firstname` varchar(100) NOT NULL DEFAULT '''', `lastname` varchar(100) NOT NULL DEFAULT '''', 阅读全文
posted @ 2025-10-07 20:50 FredGrit 阅读(27) 评论(0) 推荐(0)
C# MySQL Dapper insert delete select update data from table
摘要：Install dapper using Dapper; using MySql.Data.MySqlClient; namespace ConsoleApp87 { internal class Program { static string connStr = @"Server=serverna 阅读全文
posted @ 2024-09-27 21:53 FredGrit 阅读(54) 评论(0) 推荐(0)
C# mysql Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
摘要：add default command timeout=0 as below string connStr = "Server=localhost;database=mydb;username=root;pwd=root;default command timeout=0"; 阅读全文
posted @ 2024-09-13 14:29 FredGrit 阅读(60) 评论(0) 推荐(0)
Mysql Non cluster combined fields select where order by field different time cost
摘要：use mydb; drop table if exists t1; create table t1 (id int auto_increment primary key, firstname varchar(100) not null default '', lastname varchar(10 阅读全文
posted @ 2024-09-12 11:49 FredGrit 阅读(27) 评论(0) 推荐(0)
MySQL
摘要：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 阅读(33) 评论(0) 推荐(0)