node-mysql2
node-mysql2 copied to clipboard
sidorares
:zap: fast mysqljs/mysql compatible mysql driver for node.js
Given the following example ```js import mysql from 'mysql2/promise' import fs from 'fs' class Test { vendorProperties = { "multipleStatements":true ,"typeCast":true ,"supportBigNumbers":true ,"bigNumberStrings":true ,"dateStrings":true ,"trace":true ,"user":"root" ,"password": "oracle" ,"host":"yadamu-db1" ,"database":"sys"...
Migrating from mysql to mysql2. Attempting to use INFILE LOCAL to load a file into a staging table Code ```js import mysql from 'mysql2/promise' import fs from 'fs' class Test...
mysql2 ignores charset opt specified on pool options, while it works perfectly with mysql lib mysql.createPool({ ... charset : 'latin1', -> ignored });
Given the following code ```js import mysql from 'mysql2' import fs from 'fs' class Test { vendorProperties = { "multipleStatements":true ,"typeCast":true ,"supportBigNumbers":true ,"bigNumberStrings":true ,"dateStrings":true ,"trace":true ,"user":"root" ,"password": "oracle" ,"host":"yadamu-db1" ,"database":"sys"...
What I did: 1. Set up [mariadb:5.5](https://hub.docker.com/_/mariadb) in Docker on port 3306, create database `test` with `GRANT ALL` to `root` etc. 1. `npm init; npm add mysql2` 1. Paste [the...
How can I use question mark as literal in query? for example ```(LOCATE('?', REVERSE (url), 1)``` I want to use it as real `?` string, not a parameter
Hi, I recently migrated from mysql to mysql2. I have a column of type decimal(2,1), with possible values 0, 1.5, and 2. After moving to mysql2 noticed that however I...
Hi! I found out that I am getting `Access denied` error when I try to authenticate with `sha256_password` on `MySQL v8.0.35-27`, but if I authorize via Linux with `mysql-client` library...
Hi! I'm building a Lambda function with Drizzle ORM (also tested with TypeORM) and I'm not sure if this is the "normal" operation. Here is the problem: My application starts...
Hello, I'm encountering a connection timeout issue on Ubuntu, the exact same code works flawlessly on Windows I'm new to ExpressJS and am trying to create an API using mysql2...
