Chúng tôi có thể thêm hoặc xóa các cột bằng cách sử dụng một cơ chế tương tự như: các Ins hoặc Del hộp kiểm tra dưới Mỗi cột, hoặc các trường Cột thoại Add / Delete. Đã được chúng tôi HAD một cột không sử dụng. Ở đây chúng tôi đã thêm một cột bằng cách sử dụng hộp kiểm Ins Nằm dưới cột chưa sử dụng (thời gian này chúng tôi sẽ cần nó): | Multi-Table Query Generator The Update Query button refreshes the page with the specified adjustment. Adjusting the Number of Criteria Columns We can add or delete columns by using a similar mechanism the Ins or Del checkboxes under each column or the Add Delete Field Columns dialog. We already had one unused column. Here we have added one column using the Ins checkbox located under the unused column this time we will need it 206 Chapter 13 Automatic Joins Let s now add some fields from our books table and see what happens phpMyAdmin uses its knowledge of the relations defined between the tables to generate a left join on the common author_id key field. A shortcoming of the current version is that only the internal relations are examined not the InnoDB relations. There may be more than two tables involved in a join. Executing the Query Clicking the Submit Query button sends the query for execution. In the current phpMyAdmin version there is no easy way except by using the browser s Back button to come back to the query generation page after we have submitted our query. The next chapter Bookmarks discusses how to save the generated query for later execution. 207 Multi-Table Query Generator Showing rows 0 - 0 1 total Query took sec -SQL query SELECT authors . author_name authors .phone books . title books genre FROM books LEFT JOIN authors ON books authorjd authors . authorjd WHERE authors . authorjiame LIKE Smith AND authors . phone LIKE 8 OR authors . author_name Maria Sunshine _ ORDER BY authors . author_name ASC authors phone ASC LIMIT 0 30 Edit Explain SQL Create PHP Code Refresh Show I ãõ row s starting from record 0 in I horizontal 3 mode and repeat headers after 100 cells authorname phone title genre Maria Sunshine 333-3333 Future souvenirs Summary In this chapter we have covered various aspects such as opening the query generator choosing tables entering column criteria sorting and showing columns and altering the number of criteria rows or .
