Today a question arose to me, I was creating a table in the database and I came across whether I should do this manually, directly in the database or create this table through queries, creating a .sql
page. What would be best and safest?
Today a question arose to me, I was creating a table in the database and I came across whether I should do this manually, directly in the database or create this table through queries, creating a .sql
page. What would be best and safest?
I suppose when you say it manually, it refers to the command line.
This comes down to just the way you insert information, there is no better or worse, do what suits you best (usually cl). On security, you should be aware that to perform any script about your database, you need to be authenticated.
There is no standard way of creating tables or data in the database, but to make it easier and faster to use a database manager, go with your preference.