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!
July 9th 19 at 10:45
2 answers
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.
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

Find more questions by tags PHP