---
title: "插入含单引号的字符串的INSERT语句"
author: "winzenghua"
date: "2007-08-23T11:35:00Z"
tags: []
slug: "insert"
draft: false
lastmod: "2007-08-23T11:35:00Z"
id: 952950
url: "https://java4gis.iteye.com/blog/952950"
---

比方字符串 abc'de 怎样插入数据表?

用一对单引号替代一个单引号即可：  
insert into tableA(field) values('abc''de')