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
-
1
votes2
answers1217
viewsUser Password Validation Issue (php, mysql, crypt)
I’m just trying to validate the password entered with the password stored in the bank, and the password stored in the bank was encrypted. The problem is that I type the correct password, my function…
-
1
votes1
answer166
viewsPHP How to pick a random value like Rand($min, $max) but with a query?
For example, in a browser game I want when the user clicks attack to return another user who has +- the same battle power as him. $select = $mysqli->query("select * from data order by rand()");…
-
1
votes1
answer561
viewsAjax with Python - I want to call function that is in default
I want to do a validation in Mysql Database through Ajax. I created a function called validaCNPJ() that is in the controller called Default. But I don’t know how to put this function in the…
-
1
votes1
answer225
viewsSelect Count with Union
Hello. I need to make a mysql query with 3 Count in the same table. I got my results to appear below each other in the same column, but I need them to be in different columns. It goes like this: I…
mysqlasked 9 years, 2 months ago goldenleticia 543 -
1
votes1
answer711
viewsRead TXT file with PHP and write to mysql
I am developing an application to control the equipment of the company, I can generate a log of the equipment with all the information related to the equipment, however this file is not tabulated,…
-
1
votes1
answer608
viewsDeploying logoff on my login system with UNSET SESSION
I have the following login file.php: <?php require_once('conexao.php'); // FETCH DATA FROM FORM USING METHOD POST // IF BUTTON NAME "LOGIN" IS SET if (isset($_POST['login'])) { // FETCH DATA FROM…
-
1
votes0
answers87
viewsWhat is Entityframework and how do you use it with C# and connection to Postgreesql and Mysql databases?
I’m programming a CRUD of ADO students with C# and Mysql, my algorithm teacher told me about the Entity, but I can’t find anything clear that makes the connection between the banks. Somebody explain…
-
1
votes0
answers587
viewsReportviewer C# with parameters using Mysql
I’m starting to develop reports in Visual Studio 2013, using C# with Mysql. At the moment, I was able to make a report without parameters, but when I enter parameters in the query, it returns an…
-
1
votes1
answer61
viewsDoubt to use combobox
Good Morning, I have a final chair work for web development, where I need to create a crud for teams, players, create a style table of the Brazilian championship and create the rounds. I’ve managed…
-
1
votes1
answer89
viewsDatabase does not show the data entered by the user
Good morning, I’m trying to make a news system, but the database does not receive the data from php. I would like to know how to solve this. <html> <head> <meta charset="utf-8">…
-
1
votes1
answer492
viewsCreate an android database
Hello personal I am learning php and mysql and I came up with the idea to host a question site on my mobile and share wifi with my friends so they can access my site and answer my quiz without…
-
1
votes1
answer428
viewsPhp Mysql PDO connection on localhost by ip
I have a PHP/Mysql system in which I connect via PDO on the "localhost" host, but I will need to put the IP of the server "xxx.xxx.xxx.xxx" instead of "localhost", the system works but very slow. I…
-
1
votes1
answer96
viewsSymfony2 - Updating an entity’s field when executing action in another entity’s Controller
I need to update the field budget of my entity Client when inserting new data into the table Budget. Both have relationship oneToMany and manyToOne, respectively. I received suggestions to use the…
-
1
votes1
answer258
viewsProblems with update mysql
I have a field from a table that saves the path to a locally stored file. When I run the following command: UPDATE tabela1 set caminho = 'c:\logs\caminho.txt' where cod_tab = 1 it saves without the…
-
1
votes1
answer114
viewsIs it essential to use the captcha in the form?
I’m completing a registration form, and I’ve taken some precautions against SQL Injection. And for the sake of aesthetics, I wouldn’t want to insert a captcha. The form in question is for…
-
1
votes1
answer1136
viewsHow to batch update with PHP and Mysql
I have a file .csv with two columns, one with the id and another with the status of my product, I need to change these products to the status 0 (zero), ie inactivate them, but the quantity of…
-
1
votes2
answers1896
viewsHow to make a record count for each day between a date and another?
I need to make a query, to return the number of records registered in EVERY DAY, between two dates. I’m using a mysql database, and I tried here, but no way seemed right.
-
1
votes2
answers471
viewsHow to get the difference between dates and turn into hours?
In MYSQL, I know I can return a difference between dates through the function DATE_DIFF. example: SELECT * FROM table WHERE DATEDIFF(NOW(), created) <= ? However, I need that in this DATEDIFF the…
mysqlasked 8 years, 5 months ago Wallace Maxters 102,340 -
1
votes1
answer78
viewsCRUD error with . NET MVC
I am trying to recover some data from my database but is giving the following error Specified key was Too long; max key length is 767 bytes I have no idea what’s going on. User class public class…
-
1
votes3
answers90
viewsInsert picture into 2 different tables
I created a Function to register images as an album; A table for capa and a table for galeria. THE HTML: //Imagem da Capa <div class="form-group"> <label class="col-md-1 control-label"…
-
1
votes3
answers404
viewsHow to store static information without using a database?
How to store static information without using the database? For example, let’s say that I have a text on a page, which does not need changes frequently, and to avoid using server resources and/or…
-
1
votes0
answers51
viewsSyntax error: Missing 'integer' when creating stored Mysql files
While trying to create the stored file below, I get the title error in line containing: Kill Nid; What am I doing wrong: DELIMITER // DROP PROCEDURE IF EXISTS ClearDB// CREATE PROCEDURE ClearDB()…
-
1
votes0
answers99
viewsLimits for updating with Bufferedreader in mysql
Hello everybody good morning, I am having problems with a update routine in the mysql database, I am reading a Bufferedreader containing more than 3,000,000 records and updating in mysql but when I…
-
1
votes1
answer92
viewsMysql query with RAND
Is there any way I can bring Mysql records, where the field (for example) is_new is = 1, but when there are no records with the fields is_new = 1, I want the query to make an ORDER BY Rand(), it is…
-
1
votes2
answers123
viewsProblems with Insert logic
I have a problem. I’m doing an event access control system, I created a table that records the given id,code,date,time,sit, the field sit will be 1 and 2, but I need my system to understand the…
-
1
votes1
answer323
viewsForeach inside the while on the Json exit
I’ve been searching for days how to do a foreach inside a while to print in the json the data related to that query. My scenario is this: <?php require_once('../Connections/db.php');…
-
1
votes2
answers1080
viewsError doing Insert in PHP database
I am trying to do the data Insert in Mysql, no error appears but does not insert the values in the database. <?php INCLUDE "conexao.php"; if (isset($_POST["submit"])) { $cod_produto =…
-
1
votes1
answer364
viewsMYSQL - FK ERROR
Hi, could you help me? I am trying to add the FK in the employees table, only it is giving this error OBS I am creating the other tables before the employees 20:29:15 CREATE TABLE Funcionarios( id…
-
1
votes0
answers93
viewsHow to show paging correctly?
I did a part of my paging system but it always shows the maximum number of products in my bank and in the search I specified the name. Like I do the search for Leonardo there in my bank have…
-
1
votes1
answer2393
viewsERROR " Call to a Member Function setCodigo() on a non-object in"
The programming is in object-oriented php and MVC. I am registering users and saving it in the database, but the following error appears: Call to a Member Function setCodigo() on a non-object in…
-
1
votes1
answer609
viewsRelationship N:N in Laravel does not record object attributes
My tables have, briefly, the following structure: minutes: id | vigencia products: id | nome | descricao ata_produto: ata_id | produto_id | vlr_produto | qtd_produto The same product may have…
-
1
votes1
answer383
viewsJoin repeated results - PHP
Good morning to everyone, I have a question to join repeated results in the query in Mysql made by PHP. It is the following the code that I am using at the moment it removed the first repetition of…
-
1
votes2
answers186
viewsTaking image from Mysql
I’m making a website in PHP and MySQL to store the products and their image. On the products page there are 5 or more models and I need to pick up 5 or more images of each product. I don’t know if I…
-
1
votes2
answers935
viewsInsert with ajax on onclick
I would like to make an Insert from the onclick with ajax and already bring the result to the text of this button. Example is button to like in case each click sum +1 ; function curti(id,identify){…
-
1
votes0
answers206
viewsError solving Handler Javafx method inside classeDAO and controler with Mysql database
I am trying to create a simple cash system (cash entries minus cash outputs equal balance). And I made a method in class Dismissed going to the bank with the personalized consultation: (SELEC…
-
1
votes1
answer78
viewsProblem with donation registration
I am doing a final project of the course t.i, only I have a problem in the registration of donations, when soon with admin the registration is done successfully, but when I soon with donor not…
-
1
votes1
answer45
viewsHow to maintain orderly list of records in relationship N:N
Considering a scenario where a author can hold several publications and a publishing may have several authors, we have an intermediate table to maintain relationships. However, the order of authors…
-
1
votes0
answers168
viewsReturn json from a mysql blob
Good afternoon, I have a json returning the data from a Mysql BD and one of the attributes is a BLOB. Below is the return to better understand what I would like to know. [ { "id": 1, "name": "Onix",…
-
1
votes1
answer266
viewsQuery to multiple tables in mysql
My model is the following, I have 4 tables Avião (tailnum (PK), year) Voos (id_voo (PK), cancelled) Modelo (idmodel (PK), nome) Fabricante (id_fabricante (PK), nome) Airplane is with a 1:M…
-
1
votes1
answer7063
viewsConfigure Mysql connection in eclipse
I wonder if you have how to make a connection to Mysql by Eclipse. Thanks in advance.
-
1
votes1
answer90
viewsHow to register each new relationship between two entities
Considering a scenario where a member has a account, personal profile, academic profile and may vary between status (between pre-defined status: teacher, student and collaborator) within the system.…
-
1
votes2
answers332
viewsSave Date in UTC Brazil Table
I’m making an insert into a Mysql table that contains several date fields. I left in the default column created_at table the value current_timestamp. If I make one INSERT now, it is inserting:…
-
1
votes2
answers268
viewsHow to mount an SQL to display grouped content per month?
I need to mount an SQL to group information per month within Bootstrap formatted columns. Come on: <div class="container"> <div class="row"> <div class="col-md-3"> <h2…
-
1
votes1
answer50
viewsHow to update recovering value from another table?
I have a chart in my comic book called contas. Where I log all system accounts. As soon as they get paid I perform a update changing her status. However, I send a single update to several accounts,…
mysqlasked 8 years, 4 months ago Hugo Borges 5,294 -
1
votes0
answers57
viewsSymfony2 - Only one field has its value read, the others of this same field are NULL when submitting form
I have two related tables: material and items_budget. The table items_budget has a form that has a field that lists the name of all material in a group of checkbox, and next to each checkbox has two…
-
1
votes0
answers325
viewsConversion from String to Bigdecimal is giving error and method not saved
I’m making a system for video rental and on my category screen a field called value to save the value of my category. I was able to convert String to Bigdecimal using the following methods:…
-
1
votes2
answers223
viewsSELECT sort by the quantity of another SELECT
I have two tables in MYSQL: account: id apelido_usuario 1 caio 2 manoel 3 josé product idconta status 1 3 1 3 1 1 2 3 3 2 I made a SELECT like this: SELECT * FROM conta WHERE apelido_usuario…
-
1
votes2
answers372
viewsSet field to null - Codeigniter
Hello, beauty? I’m making a update in a table and I am sending the data array. However, I have a date field. Every time I update, it sends the field as 'dtnascimento' = ''. When this data arrives in…
-
1
votes1
answer344
viewsAdd values from an Inner Join to 2 variables
I wonder if you have any way to get the results of a separate select through php. I have two foreign keys in the same table, setting for the same place, they are Tj.fk_time_mandante and…
-
1
votes1
answer412
viewsHow to add a view dynamically to android as registered in mysql
I would like to know how to add a view (Relativelayout) dynamically in my xml, as records are found in my Mysql BD... (My connection is made through Volley lib)