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
votes1
answer335
viewshow to run a previous with parameter in php
I need to run a precedent by sending a parameter by php no longer returning follows the code below: //código em PHP $figura = mysqli_query($conexao,"CALL `spare_change`.`boxlabel`('".$template."')")…
-
0
votes2
answers16
viewsHow to select most used foreign key?
I’d like to make one SELECT where to select foreign key(idTema) most used Example: That in the example above would be 1 What would that be like SELECT?…
-
0
votes1
answer133
viewsSearch data from a database table
I ask for your help in my code. I’m creating a php code that can make reservations for certain cars, the basic thing is to book the car for user x I can already do. The problem, which will actually…
-
0
votes1
answer160
viewsMake two queries in the same table in Mysql
I have a table in Mysql database where I will make a query. This query needs to be done as follows: For those who have a plan on the site: Allow searching by: name, category (different table),…
-
0
votes2
answers53
viewsHow do I save to the database when a "user" or "admin" edits or registers a new item?
I want to know how to save the actions,type, when admin, log in and drop, change a register or create a new register??
-
0
votes1
answer65
viewsInjection of dependencies failure
I am new to the world of Hibernate and when I run this application, I get the following exception (error refers to persist EntityManager): java.lang.NullPointerException Caused by:…
-
0
votes1
answer32
viewsError searching in Database
My application is integrated to my bank and makes several queries, but in one of them something unexpected is happening, because the search is not performed. Note that my instruction line is simple…
-
0
votes3
answers718
viewsHow to convert date to date in select query?
Follow the picture below: Follows the code: select dt_abertura, count(1) as qtd from tabela group by dt_abertura; How to convert date to time (2017-09-23 16:24:55) for date only (23-09-2017) ? I…
mysqlasked 6 years, 11 months ago Francisco Carlos Carvalho Jr 103 -
0
votes2
answers84
viewsValidation of 2 fields in a table
I have a table in Mysql, with a DESCRIPTION field and another Degree, as I do so that the set of the two fields cannot be repeated? EXAMPLE If it is: DESCRIPTION: abcde GRAU: 12345 OK And if it is:…
-
0
votes0
answers35
viewsPHP query with response from another query
I run a query that returns me a list of Ids. With each ID of this list I want to do an Insert in a second table. My code: <?php $db = mysqli_connect("localhost","root","","test") or die("Erro ao…
-
0
votes0
answers186
viewsHow to update several rows of a codeigniter table
Hello, I’m having the following problem, I have a stock table. follow img: these stock products are grouped every time I give an entry it adds to what already exists and creates a new line in the…
-
0
votes2
answers895
viewsPHP PDO Notify user which registration name already exists
Hello. The code below does not allow the user to choose an already used name. But I would still like to warn the user who chose the wrong name so he knows he needs to choose another registration…
-
0
votes2
answers625
viewsSearch in 2 fields at the same time
Eae, I have two fields in a mysql table, Description and degree. how do I do when I search type WORD and 4 ( being WORD from the Description field and 4 from the Grade field? a result appears? PS.:…
-
0
votes1
answer589
viewsExport Sqlite to Mysql
I used Sqlite for a project, with it it is possible to create a database with format '.db' and see inside and everything else. Would it be possible to export in Mysql a database file created in the…
-
0
votes1
answer348
viewsInsert progress bar with php - Bootstrap
You can insert a progress bar using bootstrap for the amount of data entered into a given table in the database? Ex: If I have 100 entries the bar would progress to 100.…
-
0
votes1
answer136
viewsCross Table in Mysql
Does anyone know how to implement a Cross Table in Mysql to help me? I need to transform a query that always returns 4 result lines to only 1 row by placing each row field in columns next to each…
-
0
votes1
answer375
viewsneed help with this error: Uncaught Typeerror: Cannot read Property 'push' of null Vue.methods.addPedido (Anonymous Function)
Problem When will I call the function addPedido with the v-on:click="addPedido" Vue.js error Uncaught Typeerror: Cannot read Property 'push' of null and presented could not identify the urgent need…
-
0
votes0
answers58
viewsWhat is the best way to save data in real time?
Guys, can you tell me how to best save data in real time? For example, I have a news portal and need to save every access I receive and show on a private panel, but in case my site has 30,000…
-
0
votes0
answers244
viewsPartitioning MYSQL tables
Good night to you all. I have a question regarding tables in mysql. Assuming the following scenario. I have a MYSQL INNODB table with PK ID INT UNSIGNED. ( 4 billion records approx) 1 º If by chance…
-
0
votes1
answer128
viewsDate formatting to save to Database
How to do Date Formatting in php, receive default date (d-m-Y) and save to Database (Y-m-d). This is the code line used within the input (Y-m_d) value="<?php $date = new DateTime('');…
-
0
votes1
answer30
viewsInsert value in javascript by taking php-mysql
Hello, I’m not programmed, but I’m doing a website where I want to place an accountant to determine what the expiration date of the website registration will be. I used the 3D Cube Countdown script,…
-
0
votes0
answers133
viewsAccess denied for user
I’m trying to generate a few pages through a program called PHP Generator for MySQL and I am getting an error message that is not possible, the site access normally with the Host passed by the…
mysqlasked 6 years, 10 months ago adventistapr 5,498 -
0
votes0
answers246
viewsError 1042 when installing Mysql 8.011 in win 10
This error appears in the Starting Server part.…
-
0
votes1
answer69
viewsDuvída in a Query that selects in two tables
Good afternoon, I am making a system of equipment scheduling, for better understanding I will put on topics some important information. Each schedule has a numbering of the equipment that will be…
-
0
votes0
answers67
viewsTrigger mysql - error?
Hi, this is the first time I’m using triggers and I don’t know how to fix an error I’m having and a problem I don’t know how to do. I want to do a Rigger for when a date entered (start date and end…
-
0
votes0
answers29
viewsJoin Only 1 result
Does anyone know how to make a Join return only the first result ? ->join('addresses', function ($join) { $join->on('s_complete_clients.id', '=', 'addresses.client_id')->limit(1); })…
-
0
votes0
answers192
viewsHow to fix a connection error on a website?
Currently I administer the site of a Town Hall, and today, out of nowhere, the following error began to appear: Warning: mysqli_connect() [Function.mysqli-connect]: Headers and client library minor…
-
0
votes0
answers918
viewsShow result grid in mysql Workbench
When running queries on my MYSQL Workbench, I cannot see the Result Grid, only the output screen saying whether there was an error while executing the command or not. How can I activate the Result…
-
0
votes2
answers558
viewsMultiple if in one SQL condition
I’m trying to use 2 ifbut the result always returns empty, when I use only one if he will. SELECT aci_codigo, aci_valor_pagamento, bai_fk_pes_codigo, aci_tipo_pagamento, aci_fk_ftm_codigo,…
-
0
votes1
answer28
viewsDoubt with this query
My teacher made the following query, to show the total amount of stock of each product, however I do not understand very well how it does to generate the total stock quantity of each product,…
-
0
votes1
answer818
viewsHow to take a screenshot save to the project folder and save the path to the Mysql database?
So I have a jsp with form,it converts the image to B64 and sends as string pro Servlet Servlet converts to b643 String stt = request.getParameter("base64img"); try{ String parts[] = stt.split(",");…
-
0
votes0
answers95
views -
0
votes1
answer48
viewsInsert users into different databases
I have two databases. Database A, and Database B. The user makes his registration in the database system A. I want to create a trigger for the same time, this registration also go to the database B,…
-
0
votes1
answer1444
viewsERROR 1242 (21000): Subquery Returns more than 1 Row
I have a problem with a Trigger (Mysql). I tried to build it myself. The need: I have a system of occurrences where when moving to the closing stage (Stage 4) it check if a description has been…
-
0
votes2
answers516
viewsInsert with PDO and INNER JOIN
I have a table person who owns the fields name, city and phone and time_id. I also have another table with a team name and in it I have a field called meu_time, as I can do an INNER JOIN to register…
-
0
votes1
answer47
viewsDifficulty handling the query
Personal I have the following query: SELECT p.ra, p.nomealuno, qa.respostaaluno, q.respostacorreta FROM prova p INNER JOIN questoes_aluno qa ON qa.idprova = p.id INNER JOIN questao q ON q.id =…
-
0
votes0
answers340
viewsRecord date with thousandths of seconds
I have an application in which two users can update an item in the database, however I kept thinking about the following situation: If they click to sync at the same instant, including…
-
0
votes1
answer66
viewsOnly register once and then stop
I am making a virtual sales store using HTML/CSS/PHP for the course work and am getting the following BUG: I created the code for the processing of user registration, when I create the first user…
-
0
votes1
answer105
viewsMysql Left Outer Join show only first result
I need to make this sales chart Join with the Nfe table, however the NFE table may have more than one result which causes change in total sales, how can I change this Join so that only take the last…
-
0
votes0
answers250
viewsChanging the default apache port does not resolve on Windows 10?
I did the normal installation of xampp, after running xampp-control I’m having the errors: 10:20:09 [mysql] Error: MySQL shutdown unexpectedly. 10:20:09 [mysql] This may be due to a blocked port,…
-
0
votes2
answers47
viewsInsert filesystem image name in mysql
I use Debian, and I need to capture the image names of a folder and insert the names (as string) into a mysql table. ss:~/folder_img$ 859034809583_img.jpg 458389547389_img.jpg ... This problem has…
-
0
votes1
answer524
viewsSimple C# MYSQL connection problem
Speak guys I’m with the following error when trying to make a simple Insert of an activity in my mysql database "System.Argumentexception: 'The boot chain format does not conform to the…
-
0
votes0
answers200
viewsInsert data into related tables
I’m making a small bulletin board with the option of replies to the comments. I managed to do a lot of code, but as I have been away from programming for more than 10 years (my focus today is Linux…
-
0
votes3
answers64
viewsDifficulty when mounting SQL query
Whoa, guys. I’m having difficulty to mount a query in Mysql. The thing is, I have a table with the following structure The time_orange and time_blue columns store system user ID’s. I need to search…
-
0
votes1
answer44
viewsSelect using an array?
I have the following array: var arr = ['A', 'B', 'C'...]; And in my database I have the column categoria where values are saved in the following mode: 'A,B,C...', how could I make a SELECT picking…
-
0
votes1
answer52
viewsaccents between php and mysql how to use?
what is the correct way to create the database and tables in mysql 5.6 to meet Brazilian standards of characters? my php version is 5.6 and I use the following information in the php file header…
-
0
votes1
answer63
viewsFilter dates when user entered our system
I am trying to filter the dates when users connect to my system. Have a however, first need to filter so there are no duplicate users. I’m already doing it using the argument DISTINCT in my query,…
-
0
votes0
answers77
viewsErrors trying to update mysql script to mysqli
<?php Class mysql { public $query; public $data; public $result; public $rows; public $page = 0; public $perpage = 10; public $current = 1; public $url; public $link = ''; public $total = '';…
-
0
votes1
answer1219
viewsI need explanations of OUT mode and INOUT PL/SQL and Mysql Procedure
Well, I put PL/SQL and mysql because these two modes have in the procedures both Oracle and mysql but anyway.. The IN mode I understood that it works as a Constant, it is passed by the parameter and…
-
0
votes0
answers591
viewsSynchronize sqlite with an online database
I need to synchronize (one throwing information to the other) a DB sqlite with some DB server like sqlserver or mysql, and I would like to know how I can do this, I am using the language C# with…