Questions tagged as 'mysql'

Tagged questions
1
answer

jQuery table sorter does not sort my tables when I get data from MySQL

I apologize for the code, I'm learning, it's probably a disaster, but I can attest that the database connection does it well just like the query just that the script does not run correctly, I tried a table filled by hand without asking mysql and...
asked by 20.08.2017 / 22:37
1
answer

How much space a null occupies in the database

good morning the reason for my question is more informative is about the space that occupies a field null in the database, since I have a database with several fields and sometimes I have several fields in null and I worries about the space this...
asked by 15.10.2017 / 22:29
2
answers

Problem when running consecutive MySQL queries in PHP

I want to insert records in a table from another table. The first record to insert is the record that has the sum of the amounts of the records in the source table. (Position) And the rest of the records to insert are those that appear in the so...
asked by 13.10.2017 / 00:58
1
answer

How to avoid SQL injection in this Php code and create MYSQL queues? [duplicate]

I have this code in a system that I am developing, it works but I know that I have to put security in it and also leave it to work in the long term, for which I would like to know how to prevent the database from falling down, to several users...
asked by 11.08.2017 / 01:20
1
answer

Specify language with MYSql - STR_TO_DATE

I have the following problem. I need to parse a text to a date with MySql . The problem is that the text to be parsed is of the style: " 03-ene-17 ". I used the STR_TO_DATE function in the following way: STR_TO_DATE('03-ene-17', '...
asked by 18.07.2017 / 10:09
2
answers

create and relate 2 temporary tables

good day I am creating 2 temporary tables the first table is called QUESTIONS CREATE temporary table PREGUNTAS( idpregunta int auto_increment, primary key(idpregunta), pregunta varchar(200) ); the second one is called OPTION CREATE tempor...
asked by 31.07.2017 / 17:56
2
answers

How do I make a partial backup of a table?

In a database called TEST I have a table called CULTIVES in which one of its fields is a numeric type and is called PID. This table has this structure: mysql> DESCRIBE CULTIVOS; +----------+------------------------+------+-----+---------...
asked by 01.08.2017 / 09:13
1
answer

Concatenate variable php with sql query

It does not let me concatenate the following query, it throws me error $consulta_url="select url from urlspeliculas where idioma='$idiomas[$f][$g]'"; the last bracket in $ languages [$ f] [$ g] I take it as text, some solution?...
asked by 29.01.2018 / 03:24
1
answer

Using MySQL Procedures in GeneXus

Is it possible to invoke procedures created in MySQL from Genexus? If so, how can I do it? Is there a guide?     
asked by 09.04.2018 / 22:02
2
answers

How to count records of 3 tables linked by a foreign key?

I have a main table with one record, and in the other two tables there can be several records that depend on the record in table 1. I need you to show me only 1 record as it appears in image 1, but adding 3 more columns corr...
asked by 25.01.2018 / 06:51