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 past 3 years) on
vacationT.`date` =
1. no
2. yes
-Original Message-
From: Machiel Richards [mailto:machi...@rdc.co.za]
Sent: Monday, January 10, 2011 2:07 AM
To: mysql mailing list
Subject: Mysql Event scheduler
Good day all
Can anyone perhaps off hand tell me whether the following two
tasks will be able to be sche
In reality, you better off manipulating the MyISAM tables via SQL.
However, if you really are that adventurous about low-level reads of MyISAM
tables, I have a crazy suggestion for you !!!
The old MySQL book used as reference to MySQL 3.23/4.0 describes manipulating a
MyISAM table with an API t
>-Original Message-
>From: Michael Dykman [mailto:mdyk...@gmail.com]
>Sent: Sunday, January 09, 2011 3:02 PM
>To: LAMP; mysql@lists.mysql.com
>Subject: Re: export result from select statement
>
>I second Jerry's recommendation. It always works like a charm for me.
>
[JS] Thanks.
By the w
>-Original Message-
>From: LAMP [mailto:l...@afan.net]
>Sent: Sunday, January 09, 2011 9:46 PM
>To: mysql@lists.mysql.com
>Subject: Re: export result from select statement
>
>maybe it's "clear" to other but it's pretty unclear.
>#mysql -username -p "select * from table_name where id=123" >
Good day all
Can anyone perhaps off hand tell me whether the following two
tasks will be able to be scheduled with the MySQL event scheduler?
1. MySQL backups using mysqldump
2. Analyzing of tables (all tables for all databases)
Regards
Machiel