2
I have 2 tables in my database, Categories and Cars. The table categories has a PK Id_category and Name. Already Automobiles has a PK Id_automoveis and the other columns that make up this table INCLUDING the FK Id_categoria as you can see in the image below:
I’m starting my studies in databases with mysql but I’m having a lot of difficulties in relational models and Inner Join. If there’s something wrong I can change it too!
This database is handled by a PHP system.
INNER JOIN is a heavy query, only used when you really want all the records of the other corresponding table.
– djva
We should not use functions of the "mysql" extension because its development has been discontinued.Since you are starting your studies I suggest starting with mysqli or PDO.
– user60252
Related: https://answall.com/q/8319/64969
– Jefferson Quesado
Related: https://answall.com/q/17522/64969
– Jefferson Quesado