Questions tagged as 'mysql'

Tagged questions
1
answer

How to modify a product table record from product_product table where the number of product entries is modified

Excuse me, someone could guide me with a problem I had when creating a table association since I created two tables (product (product_code, name, detail, existence), purchase_detail (purchase_code, product_code, detail, quantity)) and when wanti...
asked by 23.10.2018 / 22:33
0
answers

Insert data (FK) in a table with PHP from form and show

goodnight community. Again, requiring your great wisdom. I tell you. I have two tables in sql. One of students and another of careers. In Students I want to register something like registration_id (PK) ... name .. and race_id (FK)...
asked by 29.10.2018 / 02:53
0
answers

Calculate time between 2 records in the same MySQL table

I have to make a query with MySql. I commented: I have a table with the entries and departures records. What I need is to know the amount of minutes that each person was outside, considering that in the field "Event" of Inputs / Exits in the tab...
asked by 23.10.2018 / 19:19
1
answer

MySQL events between 12 hours

I'm creating an event that was already created in Sybase, this is done so that it runs every hour but it does between 7 in the morning and 7 in the afternoon. Does anyone know if this option is available with MySQL? I've been watching but I do n...
asked by 22.10.2018 / 13:23
1
answer

Validate query result equals a carater

I'm doing a Login project, and what I want to do is that if it's a user on the side and if it's admin between another, I'm already validating the user and password but I have the user-type field in my DB that is A if it is admin and U if you are...
asked by 24.10.2018 / 19:08
1
answer

Pass query from sql to laravel

I'm a bit new to Laravel, I have this query in sql and I want to move to laravel Select users_groups.Name FROM tm_employee INNER JOIN users ON tm_employee.UserId = users.id INNER JOIN users_groups ON users.groupId = users_groups.id WHERE tm_em...
asked by 24.10.2018 / 21:09
0
answers

Is it possible to connect an api-ai Chatbot with MySql?

The point is that I'm developing a chatbot with Api.ai, which connects to the Google Firebase real-time database, but I searched for documentation to connect to a MySql database, but not found. Does anyone have any idea how it could be implem...
asked by 24.10.2018 / 20:08
0
answers

Android Studio // Get recycler text to perform a customized search in database

I have a problem with my android project, I can not get the text of a field in a recyclerview to perform a more personalized search. My project I'm doing with a single Activity and the rest are only fragments where in these fragments I make quer...
asked by 05.11.2018 / 00:14
1
answer

Error executing stored procedure code to register data in mysql [closed]

CREATE PROCEDURE sp_registraVenta( INOUT cod int, cli varchar(150) ) BEGIN SET cod =(SELECT IFNULL(MAX(Cod_venta),0)+1 into cod FROM venta); INSERT TO venta VALUES (cod, cli, CURDATE()); END; Good day I had problems with this code beca...
asked by 21.10.2018 / 16:56
0
answers

I have a modal to add data, but when I click on add I want to close and show the data

Modal code: <!--************************************************ Modal Para Agregar computadores *******************************************--> <form action="" id="form1" novalidate="novalidate"> <div class="modal f...
asked by 21.10.2018 / 15:49