Debug: SQL Error 1 column(s)








INSERT INTO `users`(`id`, `userid`, `password`) VALUES (10, 'aa', 'abc'), (11, 'bb', 'abc'), (12, 'cc', 'abc')

Remove 2 brackets after values

The wrong one is

INSERT INTO `users`(`id`, `userid`, `password`) VALUES ( (10, 'aa', 'abc'), (11, 'bb', 'abc'), (12, 'cc', 'abc') )

To insert more values with Python use for loop

https://stackoverflow.com/questions/14011160/how-to-use-python-mysqldb-to-insert-many-rows-at-once