blocks|key|245903|text|列"BIO“的数据类型是什么？什么数据库服务器(sql/oracle/mysql)？只要遵守列数据类型中的字符限制(即varchar(200)+)，就应该能够跨越多行。尝试使用单引号，这可能会有所不同。这对我来说很有效：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|245904|update+table+set+mycolumn+=+'hello+world,
my+name+is+carlos.
goodbye.'
where+id+=+1;|code-block|syntax|javascript|245905|此外，如果要在C#中将sql字符串连接在一起，则可能需要检查是否有单引号。如果变量包含可以从sql语句中转义代码的单引号，则不会执行预期中的所有行。|245906|顺便说一句，您可以像在C#中那样用分号分隔SQL语句，就像供参考一样。|245907|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|P|8|@]|9|@]|A|$]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

What's the column "BIO" datatype? What database server (sql/oracle/mysql)? 
You should be able to span over multiple lines all you want as long as you adhere to the character limit in the column's datatype (ie: varchar(200) ).
Try using single quotes, that might make a difference. 
This works for me:

<pre><code>update table set mycolumn = 'hello world,
my name is carlos.
goodbye.'
where id = 1;
</code></pre>

Also, you might want to put in checks for single quotes if you are concatinating the sql string together in C#. If the variable contains single quotes that could escape the code out of the sql statement, therefore, not doing all the lines you were expecting to see.

BTW, you can delimit your SQL statements with a semi colon like you do in C#, just as FYI.

blocks|key|3139394|text|SQL+Server允许执行以下操作(请注意使用单引号而不是双引号)|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3139395|UPDATE+User
SET+UserId+=+12345
+++,+Name+=+'J+Doe'
+++,+Location+=+'USA'
+++,+Bio='my+bio
spans+
multiple
lines!'
WHERE+UserId+=+12345|code-block|syntax|javascript|3139396|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

SQL Server allows the following (be careful to use single quotes instead of double)

<pre><code>UPDATE User
SET UserId = 12345
 , Name = 'J Doe'
 , Location = 'USA'
 , Bio='my bio
spans 
multiple
lines!'
WHERE UserId = 12345
</code></pre>

blocks|key|247876|text|使用VARCHAR时，您可能还需要指定长度，或者最好这样做|type|unstyled|depth|inlineStyleRanges|entityRanges|data|247877|抓取文本，创建一个字符串，然后将其放入查询中怎么样？|247878|String+TableName+=+"ComplicatedTableNameHere";++
EditText+editText1+=+(EditText)+findViewById(R.id.EditTextIDhere);+
String+editTextString1+=+editText1.getText().toString();++|code-block|syntax|javascript|247879|分解了|offset|length|style|BOLD|247880|String+TableName+=+"ComplicatedTableNameHere";++++++++++++
++++//sets+the+table+name+as+a+string+so+you+can+refer+to+TableName+instead+of+writing+out+your+table+name+everytime

EditText+editText1+=+(EditText)+findViewById(R.id.EditTextIDhere);+
++++//gets+the+text+from+your+edit+text+fieldfield+
++++//editText1+=+your+edit+text+name
++++//EditTextIDhere+=+the+id+of+your+text+field

String+editTextString1+=+editText1.getText().toString();++
++++//sets+the+edit+text+as+a+string
++++//editText1+is+the+name+of+the+Edit+text+from+the+(EditText)+we+defined+above
++++//editTextString1+=+the+string+name+you+will+refer+to+in+future|247881|然后使用进行|247882|+++++++/*+Insert+data+to+a+Table*/
+++++++myDB.execSQL("INSERT+INTO+"
+++++++++%2B+TableName
+++++++++%2B+"+(Column_Name,+Column_Name2,+Column_Name3,+Column_Name4)"
+++++++++%2B+"+VALUES+(+"%2BEditTextString1%2B",+'Column_Value2','Column_Value3','Column_Value4');");|247883|希望这能帮到什么.|247884|注释每个字符串都在|247885|'"%2Bstringname%2B"'|247886|是启用srting的多行元素的‘’，如果没有它，你只会得到第一行，甚至不确定是否会得到整行，它可能只是第一个单词|247887|entityMap^0|0|0|0|0|3|0|0|0|0|0|9|0|0|9|0|0|0|1K|0^^$0|@$1|2|3|4|5|6|7|14|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|15|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|16|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|17|8|@$K|18|L|19|M|N]]|9|@]|A|$]]|$1|O|3|P|5|F|7|1A|8|@]|9|@]|A|$G|H]]|$1|Q|3|R|5|6|7|1B|8|@]|9|@]|A|$]]|$1|S|3|T|5|F|7|1C|8|@]|9|@]|A|$G|H]]|$1|U|3|V|5|6|7|1D|8|@$K|1E|L|1F|M|N]]|9|@]|A|$]]|$1|W|3|X|5|6|7|1G|8|@$K|1H|L|1I|M|N]]|9|@]|A|$]]|$1|Y|3|Z|5|F|7|1J|8|@]|9|@]|A|$G|H]]|$1|10|3|11|5|6|7|1K|8|@$K|1L|L|1M|M|N]]|9|@]|A|$]]|$1|12|3|-4|5|6|7|1N|8|@]|9|@]|A|$]]]|13|$]]

with your VARCHAR, you may also need to specify the length, or its usually good to

What about grabbing the text, making a sting of it, then putting it into the query witrh

<pre><code>String TableName = "ComplicatedTableNameHere"; 
EditText editText1 = (EditText) findViewById(R.id.EditTextIDhere); 
String editTextString1 = editText1.getText().toString(); 
</code></pre>

BROKEN DOWN

<pre><code>String TableName = "ComplicatedTableNameHere"; 
 //sets the table name as a string so you can refer to TableName instead of writing out your table name everytime

EditText editText1 = (EditText) findViewById(R.id.EditTextIDhere); 
 //gets the text from your edit text fieldfield 
 //editText1 = your edit text name
 //EditTextIDhere = the id of your text field

String editTextString1 = editText1.getText().toString(); 
 //sets the edit text as a string
 //editText1 is the name of the Edit text from the (EditText) we defined above
 //editTextString1 = the string name you will refer to in future
</code></pre>

then use

<pre><code> /* Insert data to a Table*/
 myDB.execSQL("INSERT INTO "
 + TableName
 + " (Column_Name, Column_Name2, Column_Name3, Column_Name4)"
 + " VALUES ( "+EditTextString1+", 'Column_Value2','Column_Value3','Column_Value4');");
</code></pre>

Hope this helps some what...

NOTE each string is within 

<pre><code>'"+stringname+"'
</code></pre>

its the 'and' that enable the multi line element of the srting, without it you just get the first line, not even sure if you get the whole line, it may just be the first word

blocks|key|247892|text|我更喜欢使用@符号，这样我就可以准确地看到我可以复制并粘贴到查询文件中的查询：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|247893|string+name+=+"Joe";
string+gender+=+"M";
string+query+=+String.Format(@"
SELECT
+++*
FROM
+++tableA
WHERE
+++Name+=+'{0}'+AND
+++Gender+=+'{1}'",+name,+gender);|code-block|syntax|javascript|247894|对于长而复杂的查询，它真的很棒。好消息是它保留了制表符和换行符，因此粘贴到查询浏览器中会保留良好的格式|247895|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

I prefer to use the @ symbol so I see the query exactly as I can copy and paste into a query file:

<pre><code>string name = "Joe";
string gender = "M";
string query = String.Format(@"
SELECT
 *
FROM
 tableA
WHERE
 Name = '{0}' AND
 Gender = '{1}'", name, gender);
</code></pre>

It's really great with long complex queries. Nice thing is it keeps tabs and line feeds so pasting into a query browser retains the nice formatting

UPDATE: the bio may contain apostrophes (see updated example)

I have an SQL query that has a value which spans multiple lines and it causes the query to fail:

<pre><code>UPDATE User SET UserId=12345, Name="J Doe", Location="USA", Bio="I'm a
bio that has an apostrophe, and I'm 
spanning multiple lines!" 
WHERE UserId=12345
</code></pre>

In C# you can put an <code>@</code> before the string <code>Bio=@"..."</code> in order to allow it to span multiple lines, but I'm not sure how the same thing can be achieved with SQL queries. How do you get a string to span multiple lines without having to do things like manually concatenating the strings: 

<pre><code>Bio="I'm a"
+" bio that has an apostrophe, and I'm"
+" spanning multiple lines!" 
</code></pre>

SQL string value spanning multiple lines in query

SQL Server

数据库

服务器

更新：bio可能包含撇号(参见更新的示例)我有一个SQL查询，它有一个跨多行的值，它会导致查询失败：UPDATE User SET UserId=12345, Name="J Doe", Location="USA", Bio="I'm abio that has an apostrophe, and I'm span...

问查询中跨多行的SQL字符串值
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问查询中跨多行的SQL字符串值EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问查询中跨多行的SQL字符串值
EN