Automated
To create an output like this: https://drive.google.com/file/d/1NlImnhE35Zattw4KKH7gVrQcGcMsSlRJ/view?usp=sharing
Do i create a stored procedure or view that would allow this end result above?
SQL: https://drive.google.com/file/d/1mkBA8Uc8tZjhWdzqGaxLAPnNoqpBSfMZ/view?usp=sharing
Answer Answered by Daniel Black in this comment.
You are using a Microsoft SQL Server syntax. This isn't supported.
Look at the syntax CREATE TABLE here to correct.
Also look at the date format used by MariaDB.
Use ; at the end of statements when creating them in the command line program and some guis.
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
