Questions tagged as 'mariadb'

Tagged questions
1
answer

I fill in the fields of the bd in the wrong order

I am doing a record for a page and this one is good for me except for one big mistake, and it is that it saves the data in fields of the bd that it should not, attached capture. As you can see in the user the password is put, in passwor...
asked by 03.08.2018 / 14:30
1
answer

Connection Node Js Mariadb

Hi, I'm trying to make a connection between nodejs and mariadb through Xampp, but when I run it does not return anything, I should return the 1 generated by the query, but nothing else does not send me anything. Does anyone know where I'm fying?...
asked by 14.12.2018 / 21:25
1
answer

MYSQL No suitable driver found

I currently use Intellij, it turns out that I'm trying to connect to a MySQL database, but after adding the library and using a class connection (which works perfectly with the MariaDB driver) I find the error in the title of the question publ...
asked by 10.11.2018 / 13:40
2
answers

How to satisfy two conditions at the same time

Good afternoon, suppose I have a list of students with the list of subjects they passed, and I want to select the name of those who passed math and language, if I do: SELECT nombreAlumno FROM alumno WHERE aprobo = matematica AND aprobo = lengu...
asked by 17.08.2016 / 20:55
1
answer

Problems with DataSource on a tomcat server 8

I have a web project on a Tomcat server (Windows 2008) with a MariaDB 10.0 database, for the connection we use the mysql driver "mysql-connector-java-5.1.36-bin.jar". I have made a migration from TOMCAT from version 6 to 8. Apparently everyth...
asked by 24.08.2016 / 15:38
0
answers

Configuration database maria db

I currently manage a website that maintains about 30 simultaneous simultaneous connections up there, but in phpmyadmin a series of alerts have appeared from the "current status" section, all the state variables, in summary these are the a...
asked by 12.09.2018 / 20:33
1
answer

avg returns null

I have a query that returns the average of 2 columns of type float, the thing is to change the date from date to datetime to be able to insert it with the time and now the query does not work, I return null in both columns the table is: cre...
asked by 27.09.2018 / 04:07
0
answers

How to select an option of a select (with values loaded from mariadb) that is in an open modal with eventClick of fullcalendar?

I put them in a situation I am making a web application that implements fullcalendar to create an agenda, in which by clicking on any day you show a modal window in which there is a form to register the event, but I I needed to use a select to l...
asked by 31.08.2018 / 05:49
1
answer

Mariadb Vs MySql

Recently I made the migration from one page to another server. I began to observe a strange behavior of a module. Perform the inspection of the module and I see an SQL query was not throwing me the expected results. After making the breakdown of...
asked by 07.06.2018 / 18:01
3
answers

Improve SQL query to show results

I have two tables which one by means of RIGHT JOIN and the sentence is as follows: $sql= "select * from bookings RIGHT JOIN calendar ON bookings.date=calendar.day_Date GROUP by calendar.day_date"; I add an image with the structure an...
asked by 13.04.2017 / 21:16