I'm not 100% sure I'm understanding your requirements, but this query:
select id from datetest where date_in not between '2006-09-05' and
'2006-09-21' and date_out not between '2006-09-05' and '2006-09-21';
should do exactly as you want for getting id3 if I'm understanding
the requirements
If you mean trying to rename a table, you should be able to double
click on the name to bring up the specifics of the table.
I'm using the newest version of workbench, for OSX. It should be the
same for all platforms of workbench.
-David Thole
On Oct 22, 2006, at 11:37 AM, João Cândido de
On Sun, 2006-10-29 at 22:06 +0800, Ow Mun Heng wrote:
> Hi,
>
> Learning about MySQL's stored procedure programming.
>
> trying to do things like count(*) of the # of rows in a specific table.
> When I try to put the table_names as a variable I don't get anything
>
> eg:
> DELIMITER $$
> DROP PR
Hi,
Learning about MySQL's stored procedure programming.
trying to do things like count(*) of the # of rows in a specific table.
eg:
DELIMITER $$
DROP PROCEDURE IF EXISTS `test`.`sp_countrows`$$
CREATE [EMAIL PROTECTED] PROCEDURE `sp_countrows`()
BEGIN
SELECT count(*) AS 'Test1(QTY)' FROM test
Hi
I have 3 fields like this:
id date_in date_out
1 2006-09-05 2006-09-10
2 2006-09-15 2006-09-20
3 2006-09-25 2006-09-30
Example: if I have an time interval like '2006-09-05' and '2006-09-21',
I have to search, in the same time, only the records that not included
in time i