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
answer207
viewsTransform varchar to float
I made a code that takes data from the comic to generate a graph with the matplotlib, but the data in the comic is as varchar and for the creation of the data it must be in the format float. How can…
-
0
votes1
answer37
viewsQuery with Join returning empty
Please help me check my query because it is giving an error that I am not able to identify. If I do the simple consultation: SELECT * FROM respostas WHERE resp_usuario='8' AND resp_questionario='6'…
-
0
votes0
answers87
viewsDuplicate registry in mysql
I’m having trouble creating a table and entering some records so I can work with some queries. As much as I create a test table only with ID and name. When inserting by the same mysql tool it…
mysqlasked 7 years, 6 months ago Rafael Rotiroti 493 -
0
votes0
answers60
views -
0
votes2
answers88
viewsGroup a set of measures in PHP
I’m having a problem uniting a set of values. I have a wood marking system. I feed the database with the length x width of the wood Id, id_request, length, width, date Registros: 1, 3, 320, 20,…
-
0
votes0
answers96
viewsError accessing mysql database in Azure
After creating a new user I cannot access my mysql database in Azure. How can I reverse this error?…
-
0
votes1
answer126
viewsForeign key SQL SET NULL
Well folks, let’s have one more question from me, I hope you can help me. I have the following problem: When I create a foreign key linking to another field of another table I always define it as…
-
0
votes2
answers44
viewsSearch for more data after finding nothing related to ID
I am making a 4x4 matrix system for a client and I am having a difficulty in the following question: The system has to check if the indicated to be checked already has 4 people in the network, if…
-
0
votes1
answer302
viewsFriends System with PHP
Hello, I would like to know how to create a system of friendships for my application, facebook style. I’m not making a social network, but I need to implement this system. I have a table of users…
-
0
votes2
answers522
viewsBulk change to MYSQL
Hey, guys, all right? I have a database in mysql and I need to make a massive change, it’s like? I want to change all records from the "show_address" column of the ptv_osrs_properties table to "1".…
-
0
votes2
answers52
viewsTransform long/varchar data to string
# -*- coding: utf-8 -*- import MySQLdb as mdb import matplotlib.pyplot as plt print(plt) con = mdb.connect('localhost', 'root', '123456', 'testdb'); null = None with con: cur = con.cursor() d =…
-
0
votes0
answers545
views -
0
votes0
answers131
viewsJPA Hibernate two entities with the same name, always saving in the same entity
I have a jCombobox where all the entidades students. It happens to have two entities with the same name (two students Rodrigo Silva for example). Both are loaded on combo. To the gravar the data in…
-
0
votes1
answer547
viewscan run a query within a user defined function in php?
I have code like this: function apagar(){ $conexao = mysqli_connect('localhost','usuario','senha'); $db = mysqli_select_db("banco"); $delete = mysqli_query("TRUNCATE table sap_reportes.zempe019");…
-
0
votes1
answer371
viewsPHP - is it possible to make an INSERT INTO with php variables and more SELECT?
I need to take information from another table and add it into another table with more information from a php variable I’ve been doing some research and some shapes I found was: INSERT INTO…
-
0
votes1
answer163
viewsSelect inside of Select
I am developing a product page that lists within each category all related products (they are various categories and various products). Like the code below, it 'rotates' all the categories and what…
-
0
votes0
answers50
viewsPHP stopping inserting in the table
I have an application that works with facebook activity log, I have 150 pages in monitoring, and I do the daily insertion of these lines: Post Comment Reply Likes Shares It has reached 500,000…
-
0
votes0
answers53
viewsArrange pagination
I’d like every page to have the results of every game of "X" day. Example: On this page only the games of June 6, 2017, but is appearing all the games of the table. OBS*: I am organizing the dates…
-
0
votes1
answer200
viewsDoubt group by + SUM function
I have a problem putting together a query in my database mysql for attendance at an event. I have a participating table where I have the participant’s information, and I have the attendees' presence…
-
0
votes1
answer242
viewsError using EF6 Codefirst with Mysql
I have the following error when running Migrations: How can I fix it? I have everything installed. Follow me Web.Config: <connectionStrings> <add name="ProjetoCultContext"…
-
0
votes2
answers48
views -
0
votes1
answer272
viewsUTF-8 does not work when entering data
I use utf-8 at the time of insertion of the field nome in PHP, thus: $nome = utf8_encode(strtolower($nome)); When checking how the insert Before inserting, the word is correct, but when I access the…
-
0
votes1
answer31
viewsCreate PROCEDURE by entering given and checking in 2 tables
Guys I’m having a doubt on how to make a PROCEDURE, I’ve drawn up a guide image to explain my doubt. Legend: Table in yellow and column in blue, linked by row. The property CASA1 has the ID 23 this…
-
0
votes1
answer74
viewsHow to make an Insert in this table
I have a registration of vehicles, which has a combo box with the years for the user to choose, these years come from the table "year". When I complete a registration of a new car, I have to give an…
-
0
votes0
answers52
viewsList with WHILE a QUERY with 2 Joins
I am trying to make a report by joining 3 tables. But the table is not being generated. The query works in PHPMYADMIN, but not in php. Database running the Query PHP code $sql = "SELECT…
-
0
votes1
answer1199
viewsUse FULL JOIN in Mysql
I needed to make a query that I return in a row the data of a candidate plus the courses to which I applied, and this data is in a relational table 'tblcandidatoCurso'. After some research I tried…
-
0
votes0
answers54
viewsI’m having problems with my method of updating in the java application,
public Boolean alterar(Exemplo exemplor){ Boolean retorno = false; String qry = "update funcionario set nome = ?,rg = ?,orgaoExped = ?,dataExped = ?,dataDeNascimento = ?,email = ?,estadoCivil =…
-
0
votes1
answer68
viewsSeparate data in table
I would like to make a table separated by "seasons". Example: Tabela estatisticas: Temporada 1: ID | JOGADOR | PTS | AST | 0 | Leonard | 12 | 7 | 1 | Pedro | 10 | 5 | Temporada 2: ID | JOGADOR | PTS…
-
0
votes1
answer801
viewsHow to take select(MYSQL) data and display in different fields?
Good morning!! The B.O is the following: I have my select in php where I take the table data, I wanted to know how to have this data separated and displayed individually. Ex: SELECT nome_cliente,…
-
0
votes1
answer23
viewsHow to turn 2 forms into 1 only '
Good morning, you guys, I have these two Forms that would be an input and an output, the two do Insert in the bank,: <div class="col-md-6"> <div class="panel panel-danger"> <div…
-
0
votes1
answer113
viewsError when creating a Trigger
I’m creating this Rigger DELIMITER // CREATE TRIGGER reposta3A AFTER INSERT ON utilizacao_veiculo FOR EACH ROW BEGIN SELECT emite_mensagem(); END// DELIMITER ; but when I execute the show triggers…
-
0
votes1
answer1452
viewsMYSQL How to delete a row from a table with dependencies?
Is it possible to delete a row from a table with dependencies? I tried the command ALTER TABLE MinhaTabela NOCHECK CONSTRAINT ALL But the error appears Error Code: 1064. You have an error in your…
-
0
votes1
answer53
viewsBanking integration
Good afternoon! I need guidance/suggestion. Here’s the thing: we have a clock software where it records all the markings in a MS Access database. I need to create a report of each employee on the…
php mysql codeigniter ms-access codeigniter-2asked 7 years, 5 months ago Laísa Ferreira Cardoso 116 -
0
votes1
answer851
viewsModeling for student attendance
I have doubts about the structure of the database for a frequency system. I thought of two structures and when doing a search I saw that both exist and are used in different systems. 1 - The first I…
-
0
votes1
answer29
viewsI need some help with the database
I have this table in my database And I need that under the Created, have 1 option called Payment (within this option with two options, PAY(I WANT YOU TO ALREADY COME WITH THIS STANDARD) and after…
-
0
votes1
answer40
viewsUPDATE of database information
I have a table, where there is a field called (PAY), the default value of it is "PAY". I made the following code, to change the VALUE "PAY" to "PAID" $results = "UPDATE snaps SET Pagamento='PAGO'…
-
0
votes1
answer98
viewsError checking result of variables with Else and if
I’m having a problem returning an authentication message on a login page. Specifically and where it checks that the login and password field are checked as TRUE, if yes and the user does not contain…
-
0
votes0
answers58
viewsMysql - VB - Connection error
I have an error, when trying to connect to Mysql in a report accompanied by a Reportviewer is making a mistake.. I have already tried to create a user with all access on Workbench in the previous…
-
0
votes0
answers329
viewsSearch in Mysql with FULLTEXT IN BOOLEAN MODE including keyword operators?
How to make in BD Mysql, in an Innodb table with two fields indexed by FULLTEXT, a search is performed through the MATCH query (column1, column2) AGAINST('keyword' IN BOOLEAN MODE) including even…
-
0
votes1
answer596
viewsPick up information from one foreach with another foreach
I have a mysql search that brings me the following array when using a foreach, I have another sql search that brings me all the fields of a table that in case are the same field names that are below…
-
0
votes1
answer77
viewsProblem with editing database data
I had already asked a question before why the modal did not multiply with the while (It’s already solved). That was the result: $editar = 0; $sql = mysql_query("SELECT…
-
0
votes0
answers212
viewsImprove performance of COUNT Mysql
I have a web application that performs several queries, but a Count query is taking 2 seconds to search and return the data to the application. My table where I perform COUNT has about 230 thousand…
-
0
votes1
answer59
viewsSimplify subtraction between Mysql tables
I would like to know how to simplify the following: SELECT FORMAT((SUM(r.valor_receita) - (SELECT SUM(d.valor_despesa) FROM despesas AS d WHERE d.pago = 1 AND YEAR(r.data_vencimento) <=…
-
0
votes1
answer77
viewsProblems with MYSQL data
I have to make a query in mysql database but I have a problem in my query. In my bank I have 3 string fields, being a day, Month and year. These are not dates, but varchar. Ok. I can’t change that…
-
0
votes2
answers87
viewsVerification With Two Tables
Galera I’m trying to create a system where I have two tables a call from acompanhamentos and the other produtos. Inside the table accompaniments there is the column sincroniza where I write several…
-
0
votes2
answers53
viewsIn the "while" method adds to the array
I’m trying to produce a script that when I query in mysql it returns an array, so far ok, but the goal is to make this query turn into an edited json. Example:…
-
0
votes1
answer1789
viewsInsert value of a radio button into the database
I have: <label class=""> <input name="user_perfil" type="radio" value="administrador"> Administrador </label> <label class=""> <input name="user_perfil" type="radio"…
-
0
votes1
answer105
viewsHow to find a word in 10 tables in Mysql
I am making a form for a search, and when searching for something, I intend to return several values of various tables that exist. As such, I would like to know the easiest way to do a query, in…
-
0
votes0
answers844
viewsRecover Data from Mysql
I uninstalled mysql, did not backup the database, but backed up the files: ibdata1, ib_logfile0 and ib_logfile1. The ibdata1 file has 17GB, in my.cnf innodb_file_per_table=0. How do I recover this…
-
0
votes1
answer270
viewsForm making empty Insert
Good morning Galera, They could help me identify what is wrong in my form or in the Insert that is saving empty records in the bank. INSERT: Alert( 'Note successfully registered !!…