bingVling的博客

mysql.ini1. sql-mode=""   #sql-mode="STRICT_ALL_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_ZERO_DATE,NO_ZERO_IN_DATE,NO_AUTO_CREATE_USER"   查询select @@sql_mode;    sql_mode模式   mysql数据库的中有一个环境变量sq

sqll执行顺序一、sql执行顺序 (1)from (3) join (2) on (4) where (5)group by(使用select中的别名)(6) avg,sum.... (7)having (8) select (9) distinct (10) order by

ALTER TABLE `gb_send_emails`ADD INDEX `aa` (`email_template_id`, `email_gateway_id`, `emails`) ;create index status_requiresendtime on gb_send_emails (status, require_send_time);