Hello MySQL-User,
i need your help with the following query.
I want to get the next birthdays of my friends, but not only the one of
this year.
So when im in december ( or november ) i want to see the birthdays of
next year too
With my query i only see the birthdays of this year :
SELECT
Hello MySQL-User,
i need your help with the following query.
I want to get the next birthdays of my friends, but not only the one of
this year.
So when im in december ( or november ) i want to see the birthdays of
next year too
With my query i only see the birthdays of this year :
SELECT
Hey everybody,
i´m becoming desperate about the following problem.
We´ve an online-community / network.
There´s a network table ( sql create below ), in which we store the
relationships between the member.
I need a SQL-statement or a PHP-Function to calculate the 2nd, 3rd and
4th degrees betwee
Hey everybody,
i´m becoming desperate about the following problem.
We´ve an online-community / network.
There´s a network table ( sql create below ), in which we store the
relationships between the member.
I need a SQL-statement or a PHP-Function to calculate the 2nd, 3rd and
4th degrees betwee
Hey, i´ve a problem with getting the next and the actual birthdays.
This my actual birthday sql :
SELECT SQL_CACHE birthday,mem.lname, mem.fname,mem.mem_id FROM members mem
INNER JOIN network net ON (net.mem_id = mem.mem_id AND net.frd_id =1)
WHERE
(( DAYOFYEAR(FROM_UNIXTIME( mem.birthday )) < D
Hey,
what do you think is the best configuration ( my.cnf ) for running a
database,
which many users access at the same time ( Website - Portal ).
We´ve also saved our Pictures ( nearly 3.500 rows ) in our database.
Every coloumn is round about 60-70 Kbyte, so i had to use mediumblob
columns.
Hey,
what do you think is the best configuration ( my.cnf ) for running a
database,
which many users access at the same time ( Website - Portal ).
We´ve also saved our Pictures ( nearly 3.500 rows ) in our database.
Every coloumn is round about 60-70 Kbyte, so i had to use mediumblob
columns.
Hi everyone,
how can i import a database export from another database.
I´ve got alway a permission error...
I used mysqlimport & mysqldump...
Thanks in advance
Marco Schierhorn
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.c
Thanks for your quick reply.
We use PHP.
I´ll try it with mysql_pconnect();
I´ve already thought about it.
What happens, when we´ve several 1000 Users online. Doesn´t it open too
many connections ?
mysql_connect closes every connection after using.
Does mysql_pconnect() the same ?
Thanks a lot
Hey,
we´ve on 2 website the problem, that if you hit a several times F5 or
hold it down to reload the site,
MySQL opens many connections and breaks down after a while.
How can we prevent this ?
I close every MySQL Session and i do an if-statement ( if there´s any
open connect ) before i open a
Hey,
we´ve large amount of Images ( nearly 2 GB ).
And they will increase, cause or Editors will submit several articles a
day where they´re allowed to upload
some new pics.
So, whats the better solution ? To store them in the filesystem ( with
only the path in the db )
or to store them as BL
running an explain
on the slow queries should help you out.
-Sheeri
On 11/21/05, ESV Media GmbH <[EMAIL PROTECTED]> wrote:
Hey, we´ve a site ( PHP ) where several 1.000 are online at the same time.
They´re running many sql statements.
Is there a way to find out which statements take a fu
Hey, we´ve a site ( PHP ) where several 1.000 are online at the same time.
They´re running many sql statements.
Is there a way to find out which statements take a full table scan to
optimize them ?
We´ve a cpu percentage of nearly 50 % with only 30 Members online.
And i´ve seen that there are so
13 matches
Mail list logo
