In most cases it is useful to have them, but not if the target server (where the
export file will be imported) is running a MySQL version older than 3.23.6,
which does not support backquotes.
Add CREATE PROCEDURE/FUNCTION: This includes in the export all
procedures and functions found in this database.
Add into comments: This adds information (in the form of SQL comments),
which cannot be directly imported, but which nonetheless is valuable and
human-readable table information. The amount of information here varies
depending on the relational system settings, (see Chapter 11). In fact, with an
activated relational system, we would get the following choices:
???
???
???
???
???
??? ???
???
??? ???
Chapter 7
[ 121 ]
Selecting Relations and MIME type would produce an additional section in the
structure export:
--
-- COMMENTS FOR TABLE 'book':
-- 'isbn'
-- 'book number'
-- 'page_count'
-- 'approximate'
-- 'author_id'
-- 'see author table'
--
--
-- MIME TYPES FOR TABLE 'book':
-- 'cover_photo'
-- 'image_jpeg'
-- 'date_released'
-- 'text_plain'
-- 'description'
-- 'text_plain'
--
-- RELATIONS FOR TABLE 'book':
-- 'author_id'
-- 'author' -> 'id'
--
Exporting Structure and Data
[ 122 ]
The options available in the Data section are:
Complete inserts: Generates the following export for the author table:
INSERT INTO 'author' ('id', 'name', 'phone')
VALUES (1, 'John Smith', '+01 445 789-1234');
INSERT INTO 'author' ('id', 'name', 'phone')
VALUES (2, 'Maria Sunshine', '+01 455 444-5683');
Notice that every column name is present in every statement.
Pages:
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130