SELECT CONCAT(DATE_FORMAT(NOW(), '%m%Y'), '/', LPAD(COUNT(*) + 1, 4, 0)) AS folio
FROM [table_name]
WHERE MONTH([record_creation_date_column]) = MONTH(NOW());
Be the first to comment
You can use [html][/html], [css][/css], [php][/php] and more to embed the code. Urls are automatically hyperlinked. Line breaks and paragraphs are automatically generated.
Be the first to comment
You can use [html][/html], [css][/css], [php][/php] and more to embed the code. Urls are automatically hyperlinked. Line breaks and paragraphs are automatically generated.