Stack Overflow
Stack Overflow

Questions tagged [mariasql]

A node.js binding to MariaDB's non-blocking (MySQL-compatible) client library

mariasql is a node.js binding to the non-blocking client library provided with MariaDB. It is compatible with MySQL.

This binding is different from other libmysqlclient bindings in that it uses the non-blocking functions available in MariaDB's client library.

Install it with the npm package installer:

npm install mariasql

The source code is located at github:node-mariasql.

References

143 questions
1
vote
1 answer

Why its mysqld error occurs during Mariabackup

The error message is shown below. Using server version 10.4.8-MariaDB-log mariabackup based on MariaDB server 10.4.11-MariaDB Linux (x86_64) [00] 2020-01-11 11:05:41 uses posix_fadvise(). [00] 2020-01-11 11:05:41 cd to /home/data/mysql/ [00]…
김형규
  • 21
  • 2
1
vote
2 answers

SELECT game_co WHERE they've never developed a game for PS4

I have a MariaDB SQL table where I need to find out which game company has never developed a game for a specific console. Some game_co are PC & Xbox only and have never developed on PS4. Some companies have developed multiple titles on all…
Lonchenzo
  • 51
  • 6
1
vote
0 answers

Recovering Win10 from restore point deletes data but database and table remains in MariaDB

I put MariaDB in ProgramData on Windows 10, create a system restore point, create a database in MariaDB, fill the database and roll back to the restore point, the database remains, but all the tables are empty, they open with an error table doesn't…
Boris novikov
  • 11
  • 1
1
vote
1 answer

MySQL FIND_IN_SET function with special character not working

I have a stored procedure: CREATE PROCEDURE MyDB.`tag_quicktrend`( IN taglist TEXT ) BEGIN SELECT * FROM taginfo WHERE FIND_IN_SET(tagname,taglist); END; When I call SP: call sp_chart_band_tag_quicktrend('YH05_한글') it return correct…
Hien Nguyen
  • 24,551
  • 7
  • 52
  • 62
1
vote
4 answers

MySQL server version 10.3.9-MariaDB can not query text has single quote

I have a MySQL database that has a filed TagName with value ~!@#$%^&*()_+|}{":?><./';[]\=-` I try the query select TagName from taginfo where TagName like '%@#$%'; It show data with tagname contain quote character. But I query with = operator and…
Hien Nguyen
  • 24,551
  • 7
  • 52
  • 62
1
vote
1 answer

why is there error 1064 in my script when i executed it

MySQL Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') ENGINE = InnoDB' at line 7 CREATE TABLE IF NOT EXISTS `game_review`.`users` ( …
kovan chew
  • 25
  • 4
1
vote
0 answers

while doing alter on a table to add column we are getting timing out error via flyway

we are using flyway to do schema changes which is on MARIA DATABASE. while doing alter on a table we are getting timing out error via flyway. Alter table is just adding a column. this script is executing via flyway on spring boot application.…
ashutosh tiwari
  • 51
  • 1
  • 5
1
vote
3 answers

Ignore unique key while updating some rows (mariaDB)

I have the following table (mariaDB): +----+--------------+-------------+-------------+ | id | content_type | sort_number | document_id | +----+--------------+-------------+-------------+ | 1 | text | 1 | 1 | | 2 |…
Nio
  • 497
  • 3
  • 6
  • 16
1
vote
0 answers

mySQL Pivot/merge/move rows into columns based on two column ids

I have a scenario where I am trying to take data from being long to being wide. (using MariaDB 10.2 & HeidiSQL 9.4 on Windows) Basically, I am trying to get every 'id' to have a single row. Each 'id" may have one or more 'sqn' (which are always…
Mark S
  • 11
  • 3
1
vote
1 answer

How to see a log of query string in (Maria SQL + Node.js)?

I'm using Node.js, Express and Maria. q = `SELECT * FROM TEST WHERE id=?`; maria.query(q,[id],function (err, rows) { if (err) throw err; //I want to see completed query string. }); Finally, I want to…
user8694522
1
vote
0 answers

Bulk Insert with Mariasql Node js

I want to perform bulk insert operation using Mariasql Node Js module, but it is showing error "Column count dosen't match value count at Row 1" Below is my code : var queryObj= [["Test1","false"],["Test2","true"]] mariaDb.query("INSERT INTO apps…
Ankit Dwivedi
  • 41
  • 5
1
vote
3 answers

MariaDB ibdata1 file cannot be written

I am using MariaDB for windows. It is stange, all worked before I changed the root-password with the commands USER 'root'@'localhost' IDENTIFIED BY 'password'; and SET PASSWORD FOR 'root'@'localhost' = PASSWORD('password'); (password is just a…
marius
  • 1,118
  • 1
  • 18
  • 38
1
vote
0 answers

Mariasql with nodejs not working

I did: var MariaSQLClient = require('mariasql'); var maria_connection = new MariaSQLClient({ host: '127.0.0.1', user: 'root', password: 'root', db: 'db1' }) But when i check whether it is connected or not…
Jaswinder
  • 1,455
  • 14
  • 27
1
vote
0 answers

advantage of npm mariasql over mysqljs

i see that MariaDB has its own npm package. is there any advantage(s)/disadvantage(s) of using this one over the older mysqljs package? i would think the two could be used interchangeably, but that just a guess. personally i have become a fan of…
edwardsmarkf
  • 1,387
  • 2
  • 16
  • 31
1
vote
1 answer

Connect ASP.NET to Amazon RDS MariaDB

Preface: I have already and can connect to the respective databases in Amazon RDS from MySQL Workbench hence rendering my username, instance url, port number as well as password to be correct. I am creating an online application for ASP.NET and need…
Guo Hong Lim
  • 1,690
  • 3
  • 13
  • 20
1 2
3
…
9 10