Questions tagged as 'mariadb'

Tagged questions
1
answer

I can not create a foreign key in MariaDB

This is what I write: alter table T_reserva add constraint pk_codHotel foreign key (codHotel) references T_hotel(codHotel); This is the T_hotel.codHotel table: +----------------+--------------+------+-----+---------+------...
asked by 19.11.2017 / 03:24
2
answers

How to save array in a single field in msql

I have a problem I have 3 tables in which in the first two the data is saved correctly, but in the last table only the value of subject1 and code-subject1 are saved for each iteration of the for cycle, I think the problem is in the form of how I...
asked by 30.10.2017 / 21:45
0
answers

# 1227 - Access denied; Do you need (at least one of) SUPER privileges for this operation in 10hosting?

I have a problem in my database that I went up to a free hosting, the problem is that when I want to integrate my task planners to run they do not let me install them and they do not even let me activate the planner I do not know what happens I...
asked by 06.10.2017 / 03:11
1
answer

Error creating store procedure in MariaDB

I'm creating a procedure stored in Mysql 01 CREATE PROCEDURE prcGrabarLocationGPS ( 02 _latitude DECIMAL (10,7), 03 _longitude DECIMAL (10,7), 04 _speed INT (10), 05 _direction INT (10), 06 _distance DECIMAL (10,1), 07 _date TIMESTAMP,...
asked by 29.09.2017 / 00:01
1
answer

Does my pdf generate without problems but when adding a conditional it stops working?

Hi, I'm giving permissions to my system, I generate a pdf by making queries to a database, it works perfect even when adding the if and validating the session start and the level of privilege of the user, but at the moment in which I use the els...
asked by 22.09.2017 / 18:36
0
answers

Help with the Mariadb database?

Hi, I want to insert multiple products, units, quantities, related dates for the same purchase order and then show them within the same row in a table, but I can not find how to do it. To be more clear that if they had the same purchase order...
asked by 25.09.2017 / 17:24
0
answers

What is better many functions each one with your query calling record by record or a single query with a single array?

Hello everyone for the first time I come here not because my code does not work haha but because I think that when I have many records my database will be encouraged, I explain I am generating a pdf document and have values that I take from the...
asked by 12.09.2017 / 20:42
1
answer

How to send values of ckeckboxes not selected and selected to a single array (and try to hide) php?

Hello again with my form return this time I have problems with a checkbox by the way and try the hidden button that I'm not so lazy search in Google and it worked but for a single input but I realized that by sending several inputs I I marked an...
asked by 08.09.2017 / 19:25
1
answer

Insert value of chekbox not selected in fix already in client or server with the same name and insert dynamically?

Hi, I know it's a very simple thing. In fact, I tried to solve this on the client's side, but I decided to try to do this in the database directly in order to continue with my project, I would appreciate corrected my code. The problem is with th...
asked by 11.09.2017 / 20:46
1
answer

How to insert multiple values but separated into a single MariaDb record?

Hi, I want to insert multiple products, units, quantities, related dates for the same purchase order and then show them within the same row in a table, but I can not find how to do it. Basically it is a system to capture orders. To be more cl...
asked by 25.09.2017 / 20:21