I have a table that saves users:
Email || Username || age || password
and I need to save the series they have seen and the ones they are watching and as I have read it is not correct to insert two columns with vectors that save the series, how can I do it?
Mysql – make a structure for a thesql database
MySQL
Related Solutions
I think using a MySQL gui tool like SQLyog would solve your problem. It has User manager tool where you can set privilege to different users.
One option to do it is having a many-to-many table, which will hold a calendar id and a user id who can see it. A calendar belonging to two spouses will have two rows in that table.
Related Question
- Mysql – How to auto replicate specific columns only from a table in MySQL
- Mysql – Elegant Database Design
- Mysql – How to verify the password generated by ENCRYPT
- Mysql – Designing MySQL Database For Two Different User Types (Staff and Client)
- Mysql – Turn Emails into Usernames With MySQL Query
- Mysql – How to design Person table in MySQL
Best Answer
Build another table with 3 columns
users(perhapsemail?).Each user would have any number (0 or more) rows in this table.
Think this way: When you need a "vector", make a new table.