Consider table A with columns id (primary key), name and table B with columns id, a_id (foreign key linked with table A id column), address. What will be the sequence of columns if the query is:
SELECT * FROM B INNER JOIN A ON B.a_id = A.id;
Mysql – theSQL foreign key and primary key
foreign keyjoin;MySQL
Related Question
- Mysql – the best approach to find all fields that has (Foreign Key and Primary Key) constraints in a Mysql database
- Mysql – How does thesql(innoDB) handle same foreign key for join
- MySQL – Fixing Primary Keys as Foreign Keys Error in PhpMyAdmin
- Database Design – Managing Foreign and Primary Keys
- PostgreSQL – Primary Key as Foreign Key
- Mysql – thesql how to copy foreign key data from one table to another
Best Answer
What do you mean by "sequence of columns"? One interpretation has to do with
SELECT *-- the*will list the columns in definition order, first fromB, then fromA.It is generally a bad idea to use
SELECT *, at least for production queries.