Questions tagged as 'mysql'

1
answer

Center carousel of bootstrap images

I'm doing a bootstrap carousel but when defining: <div class="col-sm-12"> With the 12 if it appears centered on the screen, but if I want to make it smaller for example: <div class="col-sm-8"> With the 8 comes more stuck on...
asked by 26.04.2018 / 16:54
1
answer

Subquery and return as a chain

I am trying to have a subquery come as a broken string from a subquery. This is the structure of the DB (I know it's not the way but when I got there I was and I need to get a job before normalizing) STRUCTURE CREATE TABLE 'TIENDAS' (...
asked by 18.05.2018 / 22:49
3
answers

Why do not you bring me the data of the sql query?

Good afternoon I'm doing a query on mysql given a date bring me the year and month and the reference for that month, the query is good but it's not bringing me anything, someone to help me find the error. <?php //comprobamos que las fechas...
asked by 23.06.2016 / 21:09
3
answers

I can add a field that keeps 1 and 0 separated by semicolons

I have to make a sum in MySQL of a field called assistance that saves 0 and 1 depending on whether you attend or not taller personas asistencia 65 31;42;58 (idUsuario) 1;0;1;1;1...
asked by 02.08.2017 / 19:05
2
answers

MySQL AUTO INCREMENT vs. ID generated from PHP

I have tables which will have millions of records in them. What is the best way to create the unique ID of these tables? According to MySQL, there is the use of AUTO_INCREMENT, but at a certain number of registers it slows down each time....
asked by 04.04.2017 / 02:10
4
answers

How to get only the time?

I'm trying to get the "zeros" as the image shows I have the following part of the query: "sec_to_time(SUM(horas_semana)*3600) as horas_semana" Which I do not know what else I can do to only show the "48" hours only. Any advice?...
asked by 21.04.2017 / 18:14
1
answer

how to insert date values in mysql table

I have a problem inserting dates in a table column mysql . I've already tried putting the field as varchar , date , datetime and nothing. $fecha_ant = date("Y-m-d", strtotime("-3 day")); // with this I get t...
asked by 21.11.2016 / 16:37
3
answers

Transfer records from one table to another by adding subtotal

How can I transfer this Source_table that has D (must) records: ID MOV IMPORTE CLASE 1 1 100.00 D 2 1 200.00 D 3 1 50.00 D 4 2 450.00 D 5 2 80.00 D 6 3 30.00 D 7 3 50.00 D 8 3 70.00 D And that i...
asked by 05.05.2017 / 18:58
1
answer

Is there a software that can load 29 GigaBytes? [closed]

Hello, I have a base that weighs 29 GygaBytes and I want to know if there is a software like ACL, SQL, in which you can load a base of that size, I have the file in DBF or some way to split the base     
asked by 03.05.2017 / 19:27
2
answers

Consult the database when WHERE is what I send from the Angularjs driver

I have a conection.php that connects to the DB and queryTickets.php : <?php header('Access-Control-Allow-Origin: *'); date_default_timezone_set("Chile/Continental"); **// Including database connections** require_once 'conection.ph...
asked by 03.11.2016 / 15:27