MYSQL: Column count doesn't match value count at row 1 can't figure out -


i'm stumped have been playing awhile, i've set primary key allow nulls, i've tried removing fields, nothing works.

call create_login('username', 'passkey', 'key', 1, 1, 1); 

error code: 1136. column count doesn't match value count @ row 1 0.078 sec

create definer=`testdb`@`%` procedure `create_login`( _username varchar(15), _password varbinary(160), _salt varbinary(110), _priviledge tinyint(3), _workerid int, _empid int ) begin  insert login values (_username, _password, _salt, _workerid, _priviledge, curdate(), curdate(),  _empid);   end 

any appreciated i've tried quoting , unquoting nothings worked far. 6 input values, 6 supplied

edit: should add i've tried different values , such

your problem come insert query. maybe there 1 or several missing columns in insert. btw highly recommended specify column names in insert

for instance:

insert table_name (column1, column2, column3,...) values (value1, value2, value3,...) 

Comments

Popular posts from this blog

ios - iPhone/iPad different view orientations in different views , and apple approval process -

java Extracting Zip file -

C# WinForm - loading screen -