3.0 10
versions 9-12
views 266
wildcard searching 155
Windows title configuration 45
primary key 70
Print view, phpMyAdmin
about 229
database Print view 229
selective database Print view 230
table Print view 230
privileges
global privileges 285
superuser privileges 285
user privileges, editing 286
procedures, MySQL 5.0
creating 271
exporting 274
manipulating 272, 273
testing 272
Q
queries
editing 200
multi-statement queries 200-202
multi-table query generator 207
query window
about 63, 197, 198
garbage collection 200
options 198
query, editing 200
synchronization 198
R
recode module
data recoding 254
relational MySQL
about 171
InnoDB storage engine 172
relation view
about 177, 178
column-commenting 192, 193
display field, about 179
foreign key system, InnoDB 180, 181
InnoDB storage engine 180-183
phpMyAdmin, internal relation view 178
relation, about 178
right panel, phpMyAdmin
about 43, 57
database view 59, 60
default server page 62
Home page 44, 58, 59
icons, for home page and menu tabs 62
server view 62
table view 61
views 44
S
Save as file sub-panel, database export
about 123
character set choice 125
compression 124
File name template 123
searching data
single-table search 151
security, phpMyAdmin
database list, restricting 40
directory-level protection 37, 38
in-transit data, protecting 41
IP-based access control 38
various levels 37
selective exports
about 134
exporting and checkboxes 135
partial query results, exporting 134
server specific configuration, phpMyAdmin
about 28
[ 316 ]
compress configuration 30
config authentication type 30, 31
connect_type 29
extension 29
MySQL, extension 29
PersistentConnections 29
port 29
socket 29
SET field 103
single-table search
about 151
display order 153, 154
display fields, selecting 153, 154
distinct results, obtaining 158
logical operators used 157
multiple criteria for same query 157
phpMyAdmin used 151
print view 155
query by example, searching 154
results, sorting 153, 154
search sub-page, entering 152
where clause used 157
wildcard searching 155
SQL
files, importing 142, 143
history, database-based 199
history, Session-based 199
LIKE operator 155
query box 195
query window 197
upload directory 148
Validator 203
SQL and CSV formats, comparing 143
SQL format, database export
about 117, 119
data, SQL options 122, 123
structure, SQL options 121
SQL query box
about 195
database view 196
fields selector 197
table view 196
SQL Validator
about 203
accessing 204
configuring 204
enabling 204
Mimer SQL Validator 203
non standard-conforming queries 205
reports 204
standard-conforming queries 204
system requirements 203
support, phpMyAdmin
bug tracker 305
FAQ 304
help forums 304
home page 304
reading answers 304
SourceForge account, creating 304
support tracker 305
thread title, choosing 304
T
table
additional table, creating 83, 84
appending data to table 167
attributes 162
copy operation 166
data insertion, manually 73, 74
deleting 94
maintenance 162
move operation 166
primary key 70
renaming 166
table, creating
about 68
additional table 83, 84
field names 70
fields, choosing 68
first table 68-71
index, adding to fields 71
table names 69
VARCHAR type 70
table attributes
about 162
auto-increment, table option 166
changing 163
checksum, table option 165
delay_key_write, table option 166
other attributes 165
pack_keys, table option 165
[ 317 ]
settings 163
table comments attribute 164
table options 165
table order attribute 164, 165
table storage engine 163
table type attribute 163
table exports
about 133
split-file export 133
table maintenance
about 162
analyze table 162
check table 162
defragment table 162
flush table 162
optimize table 162
repair table 162
table operations
appending data to table 167
copy 166
move 166
mutiple table operations 167
rename 166
table, deleting 94
table structure manipulation
about 97
ENUM field, adding 104
field, adding 97, 98
field attributes, editing 99
horizontal mode 98
vertical mode 98
table view, SQL query box
clicking into query box 197
fields selector 197
themes, phpMyAdmin
about 48
configuring 48
selecting 49
TIMESTAMP field
about 105
options 107
transformation
about 239
clickable thumbnail 243, 244
date, formatting 244
download link 248
examples 243
external applications 249, 250
hexadecimal representation 248, 249
in cell sorting, external applications 250
links from text 245
link to an image 244
original formatting, preserving 247
parts of a text, displaying 247, 248
text/plain imagelink 246, 247
text/plain link 245
triggers, MySQL 5.
Pages:
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277