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
Post a Comment