Questions tagged as 'mysql'

Tagged questions
0
answers

MySQL Read HTTP URL

I would like mysql to read a url through a SELECT I searched and saw that you have a here answer. I did the whole procedure as it is in this link , but without success The select would call the url as in this example here...
asked by 25.07.2018 / 23:48
0
answers

assign last field of a table to an input text

I have a table that stores the supplies of a vehicle and would like to make the following code work. I need to get the last record with the mileage of the odometer and already bring the specific input text, called kmPrevious. It has to be the la...
asked by 28.07.2018 / 20:43
2
answers

How to edit MySQL records with a PHP table out of order

I'm creating a document request system, and it has a page where it shows all the pending requests. These requests are recorded in a MySQL table and shown as in the image below. Theproblemisthatinthe"Actions" field you can only execute someth...
asked by 28.07.2018 / 20:52
1
answer

Error 1054 in Database

A Database Error Occurred Error Number: 1054    Unknown column 'referencia.idReferencia' in 'on clause'       SELECT os . , clientes . , facas . , usuarios . email , usuarios . nome , referencia...
asked by 29.07.2018 / 00:13
1
answer

Sum of MySQL column values

I have the following MySQL tables: CREATE TABLE IF NOT EXISTS 'tcc2'.'catalogo' ( 'idPHL' BIGINT(20) UNSIGNED NOT NULL, 'isbn' VARCHAR(15) NULL DEFAULT NULL, 'titulo' LONGTEXT , 'autor' LONGTEXT NULL DEFAULT NULL, 'edicao' VARCHAR(45) NULL DEF...
asked by 28.07.2018 / 22:34
0
answers

Insert / get multiple tables without Id

Good afternoon guys, I have a problem affecting me a few days already. The situation is as follows, I have a simple relationship: There are tables person, street, neighborhood, city, state, parents all mounted from Hibernate classes using JPA. I...
asked by 24.07.2018 / 21:19
2
answers

How could I improve this SQL query with sub querys?

There are many sub selects, how could I improve this query in MySQL and make a sum of max of 'total_points_period'? Take the total of points for a period of the "user_bigdata" table and the total points of the "olympic_players_niveis" table a...
asked by 24.07.2018 / 19:33
0
answers

Which way to use to update table in PHP / MySQL / HTML?

Good afternoon! There is a form that when completed should be done UPDATE in a table in MySQL. Below is the form and just below the table with the checkbox's that will signal which line should be updated. How do I implement this knowin...
asked by 24.07.2018 / 22:29
0
answers

How to make two queries in the same column and table in mysql

I need a little help, I'm using the mvc standard with codeigniter and I need to echo the view, searching for values from the same column from the same table. So in my view I have two input text where I would call the users name by ID, the fact t...
asked by 24.07.2018 / 16:33
0
answers

Import phpmyadmin

Hello, I would like to know, how do I import only a few fields in phpmyadmin. Example: In the database I have the users table, it has the fields, id | name | password | created | modified | home_jornada_work | end_jornada_work. In this...
asked by 06.08.2018 / 15:11