向MYSQL中安插数据不成功
程序员文章站
2022-06-15 17:54:23
...
向MYSQL中插入数据不成功
报错内容:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 't produce ultraviolet light, make the ring 6. Its become more clean and comfort' at line 8
ECHO那对数据库插入数据的语句内容如下:
经过测试,应该是re_mark 字段出了问题,因为我尝试对这个字段插入比较少的字数时,是可以成功的。
(re_mark字段的类型定义是:... re_mark text,....
------解决方案--------------------
在论坛的加亮的SQL代码模式下,字符串应呈现红色,而你对应 re_mark 的部分却是五彩缤纷
观察红色部分结束的地方 LED don't ,很显然那个“'”么有做转义处理
既然你没有遵守 SQL 指令的书写约定,那么只有自己品尝违规的后果了
------解决方案--------------------
报错内容:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 't produce ultraviolet light, make the ring 6. Its become more clean and comfort' at line 8
ECHO那对数据库插入数据的语句内容如下:
经过测试,应该是re_mark 字段出了问题,因为我尝试对这个字段插入比较少的字数时,是可以成功的。
(re_mark字段的类型定义是:... re_mark text,....
- SQL code
insert into product ( p_name,p_class,p_model,re_mark,pic ) values ( '大幅度反对','大幅度反对','ddfdf','1. Energy saving: 70% energy than common fluorescent lamp; 2. The green environmental protection: LED tube no ultraviolet, such as infrared no radiation and contains no mercury and other harmful substances; 3. Long life: LED tube normal use for 50000 hours; 4. No stroboscopic: LED constant current work, effectively reduce LED light failure, start fast, no flash, protect eyes; 5. Reduce mosquito: different from other light source ultraviolet attract a mosquito, LED don't produce ultraviolet light, make the ring 6. Its become more clean and comfortable; 7. Color is rich: make full use of the advantage of rich color LED production various emitting light colors tubes; 8. Use chip Epistar from * , luminous efficiency is the highest; 9. Shell with 1/2 aluminium, 1/2 PC material, circuit boards use high strength fiber board, combined with compact structure and assembly process, so that only the tube heat sex greatly improved, ensure that LED work in low temperature and try to minimize the LED light failure; 10.The application places: office buildings,factories,shopping malls, schools, public, indoor lighting and colour, such as home decoration and through the CE and ROHS the authentication.', 'upfiles/CR-kNgqQmYmuw.jpg' )
------解决方案--------------------
在论坛的加亮的SQL代码模式下,字符串应呈现红色,而你对应 re_mark 的部分却是五彩缤纷
观察红色部分结束的地方 LED don't ,很显然那个“'”么有做转义处理
既然你没有遵守 SQL 指令的书写约定,那么只有自己品尝违规的后果了
------解决方案--------------------
相关文章
相关视频
上一篇: web.py 数据库操作指南
推荐阅读
-
在MySQL中同时查找两张表中的数据的示例_MySQL
-
将Mysql数据库迁移到Windows Azure上的SQL database中
-
mysql从某表中查询数据插入到另一表的处理_MySQL
-
Centos中安装多个mysql数据的配置实例_MySQL
-
powerdesigner中实现PDM到MYSQl数据库的转换_MySQL
-
mysql-请问:用java代码把不同的excel形式加载到MySQL数据库中(循环判断空就停止)?谢谢!
-
浅谈MySQL数据库中如何解决分组统计的问题_MySQL
-
mysql中group by留下的数据是哪一条
-
MySQL中基本操作(数据库创建,修改,删除,数据表创建,修改,
-
从数据库中随机抽N条记录_MySQL