Sql file or direct in the database

Asked

Viewed 104 times

0

Today a question came to me, I was creating a table in the database and I found out if I should do it manually, directly in the database or create this table through queries, creating a page .sql. What would be better and safer?

  • It would not be better to do DER in Mysql Workbench and have the script generated?

2 answers

1

There is no standard way to create tables or data in the database, but to facilitate and streamline your work use a database manager, you will prefer.

1


I suppose when you say it manually, you mean the command line.

This comes down to just how you enter the information, there is no better or worse, do what suits you best (usually cl). Regarding security, it should be noted that to perform any script on your database, you need to be authenticated.

  • Manually what I mean would be going into the database and creating the table directly into it. But I get it, it’s more of a preference issue anyway, thank you very much!

Browser other questions tagged

You are not signed in. Login or sign up in order to post.