Questions tagged as 'mysql'

Tagged questions
1
answer

Associate logged in user with your information?

After doing the "session", how do I bring the user information logged in? I know it's not just creating a session, I need to bring user information like Name / Nickname, avatar, email etc.     
asked by 23.08.2017 / 19:51
1
answer

How to put two records from one table in another as a single in select MySql Bank

How to put two records from one table in another as a single MySql select bank? SELECT TURMA.turma_id, TURMA.turma_nome, PROF.prof_name from turma TURMA LEFT JOIN professor_materia PROF_MAT ON TURMA.turma_id=PROF_MAT.prom_mat LEFT JOIN profe...
asked by 02.09.2017 / 21:44
2
answers

Breaking table on multiple pages

I'm creating a Web application that displayed two equal sized tables However, both have about 100 rows each, I would like to display only 25 rows from each table and to see the rest of the table would have those subsequent pages: 1, 2, 3, 4 ......
asked by 14.09.2017 / 18:48
1
answer

Returning external Array when taking data with Laravel

I have a column called clube and in a row it has the following {"clube":["Santos"]} , using that form for the data $clubes = Socios::where('socio', $socio)->select('clube')->get(); It returns me this way [{"clube":"{"c...
asked by 12.08.2017 / 00:08
1
answer

Control of database (MySQL) in production environment

For a good part of my project I have been working with a git repository on a local server, (Debian 7), this week I migrated to gitlab, with no complications in the change, I only changed because of portability, since I'm always working on a loca...
asked by 07.08.2017 / 20:57
1
answer

How to save records from a mysql query in C ++

I'm using a C ++ library that does the query in the database. My goal is to do a query, and save the data in a txt file, maybe even manipulating it to get json format. The problem is that I can not retrieve the value of the records when saving t...
asked by 04.08.2017 / 00:02
1
answer

performance in a select query [duplicate]

For the DBMS it is faster to get the fields all explicit or to use the * character representing all fields. If there is a difference what is the reason? Select coluna1,coluna2,coluna3, .....,colunaN from Or Select * from    The ques...
asked by 27.08.2017 / 23:16
1
answer

Store data in JSON in MySQL

I have a database in Mysql where, as the project is being developed, the number of fields in some tables has grown exponentially. The People table, for example, has fields related to personal documents, home address, work address, personal da...
asked by 14.08.2017 / 04:53
1
answer

Count in multiple tables

I have 3 tables Ineedaquerythattakesthenameoftheschool,amountofclassestypeA,qtdeofclassestypeB,qtdeofstudentswhoareinclassestypeA,andqtdeofstudentswhoareinclassestypeB.>Sameasthisexample: I tried to do Select E.NOME, SUM(CASE WHEN C...
asked by 14.08.2017 / 19:03
1
answer

How to fix the error: Method getClientOrinalExtension does not exist, in image upload with laravel 5.4? [closed]

Once again I need your help a lot. You are giving me the following error when uploading image in laravel 5.4:    Method getClientOrinalExtension does not exist. The following is my controller and the view: Controller namespa...
asked by 06.08.2017 / 01:12