sql - How to find out data from more than one tables in MYSQL -

sql - How to find out data from more than one tables in MYSQL -

i working on mysql based project. need find out info more 1 table. have searched , found solution like

select * table_1, table_2 (condition)

but such solution fine few tables,and have 57 tables in database. please allow me know solution.

thanks in advance.

sounds want join tables. e.g.:

select * table1 inner bring together table2 on table1.table1id = table2.table1id left bring together table3 on table2.table2id = table3.table2id;

unfortunately if want info 57 tables, need bring together 57 of them.

the syntax have used (ansi 89), while work best avoided (i believe there times when oracle optimise these better), ansi 92 joins less prone user error, , (to people) more legible because bring together status comes after table. aaron bertrand has written good article on reasons utilize ansi 92 syntax on ansi 89.

mysql sql