Most voted "mysql" questions
Mysql is a relational database management system (RDBMS) that functions as a server, and provides access to multiple users simultaneously. Your source code is available under the GNU General Public License.
Learn more…10,264 questions
Sort by count of
-
0
votes0
answers50
viewsProblems to list BD MYSQL in eclipse
I’m having a problem in my Java code at the time of listing the Mysql BD in Eclipse. It turns out that when I put it to list the data, it’s listing the information 3 times but when I do the SELECT *…
mysqlasked 6 years, 10 months ago Allan Jaqueira 1 -
0
votes1
answer107
viewsPHP: Upload files works for images but does not work for PDF files
I’m having a strange problem: my form works for uploading images but does not work for uploading PDF files. My code is this: $titulo = $_POST['txtTitulo']; $descricao = $_POST['txtDescricao'];…
-
0
votes0
answers38
viewsCount the number of times a category is chosen by customers!
I have a table with categories, and each client who registers can choose up to 10 corresponding categories that corresponds to his work! These categories in the client table are saved the ID’s , I…
-
0
votes1
answer610
viewsPass variable query buider Laravel
I am trying to do this function with Laravel Query Builder public function getEstudantesCargaHoraria(Request $request) { $ano_letivo = $request->ano_letivo; $turma_id = $request->id;…
-
0
votes1
answer89
viewsSpecial Character appears in Lowercase - PHP
I have the following PHP page: <?php session_start(); ?> <!DOCTYPE html> <html lang="pt-br"> <head> <title>Consulta de OP's por OP</title> <meta…
-
0
votes1
answer36
viewsDelete two ID’s from different tables in the same query
Good afternoon! I have two tables: 1st question and second answer, and question_id is the key that allows connecting the two tables, being the foreign key in the "answer" table of the "question…
-
0
votes0
answers49
viewsProblem with connection to mysql database configured no more goes up
I’m trying to upload a local system but it’s not connecting to the database. I’ve already made the settings. I’ll leave the error below if anyone can help me thank. here and the configuration in the…
-
0
votes1
answer72
viewsMysql table with performance problem (Too slow)
I have a MYSQL table with only 31,000 records and she’s very slow when I’m going to consult, but I have no idea how to fix it. This is her creation script: CREATE TABLE `PHOTOS_Data_Base` (…
mysqlasked 6 years, 9 months ago Leonardo Bonetti 5,313 -
0
votes0
answers68
viewsjava.lang.Nullpointerexception - Having to add a user to the database but points out this exception
Follow the code of the connection to the database, the user class and the code already in jframe: /* * To change this license header, choose License Headers in Project Properties. * To change this…
-
0
votes2
answers1354
viewsSelect from cursor
I am trying to make a trial with the following mysql block: DECLARE done INT DEFAULT FALSE; DECLARE v_id INT; DECLARE R CURSOR FOR SELECT id ,nome FROM pessoa d DECLARE CONTINUE HANDLER FOR NOT…
-
0
votes1
answer3655
viewsFatal Error : Call to a Member Function bind_param()
I’m getting this problem: Fatal error: Call to a Member Function bind_param() on Boolean in C: xampp htdocs Myworld Register create_user.php on line 32 When executing this code: $email =…
-
0
votes0
answers191
viewsPHP/Database, add MD5 and check
Well, I use the following code to p/ make a check if the user exists and log in: <?PHP include('config.php'); include('menu.php'); # Validar os dados do usuário function…
-
0
votes1
answer223
viewsSQL SERVER Filter
I have an exercise to do but I’m cracking my head here: "SQL command that brings me the sum of the salaries received per employee and status in the year 2014 of the tables: SALARIES / EMPLOYEES /…
-
0
votes1
answer140
viewsHow to encrypt Stringconnection to a Mysql remote database in C#
I am developing an application that I intend to sell, and so I created a serial verification system, which checks if that activation code is already associated with the PC MAC. I do this by…
-
0
votes1
answer299
viewsModal receiving data from the database
my products page displays from the database all registered products as div below. <?php $id_up = $GET["id"]; require("funcoes/conexao.php"); $quantidade = 10; $p = (isset($_GET['p'])) ?…
-
0
votes2
answers110
viewsError Trying to get Property... PHP + Error og:image API Facebook (Share)
I have other examples here but none worked for me I have an instruction to pull an image from the database, only it’s giving the error "Notice: Trying to get Property of non-object in ..."; $q=…
-
0
votes2
answers169
views -
0
votes1
answer74
viewsIF record = X, LEFT JOIN in table 1, IF record = Y, LEFT JOIN in table 2
I have a table called "system_signature" containing these fields: - Tipousuario - usuId This user must save a user’s ID, of course. But this user can have 2 types (Student and Client). The data of…
mysqlasked 6 years, 9 months ago Maykel Esser 598 -
0
votes1
answer112
viewsMissing IF in Procedure
I did the following study, but in the END// appears 'missing if', someone knows why? William helped me with this problem, but every time I try to register, the trial only goes to the last else. I…
-
0
votes0
answers36
viewsI need COUNT to return 0
I have two tables with the following data: I want to rescue from the database all users and the amount of jobs they have performed. I was using the following SQL: SELECT u.usuario, COUNT(t.id) AS…
-
0
votes0
answers226
viewsSave a JSON to the database or create an intermediate table?
Good night! I am in a small Dilemma, I am building an application to control events,in this application I have an event that can have several guests in the Front end I am thinking of using a…
-
0
votes1
answer2104
views -
0
votes1
answer293
viewsSelect com group by duplo
In Mysql I have a table called contact_status: id | id_contato | detalhamento_id 1 | 1 | 2 2 | 1 | 3 3 | 2 | 4 4 | 2 | 2 5 | 2 | 1 6 | 3 | 2 7 | 4 | 4 8 | 5 | 4 In it is recorded all the contacts of…
-
0
votes2
answers436
viewsReceiving HTTP POST Json with PHP MYSQL PDO
I’m having a hard time solving a problem and I’m counting on your help. I am receiving, from an external API, an HTTP POST request in JSON format with some information. I need to take this…
-
0
votes1
answer56
viewsMMN ranking query
Hello, I have the following problem: I made a micro-social network for managers, where initially the registration is made only by invitation, thus "measuring" the influence of each one. My problem…
-
0
votes0
answers211
viewsRemove quotes when uploading csv
I did the following instruction to upload a csv to the database: public void importarBaseBruta(File arquivo) { try { this.limparBaseBruta(); this.con.conectar(); this.stm = this.con.getStm();…
-
0
votes1
answer415
viewsMysql Join check IF data does not exist in another table
TABLE "profile" id nome 1 UserA 2 UserB 3 Usuario1 4 Usuario2 5 Usuario3 6 Usuario4 TABLE "friends" id amigo1 amigo2 status 2 3 2 1 4 4 1 1 5 2 5 1 6 1 5 1 7 6 1 0 If I use Join, to return friends,…
-
0
votes1
answer80
viewsHow to make relationship between 5 tables?
I have the following tables: conteúdo, aulas, curso, turma, grupo_User where logic will be the following: Content can belong to several classes, as a class can have several contents A class can…
-
0
votes0
answers244
viewsRun Websocket with the hosted application
The project is a chat with php, Mysql and AJAX. I am using a Websocket with Ratchet to run in real time. It ran all right on the localhost, but when hosting the project I could no longer open the…
-
0
votes1
answer562
viewsFilter system by category
I wanted to make a search system where I would search data typed according to the selected category, but I do not know where to start. I’d like to add the option of filter for category followed by a…
-
0
votes1
answer1891
viewsPerform two COUNT with INNER JOIN
When using the SQL below to carry out the count of the number of brokers in a table using INNER JOIN, works perfectly. SQL: SELECT conta.acesso, count(corretor.cod) as num_corr FROM conta INNER JOIN…
-
0
votes1
answer212
viewsError connecting to Mysql with PHP and Docker
I am running the Docker and in the settings step correctly the credentials for the connection to Mysql(Mariadb), but always returns the following error:…
-
0
votes0
answers53
viewsASP Classic & Mysql - Find out which page the X record is on
I have a problem that I think is more logical than language itself, but if you can answer in ASP Classic already helps enough. I need to create a function, where given an X record, and a number of…
-
0
votes0
answers362
viewsError - Connect to Mysql with PDO
I’m trying to connect to a Mysql Database Remotely, through PDO + PHP. Mysql Database is managed by a team, I don’t have access to it. The Database was created and the tables were created. My user…
-
0
votes1
answer938
viewsError connecting spring boot to mysql
The error in spring boot is : Error Starting Applicationcontext. To display the conditions report re-run your application with 'debug' enabled. 2018-07-14 16:11:53.259 ERROR 13188 --- […
-
0
votes1
answer72
views -
0
votes2
answers335
viewsUnion problem in mysql
I am trying to perform a query and is giving the following error: Unknown column 'BRANCH' in 'field list' The consultation is as follows:: SELECT TICKET, DATAHORA, TIPO, ESTADO, CRITICIDADE, LOGIN,…
-
0
votes1
answer46
viewsmysql error in creating Foreign key
I’m trying to create a Foreign key, but it’s wrong. Follow the code I’m using: CREATE TABLE foto( id INT(10), img varchar(25), nome varchar(25), link varchar(25), vew INT(10), tkm VARCHAR(100),…
-
0
votes1
answer330
viewsConsolidate all columns into one MYSQL row
I’m trying to make a query that groups all the results in one line, that is, that does not bring duplicated results. I’ve used the distinct and the group bybut one of the two has returned what I…
-
0
votes1
answer69
viewsPass data from a spinner to mysql
Hello, so my doubt is small and simple (but I can not solve kkk) just want to know how to pass the value that was selected in Spinner to the database by clicking a button, here my script…
-
0
votes2
answers103
viewsButton can only be clicked after 24 hours after click
Hello guys I have a site and want the following ( I can not do, nor found on the net ), A button that after the click is registered in db, after that the button can only be clicked after 24 hours,…
-
0
votes3
answers1061
viewsWhile Resultset.next() returning only one result
I have a problem when I put the ResultSet.next() in the while and get the information from the column of the Database returns me only one result. Table 'People': Pessoas: Idade: Marcos 22 Marcos 24…
-
0
votes1
answer78
viewsphp - fetch_assoc() errors
Good, I created this code to fetch all data through a SEARCH. If I write for example "Olaaaaa", it does not error and shows the fishing, but if I give space and excrever for example "Olaaa Souuuuu",…
-
0
votes1
answer475
viewsError trying to insert - Call to a Member Function prepare() on a non-object
I am trying to check before if a field is repeated in the database, but while running the file I get the following error: Fatal error: Call to a member function prepare() on a non-object in ***** on…
-
0
votes0
answers35
viewsMysql foreign key creation problem
I am trying to implement a 1:1 relationship between the Employee table and the User table, in Mysql Workbench, but when generating the Diagram I see that the relationship always remains at 1:n, even…
-
0
votes3
answers1387
viewsHow to use checkbox group to search with php and mysql
I’m developing an immovable site with a search, where one of the filters is the neighborhood. Currently it is a Dropbox, but I would like to swap by checkbox group to be able to select more than 1…
-
0
votes3
answers101
viewsMysql printing multiple times
I’m having a problem printing Mysql data in Eclipse. When I put to print the list of registered data it is printing 3 times each information. I know where the problem is, but I can’t see the…
-
0
votes2
answers47
viewsTotal Subrecords - Mysql
In my database I have several tables, but I’ll make a simple example of what I want to do: Assuming two tables: Table 1 id | store | date Table 2 id_2 | id_tab1_2 | product Note that the id_tab1_2…
-
0
votes1
answer129
viewsJoin Mysql tables
I have a table that has the times of the day SELECT * FROM horas The type of the column hora is VARCHAR(5) And a query containing the values of the hours SELECT DATE_FORMAT( date, '%H:%i' ) HORA…
-
0
votes2
answers113
viewsHow could I improve this SQL query query with sub querys?
There are many sub selects, how could improve this query in Mysql and make a max SUM of total_points_period'? Pick up the total points for a period from the "user_bigdata" table and the total points…