Questions tagged as 'mysql'

Tagged questions
1
answer

Call controller result foreach result and show in view

I need to retrieve a method in the controller and display it in the view, Controller namespace App\Http\Controllers; use Illuminate\Http\Request; use App\Models\Categoria; use App\Models\Sessoes; class todosProdutosController extends Controlle...
asked by 15.05.2018 / 21:27
1
answer

How popular is a postgres table with JSON?

I'd like to populate my tables with Json. But I can not. Does anyone have a solution? Follow JSON: link     
asked by 16.05.2018 / 01:25
2
answers

Auto Cast with TypeScript?

Straight to the point: Is there a way to perform auto cast using an interface as a template in Ionic (TypeScript + Angular 5)? If not, can Lint recognize that an object coming from the server is not within the expected interface contract?...
asked by 01.03.2018 / 22:50
1
answer

Jquery - Retrieve the value of a 'td' and insert inside a Text

Good evening, Next, I have a table from which I generate the data from mysql, I want to get the value of td, and insert inside a TEXT that will appear inside the table TD with the value that was there so that it can be edited and updated in t...
asked by 22.02.2018 / 00:44
1
answer

Write numeric topic (1 1.2, 1.2.1) in MySQL with PHP

I have the following problem: I need to write in a database some constraints, which have their item numbers and subitem as in this example: Test 1 Test 2 2.1 Test I tried to do with numeric(4,2) or float but when it h...
asked by 21.02.2018 / 22:15
1
answer

Update command to remove recorded data accents?

Is there an update command to remove accents from names saved in tables, eg: update paciente set 'Ã' = 'A' Of course the column name is not this, just an example.     
asked by 23.02.2018 / 19:13
1
answer

How to use NOT IN with data from another server in PHP

I've set up a table with Data that no should be fetched, I'll call it here Table . The data that was in this table are these: |Tabela_Not| Londres Tóquio Paris And I applied this Query to do searches by dropping the Table_Not ite...
asked by 23.02.2018 / 17:34
1
answer

Aggregate function with MIN (), GROUP BY, and Subquery

I'm having trouble building a query from an address table with latitude and longitude. I have a function that does a distance calculation, I called it from: distance_latlng_km(originLat, originLng, destLat, destLng) . In the table y...
asked by 22.02.2018 / 21:19
1
answer

SQL function with mySQL

I'm implementing a function for a vendor search field and my sql function is in trouble, would anyone know which problem? This was a function of when I used postgree, but now I'm using mySQL. package br.com.project.bean.geral; import java.la...
asked by 14.06.2018 / 04:29
1
answer

Prevent values from some columns being repeated, MySql

I have the following MySql query, the results are shown as in the image below, I would like to not repeat the values of the Aluno and NotaGeral columns based on the Usuario column which is a single value. do not just ask not...
asked by 14.06.2018 / 15:48