Exporting Structure and Data - Mastering phpMyAdmin 2.8 for Effective MySQL Management - page 103

INSERT INTO 'books' ('isbn', 'title', 'page_count', 'author_id',
'language', 'description', 'cover_photo', 'genre', 'date_published',
'stamp') VALUES ('1-234567-22-0', 'Future souvenirs', 200, 2, 'en', '',
0x89504e470d0a10049454e44ae426082, '', '0000-00-00 00:00:00', '0000-00-00
00:00:00');
INSERT INTO 'books' ('isbn', 'title', 'page_count', 'author_id',
'language', 'description', 'cover_photo', 'genre', 'date_published',
'stamp') VALUES ('1-234567-90-0', 'A hundred years of cinema (volume
2)', 600, 1.12, 'en', '', '', '', '0000-00-00 00:00:00', '0000-00-00
00:00:00');
In this export example, the data for the second book (starting with 0x8950 ) has been
truncated for brevity. In fact, it would contain the full hexadecimal representation of
the cover_photo ield of this topic.
The first part of the export comprises comments (starting with the characters, -- ) that
detail the utility (and version) that created the file, the date, and other environment
information. We then see the CREATE and INSERT queries for each table.
Starting with version 2.6.0, phpMyAdmin generates ANSI-
compatible comments in the export file. These comments
start with -- . They help with importing the file back on
other ANSI SQL-compatible systems. In previous versions,
the MySQL-specific character, ' # ', was used.
SQL Options
SQL options are used to define exactly what information the export will contain. We
may want to see the structure, the data, or both. Selecting Structure generates the
section with CREATE queries, and selecting Data produces INSERT queries: