© Éditions Eyrolles
395
Index
Apprendre SQL avec MySQL
SERIAL 28
SET 29, 47, 107
SET AUTOCOMMIT 228
SET FOREIGN_KEY_CHECKS 75, 77
setAutoCommit 295
setFetchDirection 304
setMaxRows 297
setNull 316
setSavepoint 321
setter methods 296
SHOW 190
COLUMNS 204
CREATE DATABASE 204
CREATE TABLE 204
CREATE VIEW 189
DATABASES 204
ENGINES 204
ERRORS 204, 239
GRANTS 204
GRANTS FOR 165
INDEX 204
PRIVILEGES 204
TABLE STATUS 204
TABLES 204
TRIGGERS 204
Show_db_priv 161
Show_view_priv 161
Shutdown_priv 163
SIGN 100
silent 13
SIN 100
SINH 100
skip-column-names 13
SLEEP() 232
SMALLINT 27
SOUNDEX 98
source 15
sous-interrogation 133
dans le FROM 137
synchronisée 137
sous-programme 210
SQL dynamique 278
SQL SECURITY 235
SQL_PATH 195
SQL2 1
SQL3 1
SQLEXCEPTION 250
SQLException 322
SQLSTATE 249
SQLWARNING 249
SQRT 100
Statement 297
STATISTICS 194
STDDEV 110
stored procedures 233
stored routines 233
STR_TO_DATE 53, 102
SUBDATE 102
SUBSTR 98
SUBTIME 102
SUM 110
SUPER 263, 278
Super_priv 163
supportsSavepoints 315
supportsTransactions 315
SYSDATE 28, 88, 102
T
table 2, 19
dominante 128
fils 56
key preserved 184
père 56
subordonnée 128
TEMPORARY 19
TABLE_COLLATION 196
TABLE_COMMENT 196
TABLE_CONSTRAINTS 194, 198
TABLE_NAME 193
Table_name 168
Table_priv 168
TABLE_PRIVILEGES 194, 202
TABLE_ROWS 196
TABLE_SCHEMA 193, 202
TABLE_TYPE 195
TABLES 195
tables_priv 159, 168