Enissay_Help, MySQL

Language: Layout:

#MySQL 5.7.12
#please drop objects you've created at the end of the script 
#or check for their existance before creating
#'\\' is a delimiter

select version() as 'mysql version';

DROP TABLE IF EXISTS myTab;

CREATE TABLE IF NOT EXISTS myTab (
	id 			SERIAL PRIMARY KEY,		-- SERIAL alias for BIGINT UNSIGNED NOT NULL AUTO_INCREMENT UNIQUE
	dateID		DATETIME DEFAULT 0,		-- To be saved as string "yyyy-MM-dd HH:mm:ss"
	name		VARCHAR(512)
) ENGINE=INNODB DEFAULT CHARSET=utf8;

INSERT INTO `myTab` (`dateID`,`name`) VALUES
	("20140811","Emmy"),	/*this*/
	("20140922","Emmy"),	/*this*/
	("20150920","Emmy"),	/*this*/
	("20150922","Emmy"),
	("20140722","Dave"),
	("20140613","Stan"),
	("20140622","Stan"),	/*this*/
	("20151020","Stan"),	/*this*/
	("20140305","Lora"),
	("20140310","Lora");

SELECT * FROM myTab;
SELECT count(*) FROM myTab;

/*ToDo:
  -----
Select all rows with names having multiple dates
when the difference between these dates is more than 1 month
eg: only the entries indicated above *this*
*/

Select a.id, a.dateID, a.name from myTab a, myTab b 
    where b.dateID between a.dateID AND date_add(a.dateID, INTERVAL 1 MONTH)
    group by a.id, a.name


absolute service time: 0,33 sec