Questions tagged as 'mysql'

Tagged questions
0
answers

connect 2 pc to the same database through mysql xampp

I have a desktop application programmed in c # and I need 2 pc to connect to the same database through the local network created from an android device. pc with the application (client): 192.168.43.181 pc with the BBDD: 192.168.43.172 c...
asked by 29.11.2017 / 03:17
1
answer

Ajax or json can not restart, does not show the MySQL select in the table

I get these errors does not let me see all the data in the table. but yes in JSON THIS DOES WORK SEPARATELY <?php $db_host = "localhost"; $db_user = "root"; $db_pass = ""; $db_name = "mva_colegio"; $conectahugo = new my...
asked by 28.11.2017 / 22:47
1
answer

Perform query of totals between two tables without duplicating the values

I need to combine 2 tables, make a summary and get their differences. In the services table I have the cost of the service, in the payment table I have the amounts and means of payment associated, as I can make a summary in such a way that indep...
asked by 05.03.2018 / 19:55
1
answer

How can I avoid repetition of values in columns in a Mysql table?

I've already tried it with UNIQUE and CHECK but it does not work for me. If there is a teacher with a subject, I would like you not to put the same subject back to me, because the rest of the code I have makes it repeat. * * * for($i=0;$...
asked by 22.11.2017 / 17:03
0
answers

MySql query for 1 TB database

Good morning, I am faced with the problem that because of the size of the query, it is impossible for me to execute it, and it is not feasible to cut it into very small pieces because it would never end. I'm using the Laravel 5.5 framework, but...
asked by 01.12.2017 / 09:09
1
answer

How do I backup my database from my website with php?

Hello, I am new to this programming and I would like to help me make a backup of my database from a button on my website. Thanks in advance.     
asked by 01.12.2017 / 02:10
1
answer

How to make a list pass with jframe and mysql

How about, if you could support me it would be great, I'm creating a project about a school control in java netbeans with jframe connected to mysql command line client, but I got stuck when I went through the list, my idea is to have a jframe th...
asked by 30.11.2017 / 23:44
1
answer

Dockerfile ask the user a value

Good afternoon colleagues, I'm working with Docker in the construction of some images and I've found that some facilities ask the user questions such as a password. There is the possibility of questioning the user during the process of creati...
asked by 22.11.2017 / 00:40
0
answers

Page loses styles by adding "1" in PHP

I have a problem wanting to add "1" to a variable in PHP, it distorts CSS styles on my page. I explain, the normal page looks like this: But when I add "1" it goes like this: The PHP code is as follows: <?php //Crear Va...
asked by 20.11.2017 / 00:19
0
answers

error code 1072. key column does not exist in table

CREATE TABLE 'prueba12'.'usuarios' ( 'ID_Usuario' INT NOT NULL AUTO_INCREMENT, ' USR_Nombre' VARCHAR(45) NOT NULL, 'USR_Apellido' VARCHAR(45) NOT NULL, ' USR_TipoUsuario' INT NULL, 'USR_Prestamo' INT NULL, 'USR_Libro' INT NULL, PRIMA...
asked by 19.11.2017 / 22:48