p7, Dir.: Input, Type: adBSTR, Size: 3, Value: "qqq", Precision: 0, NumericScale: 0]

 p7, Dir.: Input, Type: adBSTR, Size: 3, Value: "qqq", Precision: 0, NumericScale: 0]
Traceback (most recent call last):
File "<string>", line 726, in _execute_command
File "<COMObject ADODB.Command>", line 3, in Execute
File "C:\Program Files (x86)\ShadowBot\shadowbot-5.10.20\python\lib\site-packages\win32com\client\dynamic.py", line 287, in _ApplyTypes_
result = self._oleobj_.InvokeTypes(*(dispid, LCID, wFlags, retType, argTypes) + args)
pywintypes.com_error: (-2147352567, '发生意外。', (0, 'Microsoft OLE DB Provider for ODBC Drivers', "[MySQL][ODBC 8.0(a) Driver][mysqld-8.0.32]Incorrect datetime value: '3.000000000' for function str_to_date", None, 0, -2147467259), None)

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "C:\Program Files (x86)\ShadowBot\shadowbot-5.10.20\python\lib\runpy.py", line 193, in _run_module_as_main
"__main__", mod_spec)
File "C:\Program Files (x86)\ShadowBot\shadowbot-5.10.20\python\lib\runpy.py", line 85, in _run_code
exec(code, run_globals)
File "C:\Program Files (x86)\ShadowBot\shadowbot-5.10.20\python\lib\site-packages\xbot_interpreter.py", line 87, in <module>
main()
File "C:\Program Files (x86)\ShadowBot\shadowbot-5.10.20\python\lib\site-packages\xbot_interpreter.py", line 47, in main
try:
File "C:\Users\Administrator\AppData\Local\ShadowBot\users\71458235767644161\apps\02087038-866a-42ee-9e7d-5c5793e54f24\xbot_robot\main.py", line 46, in main
xbot_visual.database.batch_insert(connect_way="database", database=database, conn_str=None, sql="insert into sea_price_maersk_every", data=excel_data, _block=("main", 38, "数据库批量插入数据"))
File "<string>", line 89, in wrapper
File "<string>", line 84, in wrapper
File "<string>", line 64, in batch_insert
File "<string>", line 45, in exec_many
File "<string>", line 70, in exec_many
File "<string>", line 932, in executemany
File "<string>", line 919, in execute
File "<string>", line 734, in _execute_command
File "<string>", line 607, in _raiseCursorError
File "<string>", line 57, in standardErrorHandler
xbot.adoapi.apibase.DatabaseError: (-2147352567, '发生意外。', (0, 'Microsoft OLE DB Provider for ODBC Drivers', "[MySQL][ODBC 8.0(a) Driver][mysqld-8.0.32]Incorrect datetime value: '3.000000000' for function str_to_date", None, 0, -2147467259), None)
Command:
insert into sea_price_maersk_every values (?,?,?,?,?,?,?,?)
Parameters:
[Name: p0, Dir.: Input, Type: adDouble, Size: 0, Value: "1.0", Precision: 0, NumericScale: 0
Name: p1, Dir.: Input, Type: adDouble, Size: 0, Value: "8.0", Precision: 0, NumericScale: 0
Name: p2, Dir.: Input, Type: adDouble, Size: 0, Value: "3.0", Precision: 0, NumericScale: 0
Name: p3, Dir.: Input, Type: adDouble, Size: 0, Value: "4.0", Precision: 0, NumericScale: 0
Name: p4, Dir.: Input, Type: adDouble, Size: 0, Value: "5.0", Precision: 0, NumericScale: 0
Name: p5, Dir.: Input, Type: adDouble, Size: 0, Value: "6.0", Precision: 0, NumericScale: 0
Name: p6, Dir.: Input, Type: adDouble, Size: 0, Value: "7.0", Precision: 0, NumericScale: 0
Name: p7, Dir.: Input, Type: adBSTR, Size: 3, Value: "qqq", Precision: 0, NumericScale: 0]

问题描述：insert into sea_price_maersk_every VALUES (1,7,3,4,5,6,7,'qqq')

在sql里写就没问题，完全可以

如果用影刀的写入数据库命令：insert into sea_price_maersk_every，就会报错，无法写入，数据都是一样的，为什么会报错