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
q
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_que
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 s
Wouldn't something like this work?
SELECT a.price AS pesetas_price, b.rate AS exchange_rate,
ROUND(a.price*b.rate) AS pound_price
FROM prices AS a
LEFT JOIN rate AS b ON 1 = 1
--
Aigars
- Original Message -
From: "Simon Green" <[EMAIL PROTECTED]>
To: "'Craig Atkins'" <[EMAIL PROTECT
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 (so
> > > > *] 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
> > *] 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 'onl
- 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
Hi,
When using 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 versions of My
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
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 the
> ... 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:
int current = 0, max = 3;
print_table_row_start();
while (sql_row = get_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):
http://www.mysql.com/documentation/mysql/bychapter/manual_Rep
> 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 parse
> 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 parse
> 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 parse
> 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 parse
> 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 parse
> 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 parse
> 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 parse
> 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 parse
> 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 parse
> 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 parse
> 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 parse
> 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 parse
> 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 parse
> 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 s
> 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 woul
> [..] 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 's
> 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 wa
of these are documented in the manual, if your application needs
fully
> distributed transactions, MySQL is not the system your 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
--
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
m. And we're really short on resources
(the data amount in from time to time enormous). 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
-
33 matches
Mail list logo
