thank you both for your comments. I do have one more thing , I'm not sure about. If i create database locally and set up a login to connect to my app. can I also somehow have that user set up in scripts, such that I can create the same set up and tables , simply by running scripts in a prod server?
>> can I also somehow have that user set up in scripts, such that I can create the same set up and tables , simply by running scripts in a prod server?
Yes. I already answered that in my first post:
To execute SQL commands in a file:
mysql> source file_name
mysql> \. file_name
https://dev.mysql.com/doc/refman/8.0/en/mysql-batch-commands.html
You can query the mysql information_schema.tables to list available tables and use that in your script.
https://dev.mysql.com/doc/refman/8.0/en/tables-table.html
Another way and easier is to use the create table syntax that Sligtwv mentions. :-)
Regards,
Tomas Helgi