Questions tagged as 'mariadb'

Tagged questions
3
answers

Create PDO query with the values of an array

I am trying to generate a MySQL query with the data I have captured in a array . array(2) { ["area1"] => array(3) { [0] => string(5) "item1" [1] => string(5) "item2" [2] => string(5) "item...
asked by 04.04.2017 / 18:27
1
answer

Update MYSQL does not work correctly

I have this code: <?php session_start(); if (!isset($_SESSION['user'])){ header("Location: index.php");} include("db_files/db.php"); include("inc/functions.php"); $oldpass = mysqli_real_escape_string($db, $_POST['oldpass']); $ol...
asked by 04.11.2016 / 16:35
1
answer

Can XAMPP mariaDB be changed by Mysql?

When I installed XAMPP, I found mariaDB in phpMyAdmin in the section Server type and when I try to access cmd to make a database in MySQL from console I also appeared mariaDB     
asked by 27.04.2017 / 07:05
1
answer

create temporary tables mariadb 10.1.21 from php 5 and be able to make a selection of them?

I am trying to create a temporary table from php but when doing the select it tells me that: mysqli_fetch_assoc () expects parameter 1 to be mysqli_result, boolean given in The code is as follows: mysqli_query($db,"DROP TABLE IF EXISTS T");...
asked by 04.01.2019 / 20:42
2
answers

Seconds_Behind_Master grows constantly on MariaDB / MySQL slave server

I have a slave server configured running on Debian 9 in MariaDB 10.1. I configured it and started to work and everything was fine, what worries me is that every time the variable Seconds_Behind_Maste is delayed. He started with 1 second delay an...
asked by 05.10.2018 / 20:42
1
answer

How to create invisible columns in MariaDB?

Inside the database manager mariaDB, we can create a table, indicate the type of data we expect to receive, as well as its longitud and whether it should be NULL .    However, in managers such as Oracle we can define in th...
asked by 18.09.2018 / 03:55
1
answer

Use of IN and OUT in Stored Procedures

A procedure stored as such is a routine that contains the sql statement (s) to which it is accessed as follows CALL nombrePA(); A simple example we have of a PA is like the following DELIMITER // CREATE PROCEDURE fetchAll() SELEC...
asked by 10.11.2018 / 01:49
1
answer

Accents are not shown [duplicated]

I am loading this information from a DB, but when it is displayed in the HTML it does not recognize the accents. I'm using PDO to connect to the DB and I use UTF-8 in the html Reviewing phpMyAdmin I see that the coding is as fol...
asked by 08.11.2018 / 23:28
2
answers

ERROR 1045 (28000): Access denied for user 'root' @ 'localhost' when loading sql

Version: Server version: 10.1.32-MariaDB I have trouble setting a password in mysql o mariadb use xampp 5.6 I install xampp I enter the console and with mysql -u root log me in. Following different examples that I...
asked by 04.08.2018 / 16:09
2
answers

perform query and condition update

Specifically, I tried a lot of things and it did not work out or I got messed up trying so hard. I have 2 tables Summary and Detail What I'm trying to do is get all records for a DNI in the DETAIL table, on the result check the values...
asked by 04.04.2018 / 04:47