Questions tagged as 'phpmyadmin'

Tagged questions
2
answers

how can I insert two insert into a trigger

As I can do two insert in a trigger try that but it does not work for me, if I put a single insert if it pulls but in phpmyadmin CREATE TRIGGER update_alumnos AFTER INSERT ON Alumnos FOR EACH ROW BEGIN INSERT INTO Procesos VALUES (new.id,1...
asked by 06.06.2017 / 15:47
1
answer

Timestampdiff does not work in Clause Where

I'm doing a query to the database and I want to show me only the records in which the difference between the query time (NOW()) and the time of the datetime variable is less than 60 minutes ... (which shows everything that is more than on...
asked by 24.02.2017 / 03:46
2
answers

Print tables in Php form

Well, it happens that when trying to show the table "client" in my php form it is not generated, the problem is that it does not give me the origin of error. I've been looking for that error for a couple of hours and I can not find it. I have th...
asked by 17.10.2018 / 20:31
3
answers

SQL query in MySQL between 3 sum and count tables

I have 3 tables. One is clientes , other fotocopias and recargas_saldo , related by id_cliente which is primary key in clientes and foránea in the others. I need to take out the following: 1 .- No...
asked by 17.10.2018 / 13:16
1
answer

Check with session :: flash in Laravel

My question is about how to deal with this kind of errors. So far I know that this happens because you can not delete a record that depends on another record of another table, which are related. But my question is if you can show another k...
asked by 27.09.2018 / 23:27
1
answer

How to make a primary key that is autoincrementable start from scratch?

Good afternoon friends a question about sql in particular phpmyadmin happens that I want a table or good several tables ids primary key autoincrementable start from scratch, since I have deleted everything from scratch but when inserting data pu...
asked by 28.10.2018 / 05:03
1
answer

Update of multiple rows with different values

I'm trying to update different rows with different values, in my sql table, the closest I've come is: UPDATE cursos SET posicion = 11 where Id in (1,2) But it updates me with the same value (11) logically the two rows, I need to give a...
asked by 30.08.2017 / 01:12
1
answer

Insert decimals from php to phpMyadmin

how are you? I have a question, I want to enter a value from php, such as 155.60, but when I add it to the phpMyadmin database, it saves it as 155, that is, it rounds it, but I need it if or if I presicion it. Place FLOAT on the BD, also probe w...
asked by 18.11.2018 / 05:33
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
2
answers

Can you EMPTY a table (truncate) every X Minutes?

I have a little doubt, in which I have not found much information. Could something be done, for each "5 minutes" (for example) to empty all the contents of a table? The truth is that I have been investigating, and I have not found any usef...
asked by 04.09.2018 / 22:26