Questions tagged as 'mysql'

Tagged questions
0
answers

Run Non-root stored procedures in MySQL 8.0.13

Update the bd engine to the latest version MySQL 8.0.13 and we started with the problems. I did not lift the copy of the database "solved", now I do not execute the stored procedures any user that is not root, before in version 5 if it wo...
asked by 15.11.2018 / 18:21
0
answers

# 1329 -No data-zero rows fetched, selected, or processed

Good day I have in my database (MySQL) the following table: To obtain the balance of an account on a certain day, I use the following query: SELECT (@total := @total+IFNULL(SUM(tcc.consumo),0.00)-IFNULL(SUM(tcc.pago),0.00)) saldo FROM t...
asked by 15.11.2018 / 17:37
1
answer

Field String saves as an integer php objects and mysql

I have a update that is done in the following way. public function update_donante($tabla,$caso,$link,$campo,$tipodonante){ $this->tabla=$tabla; $this->caso=$caso; $this->con=$link;...
asked by 15.11.2018 / 10:26
0
answers

insert of dynamic input in mysql database

Hello everyone, my problem is as follows I based on an example that I found to make dynamic inputs me genra and do the calculations that I need but I do not understand very well how to insert all my data since the dynamic inputs are saved in a j...
asked by 13.11.2018 / 17:18
0
answers

Consult in 2 tables with conditions in 1

I have 2 tables: In the first (A) the following data: TABLA-A nombre fecha estado ============================== Ariel 12 2 Pablo X 1 Second table (B) TABLA-B nombre deporte ================...
asked by 13.11.2018 / 17:25
0
answers

Do not insert Master record Detail (or point of sale) in my Php code, why suggestions?

I have been programming in Php and MySQL a practice of master detail which has as fields the "id_detalle_renta", "idrenta", "idauto", which inserts the rent, but not the detail of the rent, then the php code with certain parts commented, I would...
asked by 15.11.2018 / 06:10
1
answer

Exception in thread "main" java.lang.NoClassDefFoundError: javax / xml / bind / DatatypeConverter

I'm doing an application on a computer, we're 4 and everyone uses Windows except me (Mac). This application uses a database with MySQL . At the beginning I had JDK 10 , now I have the 1.8 (8) . I have two versions of NetBean...
asked by 13.11.2018 / 18:12
0
answers

How to put in vertical 3 and horizontal 2 with boostrap, php and connected with mysql

Good evening I have a question about PHP with connection with MYSQL , I'm trying that when I call the database MYSQL , I get the data that I have registered but the structure of the frontend is displayed 3x2 and that's why I m...
asked by 15.11.2018 / 05:22
3
answers

Go through select function (mysql) in html

Good I have the following function in a PHP file I create the following function, which I want to go through to show the records in an html as it is possible to do it. Greetings function mostrarAreas(){ $consulta = "SELECT * FROM area"; $...
asked by 13.11.2018 / 17:53
1
answer

Values in DataList HTML, PHP, MYSQL

I would like to know why 'my datalist stores a number in my database instead of a name. Let me explain. I have a database with a table CLIENTS with fields: Customer, customername I load the DataList with the clients that are in the BD a...
asked by 13.11.2018 / 19:37