mysql> desc test; +--------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------+--------------+------+-----+---------+----------------+ | id | int(11) | NO | PRI | NULL | auto_increment | | number | decimal(4,2) | NO | | NULL | | +--------+--------------+------+-----+---------+----------------+ 2 rows 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> select * from test; Empty set (0.00 sec) mysql> insert into test(id,number) value(NULL,100); ERROR 1264 (22003): Out of range value for column 'number' at row 1 mysql> SET SESSION sql_mode='NO_ENGINE_SUBSTITUTION'; Query OK, 0 rows affected (0.00 sec) mysql> insert into test(id,number) value(NULL,100); Query OK, 1 row affected, 1 warning (0.00 sec) mysql> select * from test; +----+--------+ | id | number | +----+--------+ | 1 | 99.99 | +----+--------+ 1 row in set (0.00 sec)
1 、本科及以上学历，2 年以上开发经验，熟练使用 Laravel 框架；（重点看 Laravel 和 vue 的熟练度） 2 、熟悉 Linux 开发环境、shell 、python 脚本、Nginx 等 Web 服务器的配置及优化； 3 、熟悉 MySQL 数据库，具备一定的优化经验，掌握 MySQL 集群、分库、分表...