13.03.2013, 14:56
You can choose not to specify columns, but then you have to provide _all_ of them. So if there were id, name, password, then it'd be: "INSERT INTO `accounts` VALUES(null, '%s', '%s'). There is also insert set (like with update) syntax