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
-
-2
votes1
answer50
viewsAll data of a query in an array
I need all the data from a select to be in an array format. All the ways I’ve tried return only the last data from the table. How should I proceed ? $sql = "SELECT * FROM Termos"; $result =…
-
-2
votes1
answer104
viewsLimit setting on entering data in mysql
Looks for a specific configuration in mysql database, formerly had a server with mysql installed (not by me), when I performed a query of Insert/update that had a content above the allowed it cut…
-
-2
votes1
answer80
viewspython does not have a mysql library.Nector in Xubuntu
I tried several things to install this blessed library, my project is for next Tuesday(02/11/2002) and unfortunately I could not install in Xubuntu... sudo pip3 mysql.connector I need this library,…
-
-2
votes2
answers37
viewsRoolback in Mysql 5.7 Workbench does not work! Help
Hello guys okay ? I’m new to Mysql, I would like to ask a question. I am using a command that is not DML. but when I give roolback, the error occurs below. Is it some configuration permission in…
-
-2
votes2
answers51
viewsHow to sort a table in MYSQL, along with the query command
I wanted to know if it is possible to sort a table in Mysql, and in this same line of code a search query. $ resultado_consulta="SELECT * FROM alunos WHERE nome_aluno LIKE '%$pesquisar%' LIMIT 5"; I…
-
-2
votes1
answer394
viewsJDBC Mysql Related Eclipse Error
I am trying to connect the mysql database from my JAVA application. But I get this message: org.apache.Jasper.Jasperexception: An Exception occurred Processing JSP page /index.jsp at line 31 28:…
-
-2
votes1
answer293
viewsHow do I display the username logged in to my registered page?
Good afternoon, I would like to display the name of the logged-in user on my registration page, tried in several ways, however none of these ways was successful, I would like you to help me to solve…
-
-2
votes2
answers1078
viewsBootstrap CSS issues in DOMPDF
I’m using the DOMPDF to print a CV that picks up the data via $_GET of the URL. When I "print" the file on the screen, just the HTML, I can get exactly what I need, but when I try to turn the…
-
-2
votes1
answer113
views -
-2
votes1
answer876
viewsLaravel Error 4.2 - SQLSTATE[HY000] [2054] Server charset Unknown to the client. Please, report to the Developers
I’m having problems in a web application using Laravel 4.2 the same worked in a Windows 7 environment with IIS + PHP 5.6 but I had to change the machine and create a new development environment.…
-
-2
votes1
answer36
viewsMYSQL (People would like an example of how to list the services used for a client any x that has a dog with any name y)
look I’m not getting to do needed an example. I just can’t do this consultation List the services used for a customer any x who has a dog with any name y. create database pet; use pet; CREATE TABLE…
mysqlasked 7 years, 4 months ago Andrews Y Fernanda 29 -
-2
votes1
answer99
viewsHow to auto fill a column based on another column’s value? MYSQL
I have a table of users where have the columns: id_usuario, name, id_company among others. And I have another table where I save other information of this user, and I also have the columns name and…
-
-2
votes1
answer21
viewsHow to define the data types of the columns of a Jtable equal to the Mysql database?
I created a graphical user interface in Netbeans where I inserted a Jtable into a Jframe FORM. I have a Mysql database whose columns are: Id: Integer Name: String Active: Boolean But when I use:…
-
-2
votes4
answers4554
viewsGROUP BY and ORDER BY Mysql
When I send the Query: SELECT * FROM tabela WHERE id_cliente = '$id_cliente' ORDER BY ano DESC Duplicated values are returned because there are duplicate values in the table. But I want to return…
-
-2
votes1
answer35
viewsUpdating duplicate records
Talk personal, all right? So, I made a mistake of issuing billets with the same unique number. I need to update in the table which are these duplicate records. The query that makes this…
mysqlasked 4 years, 2 months ago Joao Marcos 183 -
-2
votes2
answers32
viewsSave table field to a php variable
Good afternoon, guys, how are you? I have a basic doubt, but I think you could help me, as I could save the result of a field within a PHP variable? $sql = "SELECT ped_liberado FROM tb_pedido WHERE…
-
-2
votes1
answer48
viewsDoubt about subquery
I have several images for a site that I am doing. I wanted to show only the last image that was registered for a particular product. I know with left Join will pull up all the images and that I need…
-
-2
votes1
answer201
viewsHow do I count records after a specific date in Sequelize?
I am creating an API in Nodejs using Sequelize to facilitate the manipulation of data from a Mysql database. I have a list of appointments and I need to count how many appointments a patient has…
-
-2
votes1
answer38
viewsAND operator doubt in Mysql
I am making a consultation and I need to show three genres of a Book, as I do to show the 3? select Livro, Autor from Biblioteca where Genero = 'Romance'; I can get you to show the romance novels,…
mysqlasked 3 years, 10 months ago paulconiel 11 -
-2
votes1
answer31
viewsTables of MYSQL
As the image shows, I have the table adms_unidade where I can already show the units listed, and I have the table adms_equipamentos with various registered equipment. I want to show how many…
-
-2
votes1
answer111
viewsCreate mysql table
I need to create, in the database, the table below, and insert the values shown. My question is **what would be the primary key in this table ? **ID_NF ? In exercise asks to only create this table,…
-
-2
votes2
answers93
viewsHow to allow null values in a field that was originally NOT NULL in SQL?
I have a table created this way: CREATE TABLE usuarios ( id INT NOT NULL AUTO_INCREMENT, nome VARCHAR(64) NOT NULL, email VARCHAR(255) NOT NULL, PRIMARY KEY(id) ); But I want to change the field…
-
-2
votes1
answer27
viewsDoubt about PHP global variables
So far I don’t know how the variables work: $_SESSION, $_POST, and $_GET, could someone explain to me how it works? Thanks!!!
-
-2
votes1
answer23
viewsMysql query that returns only records that start with a particular chunk
I have a field in my table where the entered data is processed directly in PHP. The value of this field is concatenated to allude to the first record with a similar start. Example: first record is…
-
-2
votes2
answers264
viewsUpdate edits all information instead of just one specific, when I put Where to an edit specifies nothing is edited, what to do?
I’m making a code where the person adds records on the site that are shown to her in list on a table, on each line there’s a button to edit, when I edit some information all other records are…
-
-2
votes1
answer33
viewsLarval change Auto-increment from Id to id-Year
I wonder if it is possible in washable to change the auto-increment from "Id" to "id-Year" Example: When we have a user with Id:2 I wish it had id: 2-2021 If possible, how can I make this amendment…
-
-2
votes1
answer14
viewsCan an Enum table in the database store more than one value for the same element?
public enum SitucaoEnum { INCLUSAO(1), CANCELAMENTO(2), ATUALIZACAO(3), FINALIZACAO(4); } Can I save more than one such value in a type Enum column in the database? Or only rescue of one Enum per…
-
-2
votes0
answers20
viewsIn which bank should I save logs?
I want to save logs of my applications in a database, Mysql or Mongodb. However as it will be a large volume of logs, I will save in a different database from the application. I am in doubt of which…
-
-2
votes0
answers32
viewsRecreate the root user in Mysql
I made the stupidity of DELETE the root user of my Mysql. I’ve done everything, uninstalled and reinstalled, but nothing works. At the moment I am creating a virtual machine to use, because I have…
mysqlasked 3 years, 2 months ago Felippe Oliveira -
-2
votes1
answer26
viewsUPDATE in two tables at the same time
I need to perform a Update in two tables at the same time, each of which contains two fields that will be changed. However, it is not working! Returns error in INNER Look how I thought: ID_ESTOQUE =…
-
-2
votes1
answer25
viewsCreate dynamic multi-level menu (Tree Menu)
Could you help me, I would like to make a tree menu, the style of the image in PHP and Mysql, with you ?…
-
-2
votes1
answer33
viewssql query returning false
I have a digital catalog that works normally on my local server, but when I go up to my hostgator hosting it returns me the following error: PHP Warning: mysqli_fetch_assoc() expects parameter 1 to…
-
-2
votes1
answer451
viewsSQL command in MYSQL
I’m creating a DBA and I need to make one CHECK on an index of my table produto, but I’m using Mysql and I’m having a problem with the syntax. Follow the example: CREATE TABLE produto( Cod_produto…
-
-2
votes2
answers61
viewsError in PHP code
My code is part of a virtual store project, and is giving the following error: Follow the code below: <?php class Login extends BD{ private $prefixo = 'ibicor_'; private $tabela =…
-
-2
votes1
answer38
viewsData count in php
I have a problem and I can not solve, I need to make a code that searches the data in the database and makes the total count of these data, then I need to separate them from the largest to the…
-
-2
votes1
answer98
viewsVerification in login form
I am not able to do a check in the database, to make sure that the user exists. Follow the code: private void button1_Click_1(object sender, EventArgs e) { string conexao = "SERVER = localhost;…
-
-2
votes2
answers56
viewsDifficulties in making select
Wanted a help on how to solve the last 3 selects down. Recalling that the reports that contain the item "Total quantity" demand the total quantity of the product taking into account all the orders…
-
-2
votes1
answer111
viewsStore select value fed by SQL and change the WHERE query
I need the user to select a date in the combo box, change the value of the variable corresponding to the period in WHERE, to show the table only of the corresponding period. SELECT <select…
-
-2
votes1
answer919
viewsSort PHP table
I am trying to sort a table that is in Php and that pulls the database data, tried with js called sorttable, but it did not work, the table is with this code: echo '<table class="sortable">';…
-
-2
votes2
answers33
viewsIntroducing formulas in the web application
Greetings! I am developing a web application, with the tools (HTML+CSS+JAVASCRIPT){Bootstrap}+PHP+Mysql. It is a kind of teacher’s notebook, and at some point the teacher will have to introduce the…
-
-2
votes1
answer33
viewsSELECT with multiple tables returns only one project
I’m making a project management system, on the HOME page will appear all projects. In mysql I have in the PROJECTS table the client and project manager saved as User and Client ID... which has their…
-
-2
votes1
answer51
viewsDelete table data with no need to reload page to update
I have a table with data of a certain equipment, above the table has a field where the equipment number is inserted and quantity, the other information comes from the bank through the equipment…
-
-2
votes1
answer63
viewsFormulation of logic for problem solving
I have two tables, table A with id and tasks (description), and another table B with a task fk, quantity, fk run. In addition to other columns that are not relevant. In my table in html (table), I…
-
-2
votes3
answers67
viewsProblem with select php mysql
I’m with a problem I’ve never seen in php, I’ll try to pass an example to make it easier to understand. I have a table arquivos in this table I have 2 columns and they are the id do arquivo and the…
-
-2
votes1
answer125
viewsDifficulty checking php data with mysql
I’m trying to check the bank to know if you already have a user with registered email typed by hmtl, I did this php script, but the execution always stops at the first if even if the email typed is…
-
-2
votes1
answer47
viewsWarning illegal string offset
I created a class with arrays to be populated with objects, selected the database, then made a foreach to create a new object with each row of the select return and save these objects in the array.…
-
-2
votes1
answer1014
viewsError when adding FOREIGN KEY in already created table
I have a table that I need to change to have a foreign key ALTER TABLE bancocliente.product ADD CONSTRAINT fk_fabPro FOREIGN KEY (cod_fab) REFERENCES bancocliente.fabrica (code); I get the error…
-
-2
votes1
answer90
viewsCNPJ Mask Problem in print in database (solved)
This is the class that validates the CNPJ: package br.com.Sistema.meuProjeto; import java.util.InputMismatchException; public class ValidaCNPJ { public static boolean isCNPJ(String cnpjFornec) { //…
-
-2
votes1
answer247
viewsReturn treated message when it occurs (with.mysql.jdbc.exceptions.jdbc4.Mysqlintegrityconstraintviolationexception:)
Can anyone help me return a message dealt with when it occurs com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationExcept ion: Cannot delete or update a parent row: a foreign key…
-
-2
votes1
answer108
viewsMysql variables do not work with php mysqli_fetch_array()
I set two Mysql widables to simplify one more Query that I want to deploy on my system. Using this command directly in SGBD, it works very well, however, when you want to use as a query string in my…