I am a discord bot developer. I am trying to use MySQL for my discord bot. I am trying to save guild ids in my table. Guild ids rounding automatically when I post to table. Forexample my guild id is 837465019283745861. It is posting like 837465019283745900. I am using mysql module.
My Table:
CREATE TABLE guilds (
id INT PRIMARY KEY AUTO_INCREMENT,
guild_id BIGINT(18) NOT NULL);
My Post Code:
const guild = 837465019283745861;
connection.query('INSERT INTO guilds (guild_id) VALUES (?)', guild, function(error, results, fields) {
if (error) throw error;
console.log('Data sent!');
});
To solve this, add 'supportBigNumbers' to your MySQL con
Example:
const database = {
host: env.db_host,
port: env.db_port,
user: env.db_user,
password: env.db_password,
database: env.db_name,
supportBigNumbers: true // BigInt not rounded now
};
See more on: https://www.npmjs.com/package/mysql#getting-the-id-of-an-inserted-row