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
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
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.
(MySQL
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,
--
,
M
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.
. . .
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_ which is
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;
. . .
Isn't
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 as
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 not null,
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)
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 bad.
I
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
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
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
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 the performance guide on Innodb.com.
What
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 that
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
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
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.
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
I know KR (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
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
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 different
How can i insert image in a database.
If you want to insert binary data into a BLOB column, the following
characters must be represented by escape sequences:
NUL ASCII 0. You should represent this by `\0' (a backslash and an ASCII
`0' character).
\ ASCII 92, backslash. Represent this by `\\'.
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):
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, and
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'
29 matches
Mail list logo