Well I hope to do this well, it's the first time I ask on this site.
What are triggers, functions, views and stored procedures?
The truth is I'm starting in this database and I have many doubts in the use of functions, views, trigger and PA f...
I am trying to make a table that shows the data of the pet table by means of an array, it is expected that all the fields of the pet table will be shown, but only one error appears Fatal error: Uncaught Error: Call to undefined function mysql_f...
I want to know the name of the department that has the max number of employees in my database, the query I use is the following:
select depart.dnombre,
count(*)
from emple
inner join depart
on emple.D...
I would like to search for a client by ID in my database and to find it, show the code of the form here:
<form method="get" action="">
<p align="center">Cedula :<input name="cedula" type="text" value=""
id="celcliente"&...
Hi, I'm working with materialize css, and obviously JS, I want to convert a string whose format is this: Mar 12, 2018 I want to convert that to Date so I can store it in the DB as Date.
I have two tables (both related by their ID):
Socios: Socios_carga
------------ --------------
ID ID
Nombre Nombre
RUT RUT
Then with INNER JOIN I generate the query of...
Sorry, this is my first post and I'm asking for help hahaha ... I'll comment to see if you can give me a hand and several more can be useful.
I have an assistance system made in PHP and MySQL, which works correctly.
Ex: Employee X enters at 8...
My problem is that my java application generates too many connections without control. In the first instance I thought it was because I was not closing the connections correctly, but the problem is not solved. Any other option to be able to clos...
Good day everyone.
I know in advance that this question is already posted on the site, however the solutions I have tried give me unsatisfactory results.
My situation is as follows.
I have a table ( logs3 ) with several fields of which...
I have three tables and models related to each other and I need to consult the properties whose Environment.Name = 'Dormitorios' and PropertyEnvironment.Value = 2 :
App\Property :
id
address
etc
Methods:...