mysql not enough arguments_Not enough arguments for format string mysql error

女爷i 2023-01-12 11:50 130阅读 0赞

When you have a large number of columns, it can be a challenge to make sure you have one %s for each column. There's an alternative syntax for INSERT that makes this easier.

Instead of this:

INSERT INTO ACTIVE\_PROPERTIES(Property\_ID, Reference\_Number,

Address\_Name, Address\_Number, Address\_Street, Address\_2, Address\_3,

Address\_4, Address\_Postcode, Owner\_Contact\_ID, Owner\_Name,

Owner\_Number\_Type\_1, Owner\_Contact\_Number\_1, Owner\_Number\_Type\_2,

Owner\_Contact\_Number\_2, Owner\_Number\_Type\_3, Owner\_Contact\_Number\_3,

Owner\_Email\_Address, Display\_Property\_Type, Property\_Type,

Property\_Style, Property\_Bedrooms, Property\_Bathrooms, Property\_Ensuites,

Property\_Toilets, Property\_Reception\_Rooms, Property\_Kitchens,

Floor\_Area\_Sq\_Ft, Acres, Rent, Rent\_Frequency, Furnished,

Next\_Available\_Date, Property\_Status, Office\_Name, Negotiator,

Date\_Created)

VALUES(%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s,

%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s,

%s, %s, %s, %s, %s)

Try the following, to make it easier to match up columns with %s parameters, so you don't miscount:

INSERT INTO ACTIVE\_PROPERTIES

SET Property\_ID = %s,

Reference\_Number = %s,

Address\_Name = %s,

Address\_Number = %s,

Address\_Street = %s,

Address\_2 = %s,

Address\_3 = %s,

Address\_4 = %s,

Address\_Postcode = %s,

Owner\_Contact\_ID = %s,

Owner\_Name = %s,

Owner\_Number\_Type\_1 = %s,

Owner\_Contact\_Number\_1 = %s,

Owner\_Number\_Type\_2 = %s,

Owner\_Contact\_Number\_2 = %s,

Owner\_Number\_Type\_3 = %s,

Owner\_Contact\_Number\_3 = %s,

Owner\_Email\_Address = %s,

Display\_Property\_Type = %s,

Property\_Type = %s,

Property\_Style = %s,

Property\_Bedrooms = %s,

Property\_Bathrooms = %s,

Property\_Ensuites = %s,

Property\_Toilets = %s,

Property\_Reception\_Rooms = %s,

Property\_Kitchens = %s,

Floor\_Area\_Sq\_Ft = %s,

Acres = %s,

Rent = %s,

Rent\_Frequency = %s,

Furnished = %s,

Next\_Available\_Date = %s,

Property\_Status = %s,

Office\_Name = %s,

Negotiator = %s,

Date\_Created = %s;

It's not standard SQL, but it's supported by MySQL. It does the same thing internally, it's just more convenient syntax, at least when you're inserting a single row at a time.

发表评论取消回复

表情：

评论列表（有 0 条评论，130人围观）

还没有评论，来说两句吧...

相关阅读

相关 mysql not enough arguments_Not enough arguments for format string mysql error

When you have a large number of columns, it can be a challenge to make sure you have one

女爷i/ 2023年01月12日 11:50/ 0 赞/ 131 阅读

相关 django.db.utils.ProgrammingError: not enough arguments for format string

django使用raw执行sql语句时报错 django.db.utils.ProgrammingError: not enough arguments for form

雨点打透心脏的1/2处/ 2022年09月16日 11:24/ 0 赞/ 162 阅读

相关【Java】解决Tomcat Could not reserve enough space for object heap

生产要发布系统，在执行./shutdown.sh命令之后，Tomcat抛出了`“Error occured during initialization of VM. Could

谁借莪１个温暖的怀抱￠/ 2022年08月09日 12:44/ 0 赞/ 205 阅读

相关 TypeError: not all arguments converted during string formatting

1、错误描述 >>> a=1; >>> b=1; >>> for i in range(1,21): print('121d %121d'

﹏ヽ暗。殇╰゛Y/ 2022年06月16日 06:52/ 0 赞/ 144 阅读

相关 lua拆分字符串not enough memory

--调用方法： --local str= "-6ciNeXFTlqy5Dcld8UPmsrcieJkmFJO4zDcaOP56YY$-$OPENTM207374

缺乏、安全感/ 2022年06月12日 14:07/ 0 赞/ 146 阅读

相关 HDU1036 Average is not Fast Enough!

Problem Description A relay is a race for two or more teams of runners. Each member of

本是古典何须时尚/ 2022年06月09日 13:12/ 0 赞/ 94 阅读

相关 elasticsearch Could not reserve enough space for object heap

最近需要使用elasticsearch，想在linux虚拟机上装一下试试，虚拟机总是联网出问题，于是在windows下装了一下。按照网上给的方法以及错误的解决方法（参

缺乏、安全感/ 2022年05月22日 03:29/ 0 赞/ 103 阅读

相关 Could not reserve enough space for object heap

win10 elasticsearch.bat闪退怎么搞？答：一般是有语法错误。你可用如下方法排查下 1、打开一个cmd 窗口（一般是Win+R，输入c

拼搏现实的明天。/ 2022年04月15日 07:00/ 0 赞/ 122 阅读

相关 Error occurred during initialization of VM Could not reserve enough space for object heap

maven 编译报错 D:\code\github\spark> set MAVEN_OPTS= -Xms2000m -Xmx2000m D:\c

╰+攻爆jí腚メ/ 2022年03月20日 13:22/ 0 赞/ 159 阅读

相关 WARNING: Not enough clusters for a 32 bit FAT!

在emmc上制作fat32分区做启动分区时出现这个警告，导致没法正常启动， root@am57xx-evm:/boot fdisk -l /dev/mmcblk1

朱雀/ 2021年12月12日 10:45/ 0 赞/ 223 阅读