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

KEY 'by_title' ('title'(30)),
KEY 'author_id' ('author_id','language'),
FULLTEXT KEY 'description' ('description')
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- COMMENTS FOR TABLE 'books':
-- 'isbn'
-- 'book number'
-- 'page_count'
-- 'approximate'
-- 'author_id'
-- 'see authors table'
--

--
-- MIME TYPES FOR TABLE 'books':
-- 'cover_photo'
-- 'image_jpeg'
-- 'date_released'
-- 'text_plain'
-- 'description'
-- 'text_plain'
----
-- RELATIONS FOR TABLE 'books':
-- 'author_id'
-- 'authors' -> 'author_id'
--

The options available in the Data section are:

• Complete inserts : Generates the following export for the authors table:

INSERT INTO 'authors' ('author_id', 'author_name', 'phone')
VALUES (1, 'John Smith', '+01 445 789-1234');
INSERT INTO 'authors' ('author_id', 'author_name', 'phone')
VALUES (2, 'Maria Sunshine', '+01 455 444-5683');

Notice that every column name is present in every statement. The resulting
file is bigger, but will prove more portable on various SQL systems, with the
added benefit of being better documented.
Extended inserts : Packs the whole table data into a single INSERT statement:
INSERT INTO 'authors' VALUES (1, 'John Smith',
'+01 445 789-1234'), (2, 'Maria Sunshine', '+01 455 444-5683');

•