mysql和postgresql转义字符探究
2024-10-19 01:23:09
总结
mysql依靠反斜杠\转义, postgresql 依靠单引号转义
mysql 客户端
mysql> create table usr (name varchar(), age integer);
Query OK, rows affected (0.05 sec) mysql> insert into usr values ('kate', );
Query OK, row affected (0.01 sec) mysql> insert into usr values ('kate\'', );
Query OK, row affected (0.01 sec) mysql> select * from usr;
+-------+------+
| name | age |
+-------+------+
| kate | |
| kate' | 28 |
+-------+------+
rows in set (0.00 sec) mysql> insert into usr values ('kate\\', );
Query OK, row affected (0.01 sec) mysql> select * from usr;
+-------+------+
| name | age |
+-------+------+
| kate | |
| kate' | 28 |
| kate\ | |
+-------+------+
rows in set (0.00 sec) mysql> insert into usr values ('kate"', );
Query OK, row affected (0.01 sec) mysql> select * from usr;
+-------+------+
| name | age |
+-------+------+
| kate | |
| kate' | 28 |
| kate\ | |
| kate" | 28 |
+-------+------+
rows in set (0.00 sec)
postgresql客户端
test=# create table usr (name varchar(), age integer);
CREATE TABLE
test=# insert into usr values ('kate', );
INSERT
test=# insert into usr values ('kate''', ), ('kate\', 28), ('kate"', 28);
INSERT
test=# select * from usr;
name | age
-------+-----
kate |
kate' | 28
kate\ |
kate" | 28
最新文章
- .NET 4.5.1 预览版新特性
- iOS适配 旧项目工程在iOS9下不能正常显示
- Android开发自学笔记(Android Studio) 目录
- poco json 中文字符，抛异常JSON Exception -->iconv 转换 备忘录。
- 【leetcode】First Missing Positive
- setTimeout方法
- InputStreamReader/OutputStreamWriter乱码问题解决
- 使用 Windows 窗体 TextBox 控件创建密码文本框
- ListBox重绘
- Ubuntu 10.04启动进入命令行模式
- 【转载】linux环境下为firefox/chrome浏览器安装flash player
- mysql存储过程且mybatis调用
- grid-layout
- g++编译的makefile模板库和脚本
- 监控命令之tsar
- Java设置PPT的扇形图，与内嵌Excel联动
- flex的使用以及布局
- 内存操作函数memmove，memcpy，memset
- SIFT算法的教程及源码
- web.xml中配置spring.xml的三种方式