Hi,
I'm not sure my reply will be of any use to you, but here it goes..
I've recently had problems with a perl driver (DBD::mysqlPP) with regards
to, amongst other things, large BLOB data entries. My short-term work-around
is simply to handle all BLOBs on the client side, i.e. split up all long
Hi,
[..]
produces the following error messages.
/tmp/ccPhnnJk.o: In function `main':
/tmp/ccPhnnJk.o(.text+0x14): undefined reference to `mysql_init'
/tmp/ccPhnnJk.o(.text+0x5a): undefined reference to `mysql_real_connect'
/tmp/ccPhnnJk.o(.text+0x6d): undefined reference to `mysql_query'
Hi,
SELECT * FROM students,grades WHERE students.ID=grades.ID AND grades.grade
students.average_grade
This doesn't work. It gets me all the occasions where a student has beaten
his average. But I only want students who have never gone below their
average! In other words, I want to select
Hi,
I'm having a slight problem trying to figure out some logic. I have a
mySQL table that contains 3 columns (child, category, parent).
What I like to do is retrieve all the childrens of the parent and store
them in an php array.
I assume you want to get all children for all parents
*] I need to generate a RANDOM UNIQUE number for every new record. Is
there an
*] easy way to accomplish this inside of mySQL.
*]
What are the requirements for 'random' and 'unique'? Do you need some sort
of cryptographic randomness? Does uniqueness be kept across tables?
If you 'only'
*] I need to generate a RANDOM UNIQUE number for every new record.
Is
there an
*] easy way to accomplish this inside of mySQL.
*]
What are the requirements for 'random' and 'unique'? Do you need some
sort
of cryptographic randomness? Does uniqueness be kept across tables?
Hi,
When using mysql.h there is defined a:
MYSQL_VERSION_ID
It's defined as something like:
32235
I guess this is representing version 3.33.35.
Is this the 'right' way of determining version? I want to do something like
an ifdef to incorporate support in my code for different
- Original Message -
From: [EMAIL PROTECTED]
To: Aigars Grins [EMAIL PROTECTED]
Sent: Monday, April 23, 2001 10:51 PM
Subject: Re: Re: Reg. determining version
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the filter
I'm using MySQL on OpenBSD 2.7 and I'm accessing it throhgh DBI/DBD. While
filling a large table with data I finally get the error :
"Got error 22 from table handler"
while trying to do an insert statment. The table file is about 4G so I
assume the file is 'full'. Can anyone confirm that
Hi,
I'm using MySQL 3.22.32 on OpenBSD 2.7. Does there exist a maximum table
size? How big (4G)? Can I avoid this in any way?
--
Aigars
I'm using MySQL on OpenBSD 2.7 and I'm accessing it throhgh DBI/DBD. While
filling a large table with data I finally get the error :
"Got error 22
... my problem is I want 3 images to appear in any one row in the table.
Subsequent images I want to start in the next row down, subject to a limit
of 3 and so forth.
Some naive and simplistic 'pseudo' code:
code
int current = 0, max = 3;
print_table_row_start();
while (sql_row =
Is MySQL support distributed database or not ?
If yes, then please let me know , how it's doing .
Maybe not in a sense you'd like, but it has support for replication. Just
read up on the manual, as in (the url will propably wrap):
sprintf(szQuery,"Insert into mytable(mycol)values '%s' ",
mydata);
where mydata is a C variable containing a large text item
The problem occurs when mydata contains a single quote, then that single
quote is taken as the end of the column value by the MySQL parser
sprintf(szQuery,"Insert into mytable(mycol)values '%s' ",
mydata);
where mydata is a C variable containing a large text item
The problem occurs when mydata contains a single quote, then that single
quote is taken as the end of the column value by the MySQL parser
sprintf(szQuery,"Insert into mytable(mycol)values '%s' ",
mydata);
where mydata is a C variable containing a large text item
The problem occurs when mydata contains a single quote, then that single
quote is taken as the end of the column value by the MySQL parser
sprintf(szQuery,"Insert into mytable(mycol)values '%s' ",
mydata);
where mydata is a C variable containing a large text item
The problem occurs when mydata contains a single quote, then that single
quote is taken as the end of the column value by the MySQL parser
sprintf(szQuery,"Insert into mytable(mycol)values '%s' ",
mydata);
where mydata is a C variable containing a large text item
The problem occurs when mydata contains a single quote, then that single
quote is taken as the end of the column value by the MySQL parser
sprintf(szQuery,"Insert into mytable(mycol)values '%s' ",
mydata);
where mydata is a C variable containing a large text item
The problem occurs when mydata contains a single quote, then that single
quote is taken as the end of the column value by the MySQL parser
sprintf(szQuery,"Insert into mytable(mycol)values '%s' ",
mydata);
where mydata is a C variable containing a large text item
The problem occurs when mydata contains a single quote, then that single
quote is taken as the end of the column value by the MySQL parser
sprintf(szQuery,"Insert into mytable(mycol)values '%s' ",
mydata);
where mydata is a C variable containing a large text item
The problem occurs when mydata contains a single quote, then that single
quote is taken as the end of the column value by the MySQL parser
sprintf(szQuery,"Insert into mytable(mycol)values '%s' ",
mydata);
where mydata is a C variable containing a large text item
The problem occurs when mydata contains a single quote, then that single
quote is taken as the end of the column value by the MySQL parser
sprintf(szQuery,"Insert into mytable(mycol)values '%s' ",
mydata);
where mydata is a C variable containing a large text item
The problem occurs when mydata contains a single quote, then that single
quote is taken as the end of the column value by the MySQL parser
sprintf(szQuery,"Insert into mytable(mycol)values '%s' ",
mydata);
where mydata is a C variable containing a large text item
The problem occurs when mydata contains a single quote, then that single
quote is taken as the end of the column value by the MySQL parser
sprintf(szQuery,"Insert into mytable(mycol)values '%s' ",
mydata);
where mydata is a C variable containing a large text item
The problem occurs when mydata contains a single quote, then that single
quote is taken as the end of the column value by the MySQL parser
sprintf(szQuery,"Insert into mytable(mycol)values '%s' ",
mydata);
where mydata is a C variable containing a large text item
The problem occurs when mydata contains a single quote, then that single
quote is taken as the end of the column value by the MySQL parser
This is an open plea to the MySQL team. The amount of spam and other
noise
on the list has been growing more and more every day. I would like to
make
a couple basic plea's. The first, is that you require a poster to the
list
have an actual account on the list, that should help cut out some
Then two MySQL installed on a machine can use the same port 3306 or
one of them must changed to another port ?
Unless you have some auto-magical port-proxy thingy you have to have
different ports for each working server on the same machine.
Or does MySQL have native handling of this? (I would
[..] Why this is
s slow with BSD we still don't know (like i said in my first mail,
same query was 3 secs or ~20 sec on Linux)
I haven't followed the entire thread so feel free to diss me..
There was problem with the userland threading under early OpenBSD 2.8
versions (including the
MySQL doesn't use a table index when doing a string search like %string%,
but it MAY use the index when doing something string%. Is there a way you
can change your search to do a "string starts with" instead of a "string
contains" ? This should help with MySQL using the index that you want
). So once again, has anyone
done something like this? Any experiences to share? Any pointers to where to
start and look?
Should I forward this message to somewhere else?
--
Aigars Grins
-
Before posting, please check:
http
From: "Ralph Graulich" [EMAIL PROTECTED]
Read about "replication" in the corresponding chapters in the online
manual
of mySQL (http://www.mysql.com/) - Documentation.
From: "Mat Murdock" [EMAIL PROTECTED]
Did you look at doing something with replication?
Thanks for the quick reply. I hadn't
ur looking for.
Sigh. Maybe it isn't. That would be too bad. I like MySQL. I'll look over
the replication descriptions once more..
--
Aigars Grins
-
Before posting, please check:
http://www.mysql.com/manual.php (the manua
32 matches
Mail list logo