When the stored procedure was called, 19 parameters were passed, but the program mistakenly reported that 20 parameters were obtained. - Codes Helper - Programming Question Answer

When the stored procedure was called, 19 parameters were passed, but the program mistakenly reported that 20 parameters were obtained.

problem description

when calling the stored procedure, 19 parameters were passed, but the program mistakenly reported 20 parameters

the environmental background of the problems and what methods you have tried

related codes

/ / Please paste the code text below (do not replace the code with pictures)
background API:
var sql = "CALL pro05_cropsSave";
var parameter = [organ_id, cm_name, alternate_name, cm_class, cm_type, cm_pic, crops_step_id, cm_cycle, environment, cultivation, lunar_date, sowing_date, sow_cycle, picking_date, pic_cycle, land_type, cm_describe, oper_user, remark];

mysql stored procedure:
CREATE DEFINER= root @ localhost PROCEDURE pro05_cropsSave (IN p_organ_id > cm_name varchar (20), IN cm_name varchar (128), IN alternate_name varchar) IN lunar_date varchar (64), IN sowing_date date,IN sow_cycle int,IN picking_date > date,IN pic_cycle int,IN land_type varchar (1024), IN cm_describe varchar (1024), IN oper_user varchar)

`what result do you expect? What is the error message actually seen?`


 error message ER_SP_WRONG_NO_OF_ARGS: Incorrect number of arguments for PROCEDURE lgiot_agro_v20_test.pro05_cropsSave; expected 19, got 20


												
							
																								Node.js
																mysql
															
							
								Jul.06,2021


					
						
					
										
												Previous: Why did I write this addition didn't work?
												                		Next: When vue uses elementUI, to customize the scroll bar, there is a gap between the table fixed column and the scroll bar, how to solve it?
                							
					
						
					
															
						
														
								How does Sequelize get the primaryKey of a table
								 I want to find out how to change all the primaryKey, of a table ...
								
									
																														Vue.js
																				express
																				node.js
																				mysql
																				sequelize
																			
									
										Feb.28,2021
									
								
							
														
								Node about MySQL nested query
								
 Xiaobai asks for advice. My following code sent the stuname to the front end, and the front end also received it, but the back jumped to the page mainnav, so how does this stuname pass to mainnav? 
app.post(   login stulogin  ,function(req, res){       ...
								
									
																														Node.js
																				mysql
																			
									
										Mar.01,2021
									
								
							
														
								Mysql uses utf8 coding, can Chinese still be sorted by pinyin?
								

 I used knex, in the background to change that statement to knex version or knex 
 or directly support utf-8 statement query can also 

select * from tailor order by convert(province using gbk)
...
								
									
																														Node.js
																				mysql
																			
									
										Mar.03,2021
									
								
							
														
								Batch updates of mysql update in nodejs
								
 batch updates of mysql update in nodejs 
 is passed in an array, and the former affects the latter  for example, [id,num]  [[1jue 3], [2jue 5], [6je 8]] .
 SET num=? WHERE id=? 
...
								
									
																														Node.js
																				mysql
																			
									
										Mar.04,2021
									
								
							
														
								Express cannot connect to the mysql database
								
 login Code: 
 $.ajax({
                url: " login userlogin",
                data: {
                    username: $("-sharpusername").val(),
                    userpwd: $("-sharpuserpwd").val()
                },
     ...
								
									
																														Node.js
																				mysql
																				express
																			
									
										Mar.04,2021
									
								
							
														
								Nodejs queries empty data with mysql and returns true
								
 query has been encapsulated in promise. If the test is successful, you can get the existing data .
 but I want to query a row that does not exist (open_id =   zzz  ) 
 
:



 
 would like to ask the boss, is there any solution, I would like to thank you...
								
									
																														Node.js
																				mysql
																			
									
										Mar.05,2021
									
								
							
														
								The problem of node operation mysql querying the corresponding columns according to id
								 make a list of articles, and then enter the details according to the id of the article.  now I have a problem, that is, when my article list jumps to article details according to id, the article details get id and then look up the corresponding columns a...
								
									
																														Javascript
																				node.js
																				mysql
																			
									
										Mar.10,2021
									
								
							
														
								How do I close connection pooling created with the mysql module when the console ctrl+c shuts down express?
								 I need to do a game background, but I don  t know much about the back-end part, so I  d like to ask the following people.  I created the connection pool with the mysql module, and I see in the document that if you don  t call pool.end () to close the con...
								
									
																														Node.js
																				mysql
																				express
																			
									
										Mar.11,2021
									
								
							
														
								How does sequezlie bulkCreate get influence rows
								 bulkCreate (records, [options])-> Promise. < Array. < Instance > >  after setting the options.ignoreDuplicates option, instances of records array records will be returned regardless of whether they are created or ignored. How to get only the affected row...
								
									
																														Node.js
																				mysql
																				javascript
																			
									
										Mar.16,2021
									
								
							
														
								Mysql multi-table query 1267 error report
								
const books = await mysql(  books  )
                  .select(  books.*  ,  csessioninfo.user_info  )
                  .join(  csessioninfo  ,  books.openid  ,  csessioninfo.open_id  )
                     .orderBy(  id  ,  desc  )
 code:   ER_CANT_AGG...
								
									
																														Node.js
																				mysql
																				koa2
																			
									
										Mar.19,2021
									
								
							
														
								The fields in koa+mysql, database are underlined, how to convert the checked data into hump form
								
< H2 > as shown in figure <   H2 >
 for example, I want to convert the checked data  goods_id  to  goodsId   
 .
...
								
									
																														Javascript
																				java
																				node.js
																				mysql
																			
									
										Mar.21,2021
									
								
							
														
								There is only one result for node mysql connection query?
								
 now there are two tables posts and tags 
 A post in posts can have more than one tag 
 tags 
 


sql:
 
...
								
									
																														Node.js
																				mysql
																			
									
										Mar.22,2021
									
								
							
														
								How to abstract mysql dynamic parameter queries (no, one, multiple parameters)?
								
 problem description 
 on the basis of the general query connection.query (querySql,values,function () {}) of the mysql module in NODE.JS, how to abstract the mysql dynamic parameter query (no, one, multiple parameters)? 
 related codes 
 has uncondition...
								
									
																														Node.js
																				mysql
																			
									
										Mar.29,2021
									
								
							
														
								How to solve the problem of multi-table modification in nodejs sequelize framework?
								
< hr >
 how can this method be changed to sequelize syntax? Multiple table associations  urgent. 
makeupUpdateAccountInfo: function (data) {
        var companyCode = ""
        if (data && data.companyCode) {
            companyCode = ...
								
									
																														Sequelize
																				node.js
																				mysql
																			
									
										Apr.02,2021
									
								
							
														
								How do I store large numbers in a mysql database?
								 1. The company project has a functional requirement, which needs to store the number of gold coins in the game, and needs to do the gold coin ranking function.  2. If the total number of gold coins does not exceed 20, you can use the bigint field, but th...
								
									
																														Python
																				node.js
																				mysql
																				java
																				php
																			
									
										Jun.23,2021
									
								
							
														
								Mysql Error:ER_NOT_SUPPORTED_AUTH_MODE
								
 problem description 
 node version 8.9.2. The connection mysql8.0, shows that the connection was successful but an error was reported as   Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider u...
								
									
																														Node.js
																				mysql
																			
									
										Oct.31,2021
									
								
							
														
								About the problem of mySQL connection
								
 first of all, the system uses the manjaro (linux) system. I installed mySQL, in the project directory, but when I node timetrack_server.js the file, I made the following error: 
 home dema codeSpace studyNode testMySQL timetrack_server.js:49
        if ...
								
									
																														Javascript
																				node.js
																				mysql
																			
									
										Jan.31,2022


				
					
						
	
						
		css
		mysql
		arrays
		josn
		react
		html
		typescript
		webpack
		npm
		sass
		R
		objective-c
		.net
		sql-server
		jquery
		python-3.x
		angularjs
		django
		angular
		excel
		regex
		iphone
		ajax
		linux
		xml
		pandas
		vba
		spring
		database
		wordpress
		string
		wpf
		xcode
		windows
		bash
		postgresql
		oracle
		multithreading
		eclipse
		list
		firebase
		algorithm
		macos
		forms
		image
		scala
		visual-studio
		azure
		bootstrap
		spring-boot
		react-native
		python-2.7
		docker
		performance
		function
		winforms
		matlab
		powershell
		apache
		dataframe
		api
		sqlite
		numpy
		rest
		shell
		selenium
		flutter
		dart
		maven
		loops
		qt
		swing
		android-studio
		csv
		express
		file
		class
		tensorflow
		sorting
		codeigniter
		perl
	
						MySQL Query :  SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5 
 MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1e560a6-43e5a.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") 
 MySQL Errno : 1021 
 Message :  Disk full (/tmp/#sql-temptable-64f5-1e560a6-43e5a.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") 
Need Help?