is a very powerful feature of MyBatis. It enables programmers to build queries based on write the query using the dynamic
statement. Following are the OGNL based Dynamic
expressions provided by MyBatis otherwise
• trim where, set
• foreach
## The if Statement
The most common thing to do in dynamic
is conditionally include a part of a where clause. For example –
0 码力 |
5 页 |
69.51 KB
| 2 年前 3
## C++20 ♥ SQL
John R Bandela, MD
## Overview
SQL
C++ Example
Implementation techniques
fixed_string
meta_struct
Parsing compile time strings into meta_structures

## Overview
SQL
C++ Example
Implementation Techniques
https://github.com/google/cpp-from-the-sky-down/tree/master/meta_struct_20/cppcon_version
## SQL
Probably the highest level mainstream HOPE YOU'RE HAPPY.
AND I HOPE YOU'VE LEARNED TO SANITIZE YOUR DATABASE INPUTS.
## Avoiding SQL Injection Attacks
SELECT orders.id, name, item, price, discount_code FROM orders JOIN customers ON
0 码力 |
46 页 |
775.02 KB
| 1 年前 3
从零开始用 Go 实现 Lexer & Parser
何源 yuan@liulishuo.com
流利说
流利说
Help everyone become a global citizen!
aithub/lingochamp
流利说
Empower everyone to achieve their full potential
何源
yuan@liulishuo.com
Platform WORK ELSEWHERE, DELETE THE PROJECT, AND DOWNLOAD A FRESH COPY.
撸起袖子!
—
撸起袖子加油干!
三步走
写一个 Parser : course file -> pb file
• 写一个 Lexer
• 串起来
1. 定义格式
===== Group 1526034270606411
[TYPE Pre] start of this item.
}
type itemType int
const
itemNil
itemType = iota
// used in the parser to indicate no type
itemError
// error occurred; value is text of error
itemEOF
itemBool
0 码力 |
81 页 |
4.72 MB
| 1 月前 3
pitfalls in Firebird SQL
Paul Vinkenoog
Version 1.2, 30 June 2020
## Table of Contents
1. What is NULL? ..... 4
1.1. NULL as a default state ..... 4
2. NULL support in Firebird SQL ..... 6
2.1. Disallowing operations will render the entire expression NULL.
This guide explores the behaviour of NULL in Firebird SQL , points out common pitfalls and shows you how to deal safely with expressions that contain NULL or reference to refresh your memory, go to the summary at the end of the guide.
## So — what is it?
In SQL , NULL is not a value. It is a state indicating that an item's value is unknown or nonexistent.
0 码力 |
69 页 |
479.63 KB
| 2 年前 3
## TiDB: HBase分布式事务与SQL 实现
## About me
• TiDB & Codis founder
• Golang expert
• Distributed database developer
• Currently, CEO and co-founder of PingCAP
liuqi@pingcap.com
https://github.com/pingcap/tidb What did they say?
“Nothing is hotter than SQL -on-Hadoop, and now SQL -on-HBase is fast approaching equal hotness status”
Form HBaseCon 2015
We want more!
SQL + Transaction(ACID)
## TiDB Features
## • MySQL-client
MySQL-client
Load Balancer
MySQL Protocol Server
MySQL Protocol Server
TiDB SQL Layer
TiDB SQL Layer
Transactional KV Storage
KV
KV
KV
KV
### AH. HBase
• First things first
☐ Need
0 码力 |
34 页 |
526.15 KB
| 2 年前 3
## RUST CHINA CONF 2023
第三届中国Rust开发者大会
6.17-6.18 @Shanghai
## 用 egg 孵化你的 SQL 优化器
王润基
RisingWave 内核开发工程师
## RisingLight
## An Educational OLAP Database System
## RisingLight 查询引擎的整体结构

## 一 个 SQL 语句优化的例子
SQL
Physical Plan

## 查询优化
## 185d2/p39_1.jpg)
https://github.com/risinglightdb/risinglight
https://github.com/risinglightdb/sql -optimizer-labs

0 码力 |
39 页 |
6.48 MB
| 2 年前 3
PDF Options
Languages
Web server settings
Theme settings
Design customization
Text fields
SQL query box settings
Web server upload/save/import directories
Various display setting
Page titles server, databases and tables, with proposals on server configuration
• execute, edit and bookmark any SQL -statement, even batch-queries
• load text files into tables
• create [[1]] and read dumps of tables formats
- import data and MySQL structures from OpenDocument spreadsheets, as well as XML, CSV, and SQL files
• administer multiple servers
• add, edit, and remove MySQL user accounts and privileges
•
0 码力 |
235 页 |
370.31 KB
| 2 年前 3
## 阿里云 AnalyticDB for PostgreSQL
- 打造更简单易用的Cloud SQL Data Warehouse
## 个人介绍

## 缪长风
● 2010年初加入支付宝,负责Oracle RAC和Greenplum数据仓库 [Image](/uploads/documents/c/8/d/a/c8da7490ed438c168c9dd30fc6b7f850/p7_2.jpg)
## 应用易开发、适配
支持SQL 2003,部分兼容Oracle语法,支持PL/SQL 存储过程,OLAP窗口函数,事务及数据库标准隔离级别完备功能和生态,实现应用快速迁移或适配

## PB级数据秒级响应
MPP水平扩展架构,PB级数据查询秒级响应;向量化计算,及列存储智能索引,领先传统数据库引擎性能 3x;新一代SQL 优化器,实现复杂分析语句免调优

##
0 码力 |
22 页 |
2.98 MB
| 2 年前 3
языку SQL CYБД Firebird 3.0
Firebird 3.0.4
8 августа 2018 — v.0051-1

Gold Sponsor
##### Руководство по языку SQL СУБД
1. Структура языка ..... 22
Общие сведения ..... 22
Подмножества SQL ..... 22
Диалекты SQL ..... 22
Действия при ошибках ..... 23
Основные сведения: операторы, предложения Особенности BLOB ..... 45
Массивы ..... 46
Специальные типы данных ..... 47
Тип данных SQL _NULL ..... 47
Преобразование типов данных ..... 49
Явное преобразование типов данных ..... 49
0 码力 |
719 页 |
3.98 MB
| 2 年前 3