06-04-2019, Saat: 11:52
https://www.navicat.com/en/company/about...eys-part-2
hocam buradi biri anlatmis
hocam bu sekilde bi kod var bunu kullanmak daha iyi degilmi?
hocam buradi biri anlatmis
CREATE EVENT `NewEvent` ON SCHEDULE AT CURRENT_TIMESTAMP ON COMPLETION NOT PRESERVE ENABLE DO SELECT COUNT(*) as repetitions, group_concat(id, ' (', sira_no, ', ', tc_no, ') ' SEPARATOR ' | ') as row_data FROM amalgamated_actors GROUP BY id HAVING repetitions > 1 UNION SELECT COUNT(*) as repetitions, group_concat(id, ' (', sira_no, ', ', tc_no, ') ' SEPARATOR ' | ') as row_data FROM amalgamated_actors GROUP BY last_name, first_name HAVING repetitions > 1;;
hocam bu sekilde bi kod var bunu kullanmak daha iyi degilmi?
Muharrem ARSLAN