I found an answer without having to worry about complicated SQL
statements - it's more about managing the tables than the SQL.
Jacob
Quoting Jacob Steinberger :
I have a requirement to keep track of a set of data, and all changes
that might occur. In order to do this, for each field of the d
I have a requirement to keep track of a set of data, and all changes
that might occur. In order to do this, for each field of the data set,
I've created a table that keeps track of the version, the value, the
time the change was made, and a linking number that links all the
different tables
Hi Geoff,
> This server has 6GB of RAM and no swap. According to some reasearch I was
> doing I found this formula for calculating memory size:
>
> key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections =
> (in your case) 384M + (64M + 2M)*1000 = 66384M
>
> That come directly fro
In the last episode (Aug 25), Moon's Father said:
> Hi.
>For example, entering mysql command line client,
>mysql> pager more ( or pager md5sum and so on.)
>
>I want to know how many command the 'pager' follows? Any reply will
> be big appreciated.
Any command can be used as a pager.
Travis
Do you think it would be better if I stored the information in
a separate table, rather than using unions etc - to make the searching,
counting etc easier ? Or is this method a standard way of dealing with this
sort of data.
Cheers
Neil
On Tue, Aug 24, 2010 at 5:43 PM, Travis Ard wrote:
I need a single row from 2 different tables. It is rather trivial to
create a join that will join these two tables and give me all the
information I want in one query. It is also fairly easy to just execute
two different queries with out any join and get the data I need. Since
the both singl
Hi,
I'm creating a application which hosts football matches and I want to record
the player appearances, goals etc. I was thinking of having a record for
each player as follows :
appearance_id
season_id
player_id
team_id
competition_id
appearance
goals
yellow_card
red_card
date_played
Is this t
Hi M,
This appears to do exactly what I require. Thank you !
Cheers
Neil
On Wed, Aug 25, 2010 at 1:43 PM, misiaQ wrote:
> select ci.*, ct.* from (select name, countrycode from city) ci, country ct
> where ci.countrycode = ct.code
>
> Regards,
> m
>
> -Original Message-
> From: Tompkin
Not tested, but i think it could work for you:
SELECT
student_age,
(SELECT
student_subjects_id
FROM
student_subjects
ORDER BY
RAND()
LIMIT 1) as subject_id,
(SELECT
random_mark
FROM
student_subjects
having
student_subj
select ci.*, ct.* from (select name, countrycode from city) ci, country ct
where ci.countrycode = ct.code
Regards,
m
-Original Message-
From: Tompkins Neil [mailto:neil.tompk...@googlemail.com]
Sent: Wednesday, August 25, 2010 1:23 PM
To: [MySQL]
Subject: Retrieve three columns in sub qu
I thought as much, if anyone else can shed some light that would be great.
If not, I'm going to have to write an additional query.
2010/8/25 João Cândido de Souza Neto
> As far as I know sub-queries intends to be an only one column and row
> result.
>
> --
> João Cândido de Souza Neto
>
> "
As far as I know sub-queries intends to be an only one column and row
result.
--
João Cândido de Souza Neto
"Tompkins Neil" escreveu na mensagem
news:aanlkti=djkujcsg=kf29sjsp0yllhmhb02mqzdvzd...@mail.gmail.com...
> Hi
>
> Is it possible in MySQL 5.1 to retrieve three columns in a select
>
Hi
Is it possible in MySQL 5.1 to retrieve three columns in a select sub-query
like below :
SELECT student_age, SELECT (student_subjects_id, random_mark, subject FROM
student_subjects ORDER BY RAND(), LIMIT 1)
FROM students
WHERE student_age > 10
ORDER BY RAND()
LIMIT 1
I've looked and tried eve
On 25/08/2010 8:23 a, Geoff Galitz wrote:
Hello,
We are having issues with one of our servers sometimes hanging up and when attempting to
shutdown the DB, we get "cannot create thread" errors.
This server has 6GB of RAM and no swap. According to some reasearch I was
doing I found this formu
On 25/08/2010 8:05 a, Michael Dykman wrote:
How are you shutting down the server during the restart.. have you
checked the logs? Might you be issuing a kill and crashing it?
MyISAM doesnot dealwith crashes very elegantly.
Also, what is some reason? Might thereason you need to restart be relat
Alternatively, you could just code a recursive function to do the same
instead of doing it in SQL or stored procs.
On Tue, Aug 24, 2010 at 11:01 AM, Victor Subervi wrote:
> On Tue, Aug 24, 2010 at 1:43 PM, Peter Brawley
> wrote:
>
> > >What I'm trying to accomplish is to order the results such th
16 matches
Mail list logo