The SQL...
UPDATE Threads t
SET t.Content = (
SELECT GROUP_CONCAT(a.Content ORDER BY a.PageID SEPARATOR '<!-- pagebreak -->')
FROM MSarticlepages a
WHERE a.ArticleID = t.MSthreadID GROUP BY a.ArticleID
)
As you can see it takes all of an article's pages (which are each
stored as longtext in separate rows) and GROUP_CONCA...
Hi,
I have the following JPA SqlResultSetMapping:
@SqlResultSetMappings({
@SqlResultSetMapping(name="GroupParticipantDTO",
columns={
@ColumnResult(name="gpId"),
@ColumnResult(name="gpRole"),
// @ColumnResult(name="gpRemarks")
}
)
Which is used like this:
StringBuilder sbQuer...
what is the best way to store long texts (articles) in a database? it doesnt need to be searchable.
i want to allow ppl to read the first chapter of every book in my bookstore. dumping it into a database field makes it difficult to style paragraphs using css..
EDIT: access database
...
I'm taking the contents of a 1.2mb webpage into a longtext field, server has gone away though everytime!
...
As the title says, I'm after a good field type for a comments field I have in a table. It will store many characters (as users can continuously add to it) so it's definitely over 255. I looked at longtext but wasn't sure...Also how do I change the field type to accept different characters such as apostrophies. Thanks.
...
I'm trying to store a String which contains HTML in a MySQL database using Longtext data type. But it always says "You have an error in your SQL syntax". I tried to store a normal String and it works.
Update:
This is the query:
st.executeUpdate("insert into website(URL,phishing,source_code,active) values('" + URL + "','" + phishingSt...
I use MySql Server 5.1. I have a MySql table with a longtext column. I'm writing a program in C# 2010 using MySql Connector 6.3.1 and I want to select that column in my program using regular linq.
I have inserted some text using MySql Workbench. As long as the text is <32kb, I can select it in my program. As soon as this text is > 32kb,...