Questions tagged as 'mysql'

Tagged questions
0
answers

what can be the problem if the identifiers are not applied (identifying) in the database or if they are applied in a heron way?

Good morning the reason for my questions about identifying and non-identifying relationship been inquiring about the issues the concept I think I already understood, but I have a doubt about what would happen if at the time of th...
asked by 20.11.2017 / 14:57
1
answer

Error in mysql_fetch_array

this is the error:    Warning: mysql_fetch_array () expects parameter 1 to be resource,   boolean given in C: \ xampp \ htdocs \ 10-1 \ workshopfinal \ consult1.php on   line 6 <?php $documento=$_REQUEST["documento"]; $conexion=mysql_co...
asked by 19.11.2017 / 00:11
1
answer

I can not create a foreign key in MariaDB

This is what I write: alter table T_reserva add constraint pk_codHotel foreign key (codHotel) references T_hotel(codHotel); This is the T_hotel.codHotel table: +----------------+--------------+------+-----+---------+------...
asked by 19.11.2017 / 02:24
1
answer

Help, insert records in related tables using php oo

Greetings friends, since yesterday I'm trying to solve an exercise but I can not find a solution for now. I have 2 tables in my DB called ts_client and another ts_quipment , the relationship is 1: n a client can have many computers. Previou...
asked by 18.11.2017 / 20:29
0
answers

As Together the "Names" and "Property in Your Charge"

SELECT E.NUMRUT_EMP ||'-'||E.DVRUT_EMP as RUT_EMPLEADO, E.NOMBRE_EMP ||' '|| E.APPATERNO_EMP as NOMBRE , COUNT(P.NRO_PROPIEDAD)"PROPIEDAD A SU CARGO" , CASE WHEN COUNT(P.NRO_PROPIEDAD) = 4 THEN count(P.NRO_PROPIEDAD)*(P.VALOR_ARRIENDO+P.VALOR...
asked by 18.11.2017 / 21:42
1
answer

Conditional colors in TableView JavaFX

I have a table in javafx like this: What I need is to change the color of the cells in the KmSopassed column according to the value it has. for example if the value is greater than 5000 it should appear in red if it is smaller yellow etc....
asked by 15.11.2017 / 19:21
1
answer

MySQL Filter Expired Permissions

I have the following question: I have a table in mysql called drivers in which I keep your data including Date of Issued driver's license and Expiry date. What I need is to filter "Show" all those that are about to expire or have already expi...
asked by 15.11.2017 / 20:08
1
answer

I can not insert values into the database with Java Servlet

I have a database and I want you to insert values in the table ... the program does not throw any errors ... but it simply does not insert the values in the database ... When I make an insertion through the database is fine ... but I can through...
asked by 15.11.2017 / 17:41
1
answer

Query to bring BETWEEN data

Good morning, folks, I'm going around with a query that would seem simple but I can not find it back. I am developing a reservation system in which fractional every 00:30 minutes and reserve by rank of 01:00:00 or 01:30:00 I have a reservation t...
asked by 28.11.2017 / 13:32
0
answers

Change of time zone

I'm doing tests to implement Highcharts in a production line. The data is sent every few seconds to a Mysql database. The problem is that when the time zone changes to adopt the summer or winter time, the date field will double for one hour. I h...
asked by 28.11.2017 / 09:47