All,
Unfortunatelu this didn't do the trick.
I changed (with PHPMYADMIN) all fields from LONGTEXT to TEXT, all other
parameters furthermore unchanged.
Ran the same procedure again, but stopped updating the row at exact the
same spot. How come? No idea.
What I'm trying to achi
dnesday, April 1, 2015, Trianon 33 wrote:
Hello,
I'm fiddling wit a table where I put in a date field (datetime, also
key)
and some integer fields (8 of them mostly 14 long) and some longtext
fields
(16 of them).
The longtext fields are filled with some statistics I generate complete
with HTML
he HTML
code somewhere else, perhaps in a different table.
On Wednesday, April 1, 2015, Trianon 33 wrote:
Hello,
I'm fiddling wit a table where I put in a date field (datetime, also key)
and some integer fields (8 of them mostly 14 long) and some longtext fields
(16 of them).
The longtext
mostly 14 long) and
some longtext fields (16 of them).
The longtext fields are filled with some statistics I generate
complete with HTML around, something like this:
12.925.965 but than bigger, but mostly smaller than 1 Mb.
This row is initially created by filling the first 10 fields
datetime, also key)
> and some integer fields (8 of them mostly 14 long) and some longtext fields
> (16 of them).
>
> The longtext fields are filled with some statistics I generate complete
> with HTML around, something like this: 12.925.965 but than bigger,
> but mostly sm
Hello,
I'm fiddling wit a table where I put in a date field (datetime, also
key) and some integer fields (8 of them mostly 14 long) and some
longtext fields (16 of them).
The longtext fields are filled with some statistics I generate complete
with HTML around, something like
AM
To: mysql@lists.mysql.com
Subject: Re: [mysql] Text = Tinytext = MediumText = LongText?
Sebastian Mendel schrieb:
> Weston, Craig (OFT) schrieb:
>> Hello everyone, hopefully a quick question: is there a functional
>> difference between the various text field sizes other
Sebastian Mendel schrieb:
> Weston, Craig (OFT) schrieb:
>> Hello everyone, hopefully a quick question: is there a functional
>> difference between the various text field sizes other than size? For
>> example if I wanted to could I run a FULLTEXT index against a LongText
&
Weston, Craig (OFT) schrieb:
> Hello everyone, hopefully a quick question: is there a functional
> difference between the various text field sizes other than size? For
> example if I wanted to could I run a FULLTEXT index against a LongText
> field?
no
--
Sebastian
--
MySQL Gen
Hello everyone, hopefully a quick question: is there a functional
difference between the various text field sizes other than size? For
example if I wanted to could I run a FULLTEXT index against a LongText
field?
The collary is of course how good of an idea is this, assuming that MOST
of the
I've looked at concat and other string functions as well as searched
on 'update' and 'longtext', but the results haven't been useful. Am I
missing something easy, or will this be more involved than a simple
one-line SQL statement?
You obviously didn't
Whil Hentzen wrote:
Hi folks,
I'm converting a database to MySQL, and rewriting the code to work with
MySQL from the old datastore.
One of the fields in one of the tables is a longtext type that contains
a history of system accesses - each time the system is touched in one
form or an
Hi folks,
I'm converting a database to MySQL, and rewriting the code to work with
MySQL from the old datastore.
One of the fields in one of the tables is a longtext type that contains
a history of system accesses - each time the system is touched in one
form or another, a few more lin
In article <[EMAIL PROTECTED]>,
symbulos <[EMAIL PROTECTED]> writes:
> On Monday 09 May 2005 15:17, Roger Baklund wrote:
>> You could use the LEFT() function to return for instance the 200 first
>> characters:
>>
>> SELECT LEFT(article,200) AS start_of_article
>> FROM articletable WHERE ...
>>
>
Thanks for the very useful suggestions!
I was thinking of adding a simple check to search for the first "full stop"
after the count of words.
It sounded sensible in the case where people want to have a full sententences,
not interrupted in the middle.
--
MySQL General Mailing List
For list ar
Christian Meisinger wrote:
You could use the LEFT() function to return for instance the 200 first
characters:
SELECT LEFT(article,200) AS start_of_article
FROM articletable WHERE ...
You could also use the SUBSTRING_INDEX() function, if your lines are
separated with \r\n:
SELECT SUBSTRING_INDEX(ar
>>You could use the LEFT() function to return for instance the 200 first
>>characters:
>>
>>SELECT LEFT(article,200) AS start_of_article
>> FROM articletable WHERE ...
>>
>>You could also use the SUBSTRING_INDEX() function, if your lines are
>>separated with \r\n:
>>
>>SELECT SUBSTRING_INDEX(arti
On Monday 09 May 2005 15:17, Roger Baklund wrote:
> You could use the LEFT() function to return for instance the 200 first
> characters:
>
> SELECT LEFT(article,200) AS start_of_article
>FROM articletable WHERE ...
>
> You could also use the SUBSTRING_INDEX() function, if your lines are
> separ
symbulos wrote:
how do you extract with a query only the first few lines from a blob field?
For instance: you have an article stored in the field. You would like to
visualise the first few lines before reading it all.
You could use the LEFT() function to return for instance the 200 first
characte
Dear friends,
how do you extract with a query only the first few lines from a blob field?
For instance: you have an article stored in the field. You would like to
visualise the first few lines before reading it all.
Thanks in advance.
--
symbulos - ethical services for your organisation
websit
On Wed, April 20, 2005 3:20 pm, [EMAIL PROTECTED] said:
> I have a table with a field that has a field of type LONGTEXT. I try to
> insert a utf8 string with a length of 114544 and I get a warning that
> text got truncated. According to the doc, the size of LONGTEXT is much
> bigger th
Hello.
There's a similar bug:
http://bugs.mysql.com/bug.php?id=7654
But it was closed due to absence of feedback. You may reopen this bug.
Check this field has the correct encoding.
[EMAIL PROTECTED] wrote:
> I have a table with a field that has a field of type LONGTEX
I have a table with a field that has a field of type LONGTEXT. I try to
insert a utf8 string with a length of 114544 and I get a warning that
text got truncated. According to the doc, the size of LONGTEXT is much
bigger than this. Any reason I get this warning?
-Jalil
--
MySQL General Mailing
"Ronan Lucio" <[EMAIL PROTECTED]> wrote:
>
> Is it possible to make a search for a word in a longtext column
> from a InnoDB database?
>
Yes. Look at:
http://dev.mysql.com/doc/mysql/en/Pattern_matching.html
--
For technical support contracts, goto https:/
Hi,
Is it possible to make a search for a word in a longtext column
from a InnoDB database?
Thanks,
Ronan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
* Is the procedure to store file paths, or the actual text itself?
In order to use MySQL full-text indexing funcionality, you will need to store
the actual text, and you need to have a FULLTEXT index on the column. Note that
full-text indexing is supported only with MyISAM tables.
*
I see the data types
TEXT
MEDIUMTEXT
LONGTEXT
listed in the MySQL documentation, and I have read Section 13.7 MySQL
Full-Text Search.
I infer from this that it is possible to store searchable text files in
tables.
My questions are these:
* Is the procedure to store file
The double quotes have meaning in HTML. You might be confusing the parser. Try
replacing your double quotes with ".
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Is there something about longtext fields I'm missing?
When I return my longtext field (the Content column of a table containing
articles - it contains HTML) and place it in a TextArea on the HTML form it
always has the first so many characters missing. If I continually edit the
article repea
I seem to be having some problems regarding HTML in Longtext fields - I
think it is something to do with the fact that I have items in double quotes
in the field.
As an example, the html will have double quates along the lines of:
When I pull the field out of the database via the Application
owed_packet to 20M as well as my
> net_buffer_length to 8M in my my.cnf file.
>
> Seems like no matter what I set these two values to, nothing helps. My
> Column is set to LONGTEXT, but I cannot seem to find anywhere that would
> set the size of the Longtext, and, according to
in my my.cnf file.
Seems like no matter what I set these two values to, nothing helps. My
Column is set to LONGTEXT, but I cannot seem to find anywhere that would
set the size of the Longtext, and, according to the MySQL documentation
-- it seems as if the size of this column is dependant upon you
At 14:44 -0500 6/12/03, Wong Zach-CHZ013 wrote:
Hi
I have a database whose table has a column, which has a datatype longtext.
I then try a query
mysql> select MY_DATE from my_table where MLC_DATE between '09/22/2003' AND
'10/21/2
003';
I thought it would fail since the
Hi
I have a database whose table has a column, which has a datatype longtext.
I then try a query
mysql> select MY_DATE from my_table where MLC_DATE between '09/22/2003' AND
'10/21/2
003';
I thought it would fail since the datatype isnt DATE nor TIMESTAMP.
But from the r
At 1:50 + 3/20/03, Mr Orange wrote:
GV wrote:
I think is better to have an additional record each time a user
inserts
new information
Mr Orange wrote:
Hello all,
I have a database with a type "longtext" called "notes".
Say I wanted to append some text to this field
GV wrote:
> I think is better to have an additional record each time a user
> inserts
> new information
>
> Mr Orange wrote:
>> Hello all,
>>
>> I have a database with a type "longtext" called "notes".
>>
>> Say I wanted to append s
I think is better to have an additional record each time a user inserts
new information
Mr Orange wrote:
Hello all,
I have a database with a type "longtext" called "notes".
Say I wanted to append some text to this field, what command would I use?
I have tried the foll
Hello all,
I have a database with a type "longtext" called "notes".
Say I wanted to append some text to this field, what command would I use?
I have tried the following sql..
update clients set notes=notes+"text to append" where id=1;
But this doesn't see
At 12:29 -0600 3/4/03, jason wesley upton wrote:
I know that for most purposes you can treat TEXT and BLOB as VARCHAR
under a longer name, but is the same true of LONGTEXT? I have a
field
that needs to be open to a huge amount of text, but I don't want my
database's size to be hu
I know that for most purposes you can treat TEXT and BLOB as VARCHAR under a longer
name, but is the same true of LONGTEXT? I have a field
that needs to be open to a huge amount of text, but I don't want my database's size to
be huge if that maximum allowed amount of text is not use
* Roger Baklund
[...]
> UPDATE a SET new_date =
>
(
> MID(my_date,7,4),'-',
> MID(my_date,1,2),'-',
> MID(my_date,4,2));
huh? How did this happen...? I just checked my outbox, and the message I wrote
yesterday[1] contained "new_date = CONCAT(". It seems as the substring "CON" has been
rep
* Wong Zach-CHZ013
[...]
> In table a, the columns are
> my_date - longtext
> num - int(11)
[...]
> Q:
> How do I convert 08/06/2002 to 2002-08-06 format
LONGTEXT is not a good column type for dates, you should use the special
'date' type, see http://www.mysql.com/doc/en
base Z, namely
table
a
b
c
In table a, the columns are
my_date - longtext
num - int(11)
eg:
mysql> select * from a;
+--+--+--+
| my_date | x|
+--+--+
| 08/06/2002 |1 |
| 08/07/2002 |2 |
+--+--+--+
2 rows in set (0.00 se
Hi
I have a few tables in a database Z, namely
table
a
b
c
In table a, the columns are
my_date - longtext
num - int(11)
eg:
mysql> select * from a;
+--+--+--+
| my_date | x|
+--+--+
| 08/06/2002 |1 |
| 08/07/2002 |
* Victoria Reznichenko
> RB> 3) How can the server know that the max_allowed_packet for
> RB> _this_ connection
> RB> (the UPDATE'ing connection) isn't smaller than the
> RB> max_allowed_packet value
> RB> for a future SELECT connection? (I could do the UPDATE ...
> RB> CONCAT(... with
> RB> max_a
Roger,
Tuesday, August 20, 2002, 5:34:25 PM, you wrote:
RB> Maybe... :)
RB> On the other hand:
RB> 1) The documentation on max_allowed_packet talks only about transferring
RB> data, not storing. (This should be easy to fix.)
Agreed..
RB> 2) The mere existence of LONGBL
7;t the entire UPDATE happen on the server side?
> >
>
> It probably does happen on the server side. But wouldn't it be
> smart to limit itself to something it knows it can't transfer later?
Maybe... :)
On the other hand:
1) The documentation on max_allowed_packet talks on
> -Original Message-
> From: Roger Baklund [mailto:[EMAIL PROTECTED]]
> * Harald Fuchs
> > In article <[EMAIL PROTECTED]>,
> > Victoria Reznichenko <[EMAIL PROTECTED]> writes:
> >
> > > As you can see txt1 and txt2 contain text file ~ 8M
> >
> > > UPDATE tbl1 SET total=CONCAT(txt1,txt2)
* Harald Fuchs
> In article <[EMAIL PROTECTED]>,
> Victoria Reznichenko <[EMAIL PROTECTED]> writes:
>
> > As you can see txt1 and txt2 contain text file ~ 8M
>
> > UPDATE tbl1 SET total=CONCAT(txt1,txt2) WHERE id=1;
>
> > SELECT id, LENGTH(txt1), LENGTH(txt2), LENGTH(total) FROM tbl1;
> > ++-
; The manual states clearly that _the file_ must be smaller than
HF> max_allowed_packet (which it is), *not* the total text length.
Harald, LOAD_FILE() doesn't play any role in this query. You got NULL
not because of LOAD_FILE().
Look:
CREATE TABLE `tbl1` (
`id` tinyint(3) unsigned
CREMENT,
HF> txt LONGTEXT NOT NULL,
HF> PRIMARY KEY (id)
HF> ) TYPE=Innodb;
HF> INSERT INTO tbl1 (txt) VALUES (LOAD_FILE("/var/tmp/out"));
[skip]
HF> If I do
HF> UPDATE tbl1
HF> SET txt = CONCAT(txt, LOAD_FILE("/var/tmp/out"))
HF>
My MySQL server 3.23.51 died in an hour after
I created a table containing "longtext" field.
I am not sure that this was the reason but
suspect so since it was running for few weeks
w/out problems.
It stopped accepting answering TCP & UNIX socket
connections, although was still li
On Wed, 25 Jul 2001, Paul DuBois wrote:
> I doubt if "they" are trying to irritate you. The maximum size of a MySQL
> database depends on your file system constraints, not on the size of
> a LONGTEXT.
> Some OSes have a max file size of 2GB, for example; others don
At 10:11 PM -0500 7/25/01, Mike wrote:
>I have throughly looked at the documentation and I am beginning to
>get frustrated. It says that a LONGTEXT field's max length is L+4
>bytes, where L < 2^32. I understand the extra 4 bytes(+4) which is
>to keep track of the size sense
I have throughly looked at the documentation and I am beginning to get frustrated. It
says that a LONGTEXT field's max length is L+4 bytes, where L < 2^32. I understand the
extra 4 bytes(+4) which is to keep track of the size sense LONGTEXT is no more than a
really big VARCHAR fiel
Hi,
> my question is: is it possible to load in a Longtext column
> a .txt file? furthermore, is it possible to do that with a .xml file?
of course..
at first you must use seperator, field-encloser and line-terminator, which
is not contained in your data. for example this way:
SELECT
Hello,
I'm a MySQL newbye...
my question is: is it possible to load in a Longtext column
a .txt file? furthermore, is it possible to do that with a .xml file?
Thanks in advance,
Maurizio Megliola
TXT e-solutions S.p.a
At 3:35 AM +0300 5/23/01, Olexandr Vynnychenko wrote:
>Hello Paul,
>
>Wednesday, May 23, 2001, 3:24:29 AM, you wrote:
>
>PD> At 3:22 AM +0300 5/23/01, Olexandr Vynnychenko wrote:
>>>Hello mysql,
>>>
>>>Can anybody tell me what should I do? I use LONGT
Hello Paul,
Wednesday, May 23, 2001, 3:24:29 AM, you wrote:
PD> At 3:22 AM +0300 5/23/01, Olexandr Vynnychenko wrote:
>>Hello mysql,
>>
>>Can anybody tell me what should I do? I use LONGTEXT column in my
>>table to store data files (html, for example). But I see th
At 3:22 AM +0300 5/23/01, Olexandr Vynnychenko wrote:
>Hello mysql,
>
>Can anybody tell me what should I do? I use LONGTEXT column in my
>table to store data files (html, for example). But I see that I cannot simply
>INSERT INTO table SET longtext_column=whole_file. But I must d
Hello mysql,
Can anybody tell me what should I do? I use LONGTEXT column in my
table to store data files (html, for example). But I see that I cannot simply
INSERT INTO table SET longtext_column=whole_file. But I must do it today. But
how???
Thanks beforehand.
--
Best regards,
Olexandr
On Thu, Apr 26, 2001 at 09:54:56AM +0200, [EMAIL PROTECTED] wrote:
> we're just facing a "challenging" problem ... we have a MySQL lessons
> learned database. In two fields of the main table (LONGTEXT) we have the
> "description" and the "solution&qu
Good Morning People,
we're just facing a "challenging" problem ... we have a MySQL lessons
learned database. In two fields of the main table (LONGTEXT) we have the
"description" and the "solution". You could think of two short abstracts,
regarding the lesson
The duplicate entry error can probably be fixed by running myisamchk on the
table.
Hope this helps.
ryan
> I have some problem in load a 28 MB LONGTEXT data into mysql database
using
> "LOAD DATA INFILE ...". At the beginning, server returns me the error
> message as below:
&
Hi everyone;
I have some problem in load a 28 MB LONGTEXT data into mysql database using
"LOAD DATA INFILE ...". At the beginning, server returns me the error
message as below:
ERROR 1030: Got error 139 from table handler
I tried the same command again, then I got another error mess
65 matches
Mail list logo
