Questions tagged as 'mysql'

Tagged questions
1
answer

Create tablespace in Mysql

Greetings I would like to know how to create a tablespace and a table that stores your data in the newly created tablespace     
asked by 28.11.2017 / 03:52
1
answer

google chart PHP and Mysql

Good morning, I am making an application in PHP and Mysql to manage the reports attended in a customer service office of a water and sanitation services company. At the moment I am trying to generate graphical statistical reports u...
asked by 24.11.2017 / 15:32
1
answer

Perform INNER JOIN correctly

I have 2 tables t1=quotations and t2=quotation_has_packinglist in which I have repeated the fields email and date , in order to get the information from the table quotation_has_packinglist and show it in the vie...
asked by 01.12.2017 / 22:34
2
answers

Take out 0 with count () Mysql

I have 2 tables: -Tabla departamentos con 1 campo(Nombre_Depart) y 3 inserts: Comercio,Informatica,Centro. Tabla Usuarios con 2 campos(Nombre,departamento) y 3 inserts: Edu en informatica. Jaime en informatica. Conserje en centro. I want t...
asked by 30.11.2017 / 15:23
1
answer

How can I insert fields from a table with fields from that same table?

I am writing the example of what I want to do. I have a table in mysql in the following way create table usuarios( id varchar(10) primary key not null, apellido1 varchar(20), apellido2 varchar(20), nombre1 varchar(20), nombre2 varcha...
asked by 19.11.2017 / 01:25
1
answer

Pass the "Login" in java and database

I'm trying to make a login in java and mysql but at the time of trying to pass the login it fails me and I do not know why ... it throws me the message of "Errrror". I have a JFrame with the login button that would be this: private void jButto...
asked by 19.11.2017 / 16:29
1
answer

How to modify and delete two tables at the same time?

Good afternoon, I need your help, I am trying to delete and modify two tables at the same time I append the code that I am using; I hope and you can help me since it is difficult for me to do it, I would appreciate it:) .... Functions.php &...
asked by 04.12.2017 / 19:04
1
answer

Fatal error: Call to a member function fetch () on a non-object

I am trying to extract the data from a given cabin (it must be a whole number: 1, 2, 3, ... n). Why do you tell me that you have not defined "images" in the Cabanas.php file? I have defined var_dump ($ data); so you can tell me what you get...
asked by 04.12.2017 / 20:45
1
answer

Warning: invalid argument supplied for foreach () in - PHP

Why the following errors? Notice: Undefined index: images in C: \ xampp \ htdocs \ daw \ Classes \ Cabanas.php on line 24    Warning: Invalid argument supplied for foreach () in C: \ xampp \ htdocs \ daw \ modify.php on line 39 Test Cod...
asked by 05.12.2017 / 11:25
1
answer

mysql show the record that is current as of date

Hello friends could you help me? I have these records: +-----+------------+------------+ | id | date_start | date_end | +-----+------------+------------+ | 181 | 1511553600 | 1511899200 | | 186 | 1512158400 | 1512504000 | | 191 | 1512763200...
asked by 04.12.2017 / 22:31