How to write a basic MySQL-MariaDB query that has a WHERE on a property within a JSON data-type field?
JSON field: "result", key: "numaralar"
Something like this, I tried it doesn't work:
'SELECT * ...
I am trying to throw SQL information in JSON format from the form. I saved the information in the SQL area, but it saves it in the form of SQL escape. When I shoot with API, I can't use it as I want. ...
I want to build a MariaDB server.
I am researching DB performance according to CPU specification before server purchase.
Are there any benefits to gaining as CPU Cache changes from 8MB to 12MB?
I'm modelling a basic airport management system SQL database using MariaDB. I want to create an event "LastCall" that adds a message to a table every time a flight is departing in exactly 30 minutes.
So I am trying to set up a simple WP page on my AWS EC2 instance. I have one instance which has Wordpress, Apache and php. I have another instance which has a Maria DB set up.
Here is the configs ...
I'm creating a basic airport management system SQL database using MariaDB. I want to create a procedure containing a transaction that makes sure that:
Whenever a passenger is moved to another flight, ...
I try to connect on php to my Maria Database from my Mac to my server in the same network.
What I Tried:
I define a user with the same name and password in the Maria DB like I am active on my Mac.
The goals is a PKI running in a docker, send commands via a REST interface, save the results in a MariaDB table (external running docker).
I found the following docker
I have a japanese dataset (csv) with a japanese encoding.
The documentation says it is: JIS X0208 (edition 1983)
I tried to import the dataset via "LOAD DATA LOCAL INFILE...",
with these CHARACTER ...
I am stuck for two days. how to run MySQL server to my host IP address from the localhost.
Currently, Mysql server start on localhost but instead of localhost I have run MySQL server to my host IP ...
the complete code:
Everything says XAMPP has MariaDB now, but using the latest download link it only has MySQL. Am I missing something? For my needs I'd rather use MariaDB, but can make due with MySQL if need be, but it ...
I configured 3 drives on my machine: 1 for data files, 1 for transaction logs files, and 1 for temporary files.
I would like to initialize MariaDB at its first run straight after yum installation. ...
I have a query running usually within few minutes which becomes extremely slow after a while (about a week) taking then days! to execute. The query just stays in 'Sending data' and CPU use is 100%. ...
Browsed through other similar questions have not helped, I'm creating two simple tables and this error pops up, have no idea where it's gone wrong:
create table department (
When I restart the mysql server in galera cluster, It show erros and stop, start continueouly.
the Cluster has 3 nodes.
and one node is so busy for traffic. so i restart the node temporarly.
But it ...
I would like to get the monthly sum of (total_medical_bills,non_payment,card_amount_received) and the monthly sum of cash_receipt_row(approval_number) from the hospital_payment_data table. What should ...
I'm sorry to open one more of those 'can't connect to my database' questions, but after searching for hours I just don't get it.
I want a dockerized database to be used by the (non dockerized) ...
So i was trying to install mysql on my centos7 machine...i did the following in the shell
$ yum install mysql-server
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* base: ...
Webinaris is inserting Date and Time into a MariaDB SQL Table via a Mautic Fomular. So I have two fields with date and time.
I need a new field where date and time are merged to a new field.
| postid | type |parentid| created |
|123 | A | 456 |2020-03-26 01:...
I have a MariaDB database, that has 1 main table where customer info is put into. I then have 28 other tables that have menu options for the main table for the web form side. Each of the menu tables, ...
I'm currently working on writing a web scraper for a website called Mountain Project and have come across an issue while inserting items into a MySQL (MariaDB) database.
The basic flow of my crawler ...
I recently tried to migrate a database from an old Debian 8, MariaDB 10.1 server to a new Debian 10, MariaDB 10.4 but met with this nasty error
ERROR 1054 Unknown column 'pusername' in 'field list'...
I'm writing a Spring application that gets data from a MariaDB server and does stuff that I haven't implemented yet because the application is getting wrong data from the server:
As you can see on ...
I'm trying to turn two count queries with date conditions (the ones below) into one query.
SELECT COUNT(*) as yesterday FROM orders WHERE DATE(timedate) = DATE(NOW() - INTERVAL 1 DAY)
An error occurs when a query is sent as follows: How should I fix it?
SELECT COUNT(*) as total,
SUM(cash_amount_received) AS sum_cash_amount_received,
I was on the "hospital_payment_data" table.
I want to call up the data of the number of data, the cache_account_received sum, and the total_medical_bills sum, and then bring up the mount sum value ...
Ho do we restore Data from Dump Files ?
Now basically I already have created the database with the tables and its data . But I want to replace those data from the dump file for example the dumpfile ...
Classic problem: I have many many client applications (native and web apps) connected to a system, all of which need to get updates in real-time as information changes. Most of the information changes ...
I just want to know how to fix this, or why MariaDB server keeps me returning an error. I just install the database, create a user, a new schema, I'm pointing to that database with use database ...
I get an error when i try to run this query,
heck the manual that corresponds to your MariaDB server version....
please check whats wrong and how to fix that?
i have used this code to select 3 tables ...
I am running a Laravel environment on my machine that is running off Windows 10 OS. The script for the Login page is written in Vue.js.
Using Xampp server for the back-end
Running MySQL through ...
i am using xamp,mysql and laravel 6 and using spatie media library for image uploading and i got stuck at migrating files
my errors are
PDOException::("SQLSTATE: Syntax error or access ...
i have the following code i try to execute
CREATE TABLE ShoppingCentreShop (
**CONSTRAINT CHK_Category CHECK ( ...
I'm an Mechanical Engineer with a little experience in C and C++ languages and no experience in Python or SQL labguages.
Recently, I started to work on stock prices analyses in order to optimise my ...
MariaDB version 10.4.10.
I have a stock scraper script that fetches stock data every hour and inserts it into a MySQL database. I want a way to get price difference for each stock between, for ...
I don't know the no. of columns in a table. I can get the column listing from query like this
$data = DB::getSchemaBuilder()->getColumnListing(table);
Now, I want to insert values into this table ...
How to use omnidb to edit triggers using mariadb caooection?
I found that PostgreSQL has no problem access trigger, but is there any possibility to access trigger in connection of mariadb or mysql??
I have a query in MySQL like this:
(sum((a.Precio_sinIVA*a.Cantidad)-(a.Descuento/(1+a.IVA_Tipo)))) AS SUM,
(1-((b.Descuento_Cliente * 1.0)/100.00)) As DESCUENT,
I confess I'm thoroughly out of my depth but have to find help from somewhere as the developer has had his money and is ignoring calls and emails. Before he disappeared off the map he said the ...
I would like to ask on how to Inplace Upgrade of Mariadb 5.2 going to mariadb 10.2 in Window Server 2016 Standard.
I have a problem, with every employee in the 'employee' table I need to call a SELECT query in the 'KPI' table. I use Cursor to read each value in the table 'employee':
CREATE PROCEDURE ...
Having difficulty connecting to my local mariaDB server. Everything seems to be in order but I'm getting a few odd exceptions when I try to access it. My only guess is the statement:
"property file '...
I want to insert blob data in mariaDB using node js,I am using HeidiSQL to interact with mariaDB.
'users' table have two attributes 'user_email' and 'profile_photo'.
I found the ...
I am attempting to build an insert statement within a C++ application to push records to a MariaDB server, but am getting a generic error back from the database citing MySQL syntax errors.
You have ...
I've got a Raspberry Pi with raspbian and PHP and MARIAB installed on in. Its a homemade server running apache2. Ive got all the ports I need open (80TCP, 22TCP, 3306TCP) and I edited all config files ...
I used Kibana for designing reports on web. Kibana uses Elasticsearch as database.
Do you know if there are other software alternatives in the market besides kibana where I can design reports on web ...
I have a node.js application running on my server (not in a docker). I want it to connect to a mariadb docker that is running on the same server.
I setup the mariadb docker with the following command: ...
I searched for almost 1h to find what I'm searching for but I didn't find something that helped me with what I am doing.
I want to update a column if is equal to a value with the clause WHERE... for ...