Kèm theo xuất khẩu trong một giao dịch: Bắt đầu với MySQL , chúng ta có thể sử dụng câu lệnh GIAO DỊCH START. Lệnh này, kết hợp VỚI SET autocommit = 0 tại COMMIT Bắt đầu và lúc kết thúc, Đặt MySQL để thực hiện nhập khẩu (khi tái nhập khẩu Chúng tôi sẽ tập tin) trong một giao dịch, đảm bảo đó Tất cả các thay đổi được thực hiện như một toàn thể. | Searching Data Selection of Display Fields The first panel facilitates selection of the fields to be displayed in the results All fields are selected by default but we can control-click other fields to make the necessary selections. 142 Chapter 9 Here are the fields of interest to us in this example We can also specify the number of rows per page in the textbox just next to the field selection. The Add search conditions box will be explained in the Applying a WHERE Clause section later in this chapter. Search Criteria by Field Query by Example The main usage of the Search panel is to enter criteria for some fields so as to retrieve only the data in which we are interested. This is called Query by example because we give an example of what we are looking for. Our first retrieval will concern finding the book with ISBN 1-234567-89-0. We simply enter this value in the isbn box and choose the operator 143 Searching Data Clicking on Go gives the results shown in the following screenshot. The four fields displayed are those selected in the Select fields dialog -T- isbn title authorid language r j X 1-234567-89-0 A hundred years of cinema volume 1 1 en t__ Check All Uncheck All With selecteơ s X IB Show 1130 row s starting from record o in I horizontal 3 mode and repeat headers after ioo cells Insert new row Print view Print view with full texts fiki Export This is a standard results page. If the results ran in pages we could navigate through them and edit and delete data for the subset we chose during the process. Another feature of phpMyAdmin is that the fields used as the criteria are highlighted by changing the border color of the columns to better reflect their importance on the results page. It isn t necessary to specify that the isbn column be displayed. We could have selected only the title column for display and selected the isbn column as a criterion. Print View We see the Print view and Print view with full texts links on the results page. These links .
