sql_mode の履歴ソース(No.2)

• 履歴一覧
• 差分 を表示
• 現在との差分 を表示
• 履歴 を表示
• sql_mode へ行く。
  • 1 (2013-03-15 (金) 12:35:39)
  • 2 (2013-03-15 (金) 12:43:59)

[[FrontPage]]~
CONTENTS
#contents
----
Lastmodified　&lastmod;
----
*sql_mode [#fce423d3]
http://wiki.ispirer.org/sqlways/troubleshooting-guide/mysql/import/zero-date-not-accepted
 Welcome to the MySQL monitor.  Commands end with ; or \g.
 Your MySQL connection id is 38583
 Server version: 5.1.68-log FreeBSD port: mysql-server-5.1.68
 
 Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.
 
 Oracle is a registered trademark of Oracle Corporation and/or its
 affiliates. Other names may be trademarks of their respective
 owners.
 
 Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
 
 mysql> select @@sql_mode;
 +------------+
 | @@sql_mode |
 +------------+
 |            |
 +------------+
 1 row in set (0.00 sec)


 mysql> select @@sql_mode;
 +--------------------------------------------+
 | @@sql_mode                                 |
 +--------------------------------------------+
 | STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION |
 +--------------------------------------------+
 1 row in set (0.00 sec)


 mysql> set sql_mode='';
 Query OK, 0 rows affected (0.00 sec)
 
 mysql> select @@sql_mode;
 +------------+
 | @@sql_mode |
 +------------+
 |            |
 +------------+
 1 row in set (0.00 sec)
 
 mysql>

 root@g7:/usr/local/www/apache22/data/OP36B # /usr/local/etc/rc.d/mysql-server  restart
 Stopping mysql.
 Waiting for PIDS: 87807.
 Starting mysql.
 root@g7:/usr/local/www/apache22/data/OP36B #



----
総 access &counter(total);：本日 &counter(today);：昨日 &counter(yesterday);
#counter([total|today|yesterday]);