村里的原振侠的博客

MySQL高级字符my.cnf配置文件最后加上character_set_server=utf8修改表的字符集mysql> alter table dubbo convert to character set 'utf8';权限查看权限mysql> select * from user\G;*************************** 1. row *************************** Host: lo

MysqlMysql 基础Create DBCREATE database demo;使用demo数据库mysql> use demoDatabase changedCreate Tablecreate table Person ( Id_P int, LastName varchar(255), FirstName varchar(255), Address varchar(255), City varchar(255) );描述Person表：mysql> d

假设新建一张Scores表格，用来记录学生分数mysql> create table Scores( Id int, Name varchar(255), Subject varchar(255), Score int );Query OK, 0 rows affected (0.01 sec)mysql> desc Scores;+---------+--------------+------+-----+---------+-------+| Field | Type

高性能Mysql实战----学习02Mysql 锁分类在 MySQL 中有三种级别的锁：页级锁、表级锁、行级锁。表级锁：开销小，加锁快；不会出现死锁；锁定粒度大，发生锁冲突的概率最高，并发度最低。 会发生在：MyISAM、memory、InnoDB、BDB 等存储引擎中。行级锁：开销大，加锁慢；会出现死锁；锁定粒度最小，发生锁冲突的概率最低，并发度最高。会发生在：InnoDB 存储引擎。页级锁：开销和加锁时间界于表锁和行锁之间；会出现死锁；锁定粒度界于表锁和行锁之间，并发度一般。会发生

高性能Mysql实战----学习02

Mysql 高性能实战MySQL 数据库的体系结构，如下图所示MySQL 体系结构由 Client Connectors 层、MySQL Server 层及存储引擎层组成。Client Connectors 层负责处理客户端的连接请求，与客户端创建连接。目前 MySQL 几乎支持所有的连接类型，例如常见的 JDBC、Python、Go 等。MySQL Server 层MySQL Server 层主要包括 Connection Pool、Service & utilities、SQL

Description:Write a SQL query to find all numbers that appear at least three times consecutively.±—±----+| Id | Num |±—±----+| 1 | 1 || 2 | 1 || 3 | 1 || 4 | 2 || 5 | 1 || 6 | 2 || 7 | 2 |±—±----+For example, given the abo

Description:Write a SQL query to rank scores. If there is a tie between two scores, both should have the same ranking. Note that after a tie, the next ranking number should be the next consecutive integer value. In other words, there should be no “holes”

Description:Write a SQL query to get the nth highest salary from the Employee table.±—±-------+| Id | Salary |±—±-------+| 1 | 100 || 2 | 200 || 3 | 300 |±—±-------+For example, given the above Employee table, the nth highest salary wh

Description：Table: Person±------------±--------+| Column Name | Type |±------------±--------+| PersonId | int || FirstName | varchar || LastName | varchar |±------------±--------+PersonId is the primary key column for this table.Ta