Running MySQL in ANSI Mode

Nasza ocena:

5
Wyświetleń: 532
Komentarze: 0
Notatek.pl

Pobierz ten dokument za darmo

Podgląd dokumentu
Running MySQL in ANSI Mode - strona 1

Fragment notatki:

Running MySQL in ANSI Mode
You can tell mysqld to run in ANSI mode with the --ansi [428] startup option. Running the server in
ANSI mode is the same as starting it with the following options:
--transaction-isolation=SERIALIZABLE --sql-mode=ANSI
You can achieve the same effect at runtime by executing these two statements:
SET GLOBAL TRANSACTION ISOLATION LEVEL SERIALIZABLE;
SET GLOBAL sql_mode = 'ANSI';
You can see that setting the sql_mode [557] system variable to 'ANSI' enables all SQL mode
options that are relevant for ANSI mode as follows:
mysql SET GLOBAL sql_mode='ANSI';
mysql SELECT @@global.sql_mode;
- 'REAL_AS_FLOAT,PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,ANSI'
Running the server in ANSI mode with --ansi [428] is not quite the same as setting the SQL mode
to 'ANSI'. The --ansi [428] option affects the SQL mode and also sets the transaction isolation
level. Setting the SQL mode to 'ANSI' has no effect on the isolation level.
... zobacz całą notatkę



Komentarze użytkowników (0)

Zaloguj się, aby dodać komentarz