tailieunhanh - Beginning PHP and MySQL From Novice to Professional phần 10

Vì vậy, bạn phải thay đổi dấu phân cách để một chuỗi ký tự khác. Nó không phải là / /. Bạn có thể chọn bất cứ điều gì bạn vui lòng, | | | hoặc ^ ^, ví dụ Thực hiện một thói quen lưu trữ được thực hiện bằng cách tham chiếu thường xuyên được lưu giữ cùng với lệnh CALL. Ví dụ, file thực thi được tạo ra trước đây | CHAPTER 38 Importing and Exporting Data B ack in the Stone Age cavemen never really had any issues with data incompatibility as stones and one s own memory were the only storage medium. Copying data involved pulling out the old chisel and getting busy on a new slab of granite. Now of course the situation is much different. Hundreds of data storage strategies exist the most commonplace of which include spreadsheets and various types of databases. Working in a complex often convoluted fashion you often need to convert data from one storage type to another say between a spreadsheet and a relational database or between an Oracle database and MySQL. If this is done poorly you could spend hours and even days and weeks massaging the converted data into a usable format. This chapter seeks to eliminate that conundrum by introducing MySQL s data import and export utilities as well as various techniques and concepts central to lessening the pain involved in performing such tasks. By the conclusion of this chapter you will be familiar with the following topics Common data-formatting standards recognized by most mainstream storage products The SELECT INTO OUTFILE SQL statement The LOAD DATA INFILE SQL statement The mysqlimport utility How to use PHP to mimic MySQL s built-in import utilities Before delving into the core topics take a moment to review the sample data used as the basis for examples presented in this chapter. Afterward several basic concepts surrounding MySQL s import and export strategies are introduced. .