Questions tagged as 'mysql'

Tagged questions
3
answers

Insert values in a row with auto-increment

I need to know how to insert data in the row of a table in which one of the fields is a self-increment. The table, called 'employees', already has about 30 records and the 'employee code' is the auto-increment column, which goes by the number 30...
asked by 03.08.2016 / 10:22
1
answer

How to make a query with like having a backslash

I want to filter "Creaci\u00f3n" SELECT * FROM database.tabla where columna like "%Creaci\u00f3n%"; How could I do it?     
asked by 19.09.2018 / 17:29
2
answers

Problem in MySQL Select query

I have a problem in a Query in MySQL, I currently have two tables, one of employees and one of places visited by that employee by date, the goal is to obtain through a query the list of all employees and the last place they visited, so far so go...
asked by 05.09.2018 / 20:17
1
answer

Any way for a user to modify the $ _SESSION []?

I want to know if my web application runs some risk , since I am making all the "permission" verifications depend on the value of its $_SESSION[]; In my case, I use: $_SESSION['username'] , which contains the username of the p...
asked by 31.10.2018 / 22:38
1
answer

Mysql query to obtain date of entry of a data to the database

I have a database in MYSQL and I designed the table to receive answers but I did not make a date field for it. My question is whether in MYSQL there is a query to know on what date an insert was made. Thank you very much.     
asked by 01.11.2018 / 16:39
1
answer

MySQL Does not execute well trigger

I have a "trigger before insert" in a table in MySQL, which calculates a time accumulated in the last column of the table through a stored procedure that compares the record that is being inserted with the previous record chronologically ordered...
asked by 10.09.2018 / 22:39
1
answer

Add in a Mysqli a value different from that indicated by the select

guys I have the following conflict: I have the following code line in a form: <div class="form-group"> <label for="monto">Seleccione Monto</label> <select class="custom-select" id="monto_mensualidad" name="monto_mensual...
asked by 10.09.2018 / 20:11
2
answers

Sum of values in tables and show the result

I have a MySQL table, with Customer ID, Initial Due, Date and Subscription I need to make a query that adds all the values with the same id of the table and shows it in a new column, in the row of its related id. Table: CI | Deu...
asked by 02.09.2018 / 03:56
1
answer

As insert records every certain date with php mysql

It turns out that I have an app for preventive maintenance. My problem is this: In the "orders" table, the orders of each "resource" or team are loaded. But preventive maintenance is done every so often, so when loading a Preventive work orde...
asked by 08.09.2018 / 05:50
2
answers

How to avoid blank records to the db, in the filters the empty field is valid .. but still commands them

<?php $errores = ''; $enviado = ''; if (isset($_POST['submit'])) { $nombre = strtoupper($_POST['nombre']); $apellidopaterno = strtoupper($_POST['apellidopaterno']); $apellidomaterno = strtoupper($_POST['apellidomaterno']);...
asked by 26.08.2018 / 16:11