snowy19130140的博客

文章目录单个添加更新批量添加更新建表语句：DROP TABLE IF EXISTS `stock_discover`;CREATE TABLE `stock_discover` ( `code` char(6) NOT NULL, `index` int(11) unsigned NOT NULL DEFAULT '0', `name` varchar(20) NOT NULL,...

修改mysql文件中my.ini里的 sql-mode=”STRICT_ALL_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_ZERO_DATE,NO_ZERO_IN_DATE,NO_AUTO_CREATE_USER” 修改成sql-mode=”NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION”，然后重启mysql即可除了能解决在...

数据样本包含分组信息；create table t2 ( id int primary key, gid char, col1 int, col2 int);-- 插入数据insert into t2 values (1,'A',31,6),(2,'B',25,83),(3,'C',76,21),(4,'D',63,56),...

在使用用MySQL做数据的预处理，经常会用到group_concat函数。遇到 Warning: (1260, u’Row 13554 was cut by GROUP_CONCAT()’)，这是因为mysql的group_concat函数有最大长度，默认1024, 超过最大长度就会被截断掉并给出提示可以使用以下SQL进行查询SELECT @@global.group_concat_max_l...

1. 建表、插入测试数据CREATE TABLE `test` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(10) NOT NULL, `category_id` tinyint(3) unsigned NOT NULL DEFAULT '0', `date` timestamp NOT NULL...

向数据库中插入时报Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT.具体类似如下：Warning: (1592, u’Unsafe statement written to the binary log using statement form...