Questions tagged as 'mysql'

Tagged questions
1
answer

Import data into mysql from a layout

I'm importing some data into the table "tb_usuario" that comes from a text file, it works as a layout for importing these records, I used a semicolon to delimit the position of this data in the file, causing it to be inserted in the database of...
asked by 01.02.2018 / 11:09
1
answer

Recover field without include / require

I have a report created in mPDF that performs a select through the following function that is found in the page "registra_people.php": include_once("registra_pessoa.php"); $pessoas = filtraPessoas(); Follow function: function filtraPessoa...
asked by 02.02.2018 / 19:43
1
answer

How to select and assign the quantity

I'm trying to use mysql to select two tables and assign the number of rows to a field eg I have two tables : Group, Person I want to make a join in the Group table that shows the number of people assigned to this group through the Gro...
asked by 01.02.2018 / 17:51
1
answer

Select result, and only show if all are equivalent

I'm servicing a database, and I have the following situation; in the database I have 5 columns in a table, they are:    ID (PK) | IDBillet | Result | Borrowed | Date | I have to filter for the user to see, only the IDBilhete that is missi...
asked by 01.02.2018 / 15:34
3
answers

Search for a higher date by a specific ID

I have a problem with a SQL where I need to search for the largest date of a specified ID , where it has several records of this ID : Data:    ID - date - name       2 - 10/10/2004 - cesar 5 - 10/10/2008 - joana 4 - 1...
asked by 01.02.2018 / 13:02
2
answers

Add variable value with foreach

I have a variable that performs a select function, returning two values from the database: $grupo = selectContas(); I would like to add these two values and save them to a variable, but only the value of the last record is being saved. &l...
asked by 30.01.2018 / 18:06
1
answer

Use Rand and randomly assign all columns

I have this table (centrodb.InfoColaboradores) which has the ids of all the other tables that I make the join in the database with this data: I have this query: SELECT B.NomeColaborador, C.Ala, D.Grupo, E.Turno F...
asked by 31.01.2018 / 10:52
2
answers

How to join these 2 SELECTs in the same query

Good morning, I'm redoing the question because the last one I deleted because it was a bit confusing. I have these two select and would like to join them to return the result for a comparison chart. This SELECT query and returns me the nu...
asked by 01.02.2018 / 15:23
1
answer

Error creating hibernate tables

I'm getting the following Exception when creating the tables in my application: Hibernate: create table UserConfig (id bigint not null, dateReg datetime, status varchar(255), accountActivationCurrentToken varchar(10000), forgotPasswordC...
asked by 06.02.2018 / 18:11
2
answers

Upload csv file with ajax, json, php and mysql

I'm trying to make a import of a file csv to MySQL dealing with errors with JSon but I can not, even with a basic test I can not return the message, it always falls in else if . This is the form: &l...
asked by 06.02.2018 / 17:18