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
answer26
viewsProblem displaying items in a qtablewidget
Only the first two rows of the table are filled, but the table row numbers are filled as the result of the query and in the print displays all items normally,. def escreveArquivo(self): con =…
-
0
votes1
answer3813
viewsHow to resolve this 'Undefined variable' error when accessing a view in Laravel 5.1?
My problem is this: I uploaded the data to the banner view, which is included in the main view, this in turn is expanded in the home view, is working well. But when I try to access another view…
-
0
votes0
answers228
viewsHow to make a routine of sending certain data from one Mysql database to another
I’m a beginner and enthusiast in web programming. I try to develop a system that works basically like this: I have a contact log, only running on localhost (PHP and Mysql) - because I need a system…
-
0
votes1
answer53
viewsPHP break list items "<li>" into variables to add in MYSQL table
I have a form with <textarea> with the following value: <textarea id="lista-ingredientes" name="lista-ingredientes"> <ul> <li>sal</li> <li>pimenta</li>…
-
0
votes1
answer74
viewsCheckbox filled
I have a script that the user inform the ID fields are completed: name and inactive, if the user has marked the inactive checkbox when registering return the checkbox filled and if you have not…
-
0
votes1
answer206
viewsPick up information using a dropdownlist as select
I need to make a basic supply system, where when selecting the type of fuel, it brings me the last registered value of that product and automatically select and still automatically insert in Textbox…
-
0
votes2
answers613
viewsArranging html and css table layout
I have a page in php that searches for mysql data and shows in a table: However, when I shorten the window, the tables and the header are "disorganized", thus: How do I "lock" the tables and they do…
-
0
votes0
answers51
viewsSQL does not return all table records
My application consists of an html page in which the user informs the code of a product, the quantity, and it is shown below. Behold, if I add a product, it is inserted but does not return. And when…
-
0
votes1
answer76
viewsUnable to Retrieve Metadata for - Error creating Controller
I created a web project with MVC and Entity framework 4.5, and MYSQL database. added the dlls Mysql.Data Mysql.Data.Entity and Mysql.web I made all settings as per images below I followed the step…
-
0
votes0
answers40
viewsNot recording information in the database
When informing customer data to be registered in the bank, simply does not record and does not present any error, I believe the error is here if($site->inserir('loja_clientes', $dados)) But just…
-
0
votes0
answers71
viewsProblem saving month - Mysql Workbench
Good afternoon, I am doing a project for project management and I have in the registration form, two dates fields, when entering, when I consult the bank, the dates appear with the wrong month, all…
-
0
votes2
answers94
viewsWhen submitting form, GET data is lost
I’m trying to upload the data from a form to the database. I have data coming from POST and also from GET, but when clicking on the Submit button the value of the variable that receives data from…
-
0
votes2
answers436
viewsSelect subtraction in columns of different tables
I have been trying to perform a select that subtracts a column in a table, by another column in another table. See in the image below what I need: Therefore, I need to add the column quantidade…
-
0
votes2
answers1946
viewsDatatables problems using PHP and Mysql
i made a system, where the user can create table for the database, and tbm can create columns, so I don’t know which columns were created, but with the database script I can list the columns of this…
-
0
votes2
answers127
viewsConvert HTML5 table + images to CSV or SQL
I’m in big trouble! I have basically 1.5 million records including images in an HTML5 table (it already starts there, the browser does not render all images). My idea was to convert this table to…
-
0
votes1
answer499
viewsSwitch case on Submit button according to button ID
I have 7 buttons of Submit in a form. Being: Four of that: <input type="submit" id="chamado1" class="mr-abre-btn" value="Abrir chamado"> Two of this: <input type="submit" id="chamado2"…
-
0
votes1
answer58
viewsError in MYSQL PHP JOIN function
My JOIN function is working but I nickname the tables and even so, because the fields are identical my inputs that have the field of the same name are filled even if there is no record relative to…
-
0
votes1
answer47
viewsHow can I not let you register any foreign key?
I have a database of an electronic urn with the following tables: Voter(Pk title ) Votoscomputers(Fk quibbler , vote) To my knowledge, the table VotosComputados should not insert a FK any, and yes…
-
0
votes0
answers102
viewsLogin through a domain
I have a problem to solve. I have a social network, and I have a chat boom chat, the social network is wowonder. I am integrating the login system of the social network in the chat boom, but when I…
-
0
votes1
answer50
viewsProblem with SQL (duplicate addition)
I have a bidding system that works with a robot giving automatic bids, and also with a button where the customer can bid. When the client clicks on the button, it calls a function that executes the…
-
0
votes2
answers1035
viewsHow to insert value in mysql with PHP and Ajax
I have the following page of recipes, which brings the list of ingredients: <?php $db->setQuery("Select * from #__ingredientes"); $tmpingredientes = $db->loadObjectList(); ?> And from…
-
0
votes2
answers54
viewsDecreasing the value of two fields of a table and sorting according to the result
I have the field "killed" and "died" in the table, I need to make the order of the results come as the decrease of these two values, Example: My query is like this: $woes = DB::table('woeplayerrank…
-
0
votes1
answer35
viewsJoin in sql that returns everything
I have two tables, the episodes and episodes seen, I need to make a query that will join the two by the id of the episode, however I do not want the episodes that are not in the second table do not…
-
0
votes1
answer853
viewsInsert information into bank with AJAX
I need to enter information in the database, but I need the page not update. the problem is that I do not know anything about AJAX and even searching the codes on the net, I could not solve Like I’m…
-
0
votes1
answer40
viewsIgnore a certain value with AVG
I wish I could calculate it AVG ignore the values above 100000 (10 seconds), with the following query: user_id, COUNT(*) as total, AVG(`exec_time`) as tempoMedio, SUM(CASE WHEN `success` = 1 THEN 1…
-
0
votes1
answer71
viewsMysql IN function but my parameter comes a string
Hello, I have a trial that receives a few parameters, among them I need to receive a list of codes, which are 10 at most. But in the consultation, I’m trying to WHERE value IN(value1, value2), but…
-
0
votes1
answer145
viewsCheckbox inside of While
I am in need of replicating this table from the company’s ERP system to the WEB system. But using the code below the image I have the value of the variables that are 0 and 1. <table…
-
0
votes0
answers39
viewsArray with variaves via POST
My html is like this: <input name='nDup[]' type='text'> <input name='dVenc[]' type='text'> <input name='vDup[]' type='text'> Receiving this data via POST (which are the above…
-
0
votes1
answer112
viewsNodejs - Expect for to run all pool.query by the end
I have a small problem and as much as I have tried to find a solution, I cannot think of a great one. So I have come to ask for your help! So here’s the thing, I’m currently developing a betting…
-
0
votes2
answers259
viewsSingle auto increment on all DB tables
Hello, my DB has several tables that have the same column: `PROD` int(11) NOT NULL AUTO_INCREMENT This column is an identifier that makes one that makes an increment with each launch. The issue is…
-
0
votes2
answers815
viewsSelect averaged in minutes - Mysql
Below is a query returned in a table of my database (Mysql): What interests me are the Timestring, Varvalue and id columns. Every 5 seconds on average an Insert is made on my system. I have 1 month…
-
0
votes1
answer65
viewsFill input2 from input1?
I have the "input1" that searches the name of a client and saves his id in the table, this search is done by autocomplete with Javascript. Now I needed that in "input2" I received the id of the…
-
0
votes1
answer347
viewsScript smaller than 18
I’m making a record that’s only allowed for people over 18, I made a script that is catching two days ahead in the case today and day 02/11/2017 so only user who were born from the day 02/11/1999…
-
0
votes1
answer200
viewsError executing mysqli_query() in BD Select
When I will register something in the database of this PHP code <?php session_start(); include_once("../seguranca.php"); include_once("../conexao.php"); $nome_nivel = $_POST["nome_nivel"]; $query…
-
0
votes2
answers1610
viewsAutomatically update timestamp on update
Using the UPDATE CURRENT_TIMESTAMP it is possible to automatically update a field from a table in the Mysql database? I want the inclusion date to be assigned to the fields: dt_cadastro and…
mysqlasked 7 years ago Wagner Fillio 1,328 -
0
votes2
answers250
viewsOrder By in 2 MYSQL tables
Good morning! I am going through more moments and I would like your help with this problem! Come on, I’m doing a select in MYSQL where several tables are selected, in opencart to generate an XML for…
-
0
votes1
answer98
viewsMake Join with table columns where id equals variable
I have 4 tables they are already with Foreign key. aluno: id matricula username curso_id // referencia a id_cursos da tabela cursos, coluna id_cursos. cursos: id_cursos nome_cursos modulos:…
-
0
votes0
answers76
viewsHow to convert `data java.util.Date` to `java.sql.Date`?
The idea is to consult the data by dates in the database (Mysql): I have 2 fields JXDatePicker and I want the return of the data between the initial date and the final date. In Mysql, the field date…
-
0
votes1
answer56
viewsHow to make Join with multiple tables?
I have 4 tables they are already with Foreign key. aluno: id matricula username curso_id // referencia a id_cursos da tabela cursos, coluna id_cursos. cursos: id_cursos nome_cursos modulos:…
-
0
votes1
answer386
viewsUpdate a multi-student Mysql field
I have a table of students where they have a field of presence where they are recorded present and absent. When I created the camp, I left everyone as absent, and now I need to list and change some…
-
0
votes1
answer278
viewsCan I create an event in Phpmyadmin?
I want to create an event in Phpmyadmin, where each day implements +1 in a field like int, but on my local server works normally, on hosting says I need the user super global, all right so far,…
-
0
votes1
answer1037
viewsDynamic Table with Ajax and JSP
I am learning Java Web and would like to know if they could help me in the following: I have a form that I insert data into the database, and below it a table in which I list what was entered into…
-
0
votes2
answers218
viewsInsert data into the database with php
I’m trying to insert some data into the database via php, but it can’t add this data, would anyone know what it might be? I give a var_dump in the array to see if it is pulling the data correctly…
-
0
votes1
answer32
viewsMYSQL and condition
I need to make a select in my same database is below: select * from tbl_frete f join tbl_transportador t on f.idtransportador = t.idtransportador join tbl_cliente c on f.idcliente = c.idcliente join…
-
0
votes1
answer22
viewsTypes of repeated filter records
I have a form with a service search filter that takes the options from a column of my database table. The problem is that more than one person provides the same service, so more has more than one…
-
0
votes1
answer1029
viewsDifficulties with PHP - lastInsertId()
I’m having trouble getting the last id inserted in my table using the php PDO function lastInsertId() How do I get the last id inserted in my table using my structure? Connection to the bank class…
-
0
votes1
answer218
viewsI want to display data from a foreign key table in my main table, how do I do?
In PHP as I do instead of the foreign key id, the field that has the data appears? I have a table room that has, column id, spine nome and column tipo. And also I have the table of movies, the movie…
-
0
votes2
answers53
viewsI can’t get the seat
I’m using bootstrap in my first high school project and I’m having difficulty in PHP, HTML and Mysql interaction Besides not being able to insert in the bank, I need to insert in the…
-
0
votes2
answers392
viewsError in Trigger - Mysql
I created the following Rigger, but it has a syntax error that I can’t find. The error is as follows ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that Corresponds to…
-
0
votes1
answer50
viewsError Returning Query Using Like
I am trying to make a jpql query with like using JPA. However, it is not working. User class repository public class UsuarioRepository extends RepositorioGenerico<Integer, Usuario> { public…