Hey
I know that this is a bit of a vague question, but over a period of days
mysqldump will take on one day 2min to complete and on the following day 25min
to complete, with the resulting sql file being maybe 200M bigger. The dataset
isn't really all that large 14Gb on disk with the dump file
On 1/11/11 9:31 AM, Simon Wilkinson wrote:
select users.id from users where users.id in (select newletters.user_id from
newletters left join articles on newletters.id = articles.newsletter_id
where articles.newsletter_id is null);
I think this would do what you require:
SELECT
u.id AS user_i
Hi,
I have 3 tables that I am trying to search across, and could use some help
on how to structure the query. I have a users table, a newsletter table,
and an articles table. The newsletter table has a user_id column, and the
articles table has a newsletter_id column. A user can have multiple
n
On 1/10/2011 18:51, Ryan Liu wrote:
Hi,
In MySQL, is that possible to generate a data set join with it on fly (without
create an temporary table)?
e.g. for a report used by a graphic tool, it requires data in all dates, even it
is null. Can I
select vacationT.* left join ( all dates d in the p
