On Thu, 17 Jan 2002, Ryan Fox wrote:
> The current action is that this value is truncated to fit the column. The
> other option would be to automagically expand the column's length so the
> value would fit. Despite what the original poster may think, they _really_
> don't want that to happen.
R
On Thu, 17 Jan 2002, Henning Sprang wrote:
> ok, so it isn't depending on "fixed length" as you first said, and the
> reason for it is just the simple design of sql, right?
Right. (Sorry for the previous inacuracy, I was using 'fixed' in a wide
sense viz. including 'bounded'.)
Cheers,
--
,
On Thu, 17 Jan 2002, Henning Sprang wrote:
> > So your field is of fixed length type (you hadn't told us that yet).
> Aehm, no, it isn't! It's VARCHAR.
Doesn't matter: "If you assign a value to a CHAR or VARCHAR column that
exceeds the column's maximum length, the value is truncated to fit."
(MyS
On Thu, 17 Jan 2002, Henning Sprang wrote:
> >>... I just realized that Mysql simply "cuts" Data i want to insert
> >>into a field when it is too long, without giving any warning or error
> >>message. . .
> > If the field has fixed length that is standard behaviour (together with
> > right-paddin
On Thu, 17 Jan 2002, Henning Sprang wrote:
> ... I just realized that Mysql simply "cuts" Data i want to insert
> into a field when it is too long, without giving any warning or error
> message. . .
If the field has fixed length that is standard behaviour (together with
right-padding too short v
> > > . . .
> > Isn't function MATCH what you want?
> > . . .
> The problem is that I don't know the expression for the 'AGAINST' part.
> Given a document I'd like to know what it is about without reading it.
> . . .
So you want a list of _descriptors_ for each document. That is
_precoordination_
On Mon, 7 Jan 2002, Arne Mueller wrote:
> I wonder whether one can use the full text indexes in mysql to find out
> what words in a document are likely to be relevant key words.
>
> . . .
>
> I'd be nice to have a command like this:
>
> select keywords(10.0) from MyDocs where DocId = 666;
>
> . .
On Thu, 20 Dec 2001, Raymond Wan wrote:
> . . . I know there's a C API for MySQL, but I was just wondering if
> MySQL has a preprocessor that supports statements such as "EXEC SQL ..."
> in a host language such as C . . .
The thing (purportedely) exists for Ada (adapower.com).
However Ada is not
On Fri, 14 Dec 2001, Ian Collins wrote:
>
> I am having difficulties with entering binary data from a c program.
> I have passed the string through mysql_real_escape_string.
Post the C data then. However read on.
>
> . . .
>
> drop table if exists junk5;
>
> create table junk5
> (
> id int no
On Thu, 13 Dec 2001, [iso-8859-2] Wojciech Dr±¿ek wrote:
>
> I wonder if it is only question of configuration but my MySQL server has
> problems with suming of float values.
>
> create table ft (id INT AUTO_INCREMENT, val FLOAT, PRIMARY KEY(id));
> insert ft(val) values('3.4');
> insert ft(val) va
On Sat, 8 Dec 2001, Admin wrote:
>
> I was just reading an annoying article from a user who was moving from
> MySql to Postgres because of stability problems and because of
> problems restoring "large" MySql data-dumps.
>
> . . .
>
> I would be grateful to hear your opions and experiences, good or
On Mon, 26 Nov 2001, Sinisa Milivojevic wrote:
> Quentin Bennett writes:
> > So, if you pass NULL in as the first parameter to mysql_real_connect, a
> > possibility opened up by the manual . . .
>
> There is no indication in our documentation that NULL should be passed
> as a first parameter in my
On Sat, 24 Nov 2001, Sinisa Milivojevic wrote:
> I think that our documentation is quite clear on that issue. . . .
Not quite:
"For a successful connection, the return value is the same as the value
of the first parameter, unless you pass NULL for that parameter." (Manual)
That is, if you pass
What is the semantics of passing a NULL mysql connection to
mysql_real_connect()? Does it create a new handler? This is the only
possible interpretation of the result value as documented. However it is
also (abundantly) documented that the handle must be created with
mysql_init(). So what stands?
On Thu, 15 Nov 2001, Gabor Penoff wrote:
> can you tell me an estimated speed about filling 100 records with
> mysql insert by using the C api?
Last insert job I ran did c. 400 inserts per second. This is real
("wall") time and some computations were involved.
(Dont go running fetching a ca
On Wed, 14 Nov 2001, Aaron Williams wrote:
> At 3:54 PM + 11/14/01, M. A. Alves wrote:
> >On Wed, 14 Nov 2001, Aaron Williams wrote:
> >> . . .
> >> I am not expert on innodb, or mysql either. I started playing with
> >> those values after reading
On Wed, 14 Nov 2001, Aaron Williams wrote:
> . . .
> I am not expert on innodb, or mysql either. I started playing with
> those values after reading the performance guide on Innodb.com.
What is this site (Innodb.com)? It seems to show some kind of report on
some system associated with the HTTP r
On Wed, 14 Nov 2001, Carlos Alberto Afranllie wrote:
> I need to insert files of images in a table, which has a field of
> type BLOB, I have understood that to do this I can use the function
> LOAD_FILE(file.bmp), but that this file must be in the server. It is not
> possible to insert a file tha
On Tue, 13 Nov 2001, Carl Troein wrote:
> As far as I understood the original post, the question was if
> there's a way to get MySQL to perform an ORDER BY prior to
> doing the GROUP BY.
Yes it was but "prior to" does not make much sense and that is why I asked
the original poster for an example.
mysql
On Mon, 12 Nov 2001, Christian Andersson wrote:
> Is it possible in myslq to do an order by before an group by?
For me it is not clear why would you want to do that. Can you give an
example?
--
,
M A R I O data miner, LIACC, room 221 tel 351+226078830, ext 121
A M A D O Rua Cam
mysql database $!#"$#%&$
> On Sun, 11 Nov 2001, Michael Conley wrote:
> > . . . even though the text files that I am importing don't have the
> > customer number of the person who submitted it, if I know the customer
> > number . . .
>
> Where from do you get that information (costumer number) at
> So you mean to replace joining with combined condition?
I think it is simply a terminological/syntactical difference. I simply
never use LEFT JOIN commands. I always use '='. I think they do the same
think, namely what is called a "join" in relational _theory_. I
*understand* '=' better then JO
I know K&R (section 4.9, 2nd ed.) says
char s[] = "...";
is equivalent to
char s[] = { . . . , '\0'}
but I always explicitely attach the \0 just to be sure i.e.
char s[] = "...\0";
/* mysql, database (cheating the filter, human reader ignore) */
--
,
M A R I O data miner, LIACC
Some other useful information on this problem:
I have tried the operation in two other ways, both based on a version of
the program with only one connection using the API and emiting the UPDATE
statments on standard output:
1. output piped onto mysql --> failure :-(
2. output saved on a fil
On Tue, 30 Oct 2001, M. A. Alves wrote:
> I seem to be hitting a ceiling in MYSQL_RES (mysql_use_result). I select
> 2 or 3 items but only 2295 are returned. What might be the cause
> of this?
The probable cause is I was accessing the same table at the same time (but
thru
I seem to be hitting a ceiling in MYSQL_RES (mysql_use_result). I select
2 or 3 items but only 2295 are returned. What might be the cause
of this?
Thanks,
--
,
M A R I O data miner, LIACC, room 221 tel 351+226078830, ext 121
A M A D O Rua Campo Alegre, 823 fax 351+2
> How can i insert image in a database.
<>
(The MySQL Manual, section 7.1.1)
Cheers,
--
,
M A R I O data miner, LIACC, room 221 tel 351+226078830, ext 121
A M A D O Rua Campo Alegre, 823 fax 351+226003654
A L V E S P-4150 PORTO, Portugalmob 351+939354002
---
On 25 Oct 2001 [EMAIL PROTECTED] wrote:
> Your message cannot be posted because it appears to be either spam or
> simply off topic to our filter. To bypass the filter you must include
> one of the following words in your message:
>
> database,sql,query,table
>
> If you just reply to this message,
Hello.
I am linking the mysqlclient library (libmysqlclient.a) to my client
program as indicated in the MySQL Manual section 23.1, and I am getting
the following linker error messages:
/usr/lib/mysql/libmysqlclient.a(my_compress.o): In function
`my_compress_alloc':
my_compress.o(.text+0xbb): und
Hello.
I am linking with libmysqlclient as told by the MySQL Manual. However I am
getting the following linker error messages:
/usr/lib/mysql/libmysqlclient.a(my_compress.o): In function
`my_compress_alloc':
my_compress.o(.text+0xbb): undefined reference to `compress'
/usr/lib/mysql/libmysqlclie
30 matches
Mail list logo
