How to store arrays in MySQL?

The proper way to do this is to use multiple tables and JOIN them in your queries. For example: The person_fruit table contains one row for each fruit a person is associated with and effectively links the person and fruits tables together, I.E. When you want to retrieve a person and all of their fruit …

Read more

grant select on view

The error message should be written like this: ORA-01720: “grant option” does not exist for COLLDESK.GESTIONES. Here’s how it works: You have 3 schemas: Schema1 – Holder of a table named “table1” Schema2 – Holder of a view “view1” selecting from schema1.table1 Schema3 – User, selecting from schema2.view1 – has no select granted on schema1.table1. …

Read more

How to store arrays in MySQL?

The proper way to do this is to use multiple tables and JOIN them in your queries. For example: The person_fruit table contains one row for each fruit a person is associated with and effectively links the person and fruits tables together, I.E. When you want to retrieve a person and all of their fruit …

Read more