Query the SQL database?

Question

Query the SQL database?

In the table ( library) which is in the database has sections (users, books, users_books) . I realized that to add a new field into table(column) using the query "ALTER TABLE library ADD name VARCHAR(60);" . But with the help of the query, you can not add a field to the table and in the table "users" add column "name"? Thank you very much for the answer!

PHP

Conor_Ko asked July 9th 19 at 10:45

Related questions

More answers about "Query the SQL database?"

2 answers

aniya.Kertzmann65 answered on July 9th 19 at 10:49

What do you mean by "section"?

The column with the data, for example in the users user names in books books - Conor_Ko commented on July 9th 19 at 10:52

with terminologia clearly trouble - arturo.Wilkinson commented on July 9th 19 at 10:55

cleve_Murray answered on · Accepted Answer · 2019-07-09T10:47:00.453Z

cleve_Murray answered on July 9th 19 at 10:47

Solution

You incorrectly represent the structure.
Do you have field users, books, users_books
in the users store only the id is the key which leads to another table with all the data, there could already determine the field name for this user.