Mariadb Questions

I am somewhat surprised to see that jdbc allows me to transparently select from a table in a "foreign" database, on the same dbms, for

I am essentially trying to return the result of a subquery in a field of my outer query like so: select field1, field2, field8 =

I have a table with records of orders by customers and a table with dates from jan 2022 to 10 years. i wanted to get all numbers of customers made

Database columns image update `agentstats` set

This is my first table migration file : public function up() { schema::create('produits', function (blueprint $table) {

I have the following table image of database in use i want

Sports_games table ========================================================================== | game_id | team_id

My table is as follows: date code price

I'm trying to expose the port 3310 to allow remote mysql connection. so far, i have this configuration:

I will be working with the mariadb node connector over the next few

I am rewriting some node code to execute sql queries via a mariadb connector instead over via sql anywhere, and i'm trying to determine what

Just curious is there a way to check if given connection busy or may be used? or should/need i write own when question will stand. on

I created a web version of a board game and made some kind of lobby that people can join. once the player joined the lobby a webworker

Why between '2020-02-22 00:00:00' and '2020-02-22 23:59:59' is working (getting data)? and why between '2020-02-22' and

Basic datas: mysql-server: 5.7.27-0ubuntu0.16.04.1 ubuntu: 16.04 python: 2.7.12 django: 1.11.16 virtualenv i

If for example an user comments another users post, what is the best way to notify the user that there is a new comment? the data is stored in a

I'm trying to create a webservice but when i try to get records from database(mariadb), the response is being shown as {} and does not show the

I have 3 tables restaurants table: restaurant_id

I am making search function by linking mariadb with elasticsearch and logstash. by the way.. by the way, every time i get a value

I am using sequelize at nodejs. when i was making, i set the unique option in a column called 'invoice'. but since i need to remove the

I am trying to set up tests for my laravel application. the application runs with docker compose. when i try to start my tests with

I have the following table and want to remove duplicates between the oldest and newest timestamp.

I have a web page written in php (version 7.3.12), where an user can write any sql statement and then execute it (i am using mariadb version

I have created my docker-compose.yml file to make containers for a laravel project and i created a separate project_setup.sh script to do composer

I have custom migration: code: // groups migration schema::create('groups', function (blueprint $table) {

I am developing an application using reactjs / nodejs + expressjs. i am trying to understand what is the best way to handle connections to

I have to pull data from a table that has 2 million rows. the eloquent query looks like this: $imagesdata =

I cannot execute migrate:fresh. command fails at changing table column from:

I am trying to run the foowing command in my laravel project with docker: php artisan migrate but it is throwing

I am running into a weird problem of laravel nova not being able to persist any of my models. trying to save a user on a fresh nova install and

My database has a users, likes, dislikes, parcels table. the likes, dislikes, parcels tables are linked to the users table by the user_id

Using laravel codebase, i have two servers, a dev env, and a production env, which exhibit different handling of single vs. no quotes in a

I am new on web development trying to fetch data by particular time of the day from mariadb database but getting no results. i am trying

I have multiple arrays with similar key/pair sets. i'd like to loop through them using a foreach and print 2 per page element.

It's my code: const mariadb = require('mariadb'); var test = async function(){ var ret = ""; await mariadb.createconnection({

I’m trying to insert into / on duplicate key update taking the values from one table and inserting into another. i have the following python

I have read about this already in so and mariadb knowledgeable about this incompatibility between mysql and mariadb. but i am not sure how to

Lastly i tried to pull and install the homestead environment of one of my laravel project. everything is working fine except i can't install

I receive the error sqlstate[hy000]: general error: 1005 can't create tableposys.#sql-2b94_d2(errno: 150

How do i ensure the value being inserted into the database is actually the null value instead of a 'null' or empty string using parameterized

I installed mariadb server / termux on an android phone (huawei) and an android tablet. in termux, mariadb was launched using:

We have an api function which check a condition on database with a select-query then if it was true we want just for one time insert some thing to

I'm looking for a solution so that i can check for non-matches in other tables. basically i have 3 tables (see below). here i want to look

I'm setting up a web-server that the client would communicate with to get data from a database. i am have both my server and database set

Select * from many_leads_lead_details where location like '%los%angeles%' and (keywords like '%real%' or keywords like '%real

Lets say i have this table name lang message

Right now, i'm using laravel eloquent for the retrieval of purchases from a specific pack; supposedly, this line:

I have a virtual machine in a server to which i uploaded my laravel project folder. so in my localhost when i delete a "project" it

I try to connect to my mariadb database using node.js based on

I'm using mariadb: mysql ver 15.1 distrib 10.3.32-mariadb. the only configuration option i have changed from ubuntu's default is

I'm trying to run my laravel 5.7 app but will always get the error could not find driver when trying to run a query in my page.

I've searched already on the internet, but couldn't find a solution to my problem. i'm using nodejs and a mariadb with a pool connection. i get a

Altough it seems my associations defined in the database when i call create on my manufacturer model associations does not

I am fetching data from database using four select queries. the data is in such a way that there are cases when the input to select query may be

I need to create non-temporary tables in a mariadb 10.3 database using node. i therefore need a way of generating a table name that is guaranteed

I need to run a custom query and i have tried all these methods $sql = "select acd.*, date_format(acd.cdate, '%d/%m/%y')

I have table 1: historial_id timestamp address

I'm developing an api with flask and i cannot retrieve queries from a mysql database i've connected with flask-sqlalchemy (not

I installed mariadb via homebrew to set up a wordpress enviroment. it is meant to work with laravel valet. i am currently using using the zsh

I am trying to split a string into an array and use these as keywords to make an sql query. i have made a sample of splitting the array and

I create a container for my laravel project using this dockerfile: from composer:1.8 run apk add --no-cache libpng libpng-dev

I have been checking for the connectivity of mariadb, with sequelize. const sequelize = require('sequelize'); // setting up

I know this question has been asked before but i cannot get it to work. i'm writing an app to scrap some stock information on the web. the

Currently i have this data retrieved from database as follows,

I want to move a website built in joomla 3.5.1 to a new server. bought domain/space at the new server and i backed up

Show create table users; and i will get that result . create table `users` ( `ur_id` bigint(20) not null, `dept_id`

Create table `projects` ( `stars` integer, `title` varchar(255) ); create view projects_view

I'm using mariadb and now wanted to add a foreign key to my database table. i'm having problems when trying to use set default as my

I have some problem with some tasks. i've got many tasks like this: create a query that shows up for every client, id of his last invoice

services.adddbcontextpool<cpscontext>( options => options.usemysql(connectionstring,

I'm making an inventory system using java and jdbc. i have got this error some how when querying a table.

I am getting an error with configure. this is the cmd i am running ./configure --with-mysql-lib=/lib64

I am currently learning dbms. my problem is to find the oldest and the youngest student in the class along with their age and dob. there is no age

I want to insert a new row on table 'b' when a column in table 'a' is updated. but when the trigger fires with update req set

And i appreciate in advance for your help on this. i have a vps with the following specs: os: centos 7.x cpu model: common kvm

On centos8, issue during installation of prestashop 1.7.7.5 (also with 1.7.7.4) :

I have read literally every answer on the net that i could find. nothing is similar to my problem, so here it is: i have a bash script with

I get the following error 2: sql error: '' (), when i try to create page content. it's typo3 v4.5.22 and i am using mariadb 10.3 as

I want to get random name from database. @override public string createname() { string result = "empty";

Problem from the first try, when i tried to run my first migrate, things are already very bad. why? because i

I'm trying to create this procedure (source:

I tried to sort/order data on database. i used this command: select * from `estates` order by `estates`.`price` asc

Need some help getting out of the weeds. i have host a laravel application that started with 4.2 forever ago, that i upgrade every couple years

I have written perl code that parses a text file and uses a hash to tally up the number of times a us state abbreviation appears in each

I tried to add a json column to my database by using phpmyadmin but unfortunately, phpmyadmin converts the json column to longtext

I have a project i am working on and i have a staff, customer & sale model. as expected,

Good day! i have this sql but is not working in hosting. on lan everything is fine. i couldn't find what the problem is. laravel project

Recently, durning a higher traffic i started to get these php errors: got error 'php message: deadlock found when trying to get

I am currently learning sql and i tried testing something but it does not work. the query that i tried is the following:

I have a table executors with columns: id(pk) | order_id | executor_id(ek) | execution_price | created_at | selected 1

I use wp-cli in my deploy/upgrade script. i'm currently getting the following error from wp core is-installed (first command my

Basically, i have this query: select *, `groups`.`goodname` from students as s inner join groups as g on s.univ_group =

I'm trying to create a local development environment to test website changes out in. the web developers i'm working with have a gitlab repo of

When migrating a wordpress database to a new server it get the the error: error 1064 (42000) at line 194036: you have an

I am trying to delete a string of html from all wordpress posts and pages (but posts first) i have a query where i find all instances

I have a little problem. i'm trying to launch wordpress which is itself connected to my database (mariadb) through the nginx server. but when i

I have a partition table which is partitioned by date, here's my table definition: create table `bbdd` ( `id` int(11) not null

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

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

Delimiter $$ create procedure sp_delete_data() begin declare i int default 0; declare loop_counter int default 0; declare