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
votes0
answers212
views -
0
votes1
answer207
viewsExpire Mysql user time
I’m making a system of login in C# where the login user will be verified his login, password and the time left to use the system. Until the login and password check part I managed to do, but I’m…
-
0
votes1
answer162
viewsTable already exists when creating a new mysql table, even if it does not exist
I have a database from which I accidentally delete a table and when I try to recreate it, it says that the table already exists, but it doesn’t appear. When executing the command: SELECT * FROM…
-
0
votes0
answers857
viewsRecover Codeigniter database value - Mysql
In a user form, I upload information such as username, password and permissions. But now I’ve included it in the permissoes a field called grupo. And I included it in the usuarios this field, so…
-
0
votes2
answers950
views -
0
votes2
answers26
viewsEnum date trucate
I have the following query: INSERT INTO celulas ( diaReunioes ) VALUES ( 'Terça' ) You’re making the following mistake: Data Truncate for column 'diaReunioes' at row 1 This field in the table is:…
-
0
votes0
answers125
viewsRescue controller data in multiple views
I’m developing a website in Codeigniter in which all pages must have a footer dynamic with data coming from the bank. I charged the view footer (I created a controller footer) in the controller…
-
0
votes2
answers6656
viewsHelp with SQL error 1064
Could you help me solve this problem here? use bancoteste: create TABLE login{nome varchar(10),senha varchar(10)); INSERT into login VALUES (`root´,`root´); SELECT * from login Error: SQL Error…
-
0
votes0
answers103
viewsLogin problems with mysql, php, Android
So, guys, I’m trying to perform the login feature on my Adroid app. I am using android native Java, mysql and php, but I can not login to the application, and Android Studio does not return me any…
-
0
votes1
answer151
viewsPick element selector created at runtime
I have a system that lists the fields and attributes of a table through javascript and ajax up to there everything, only that the elements created and listed in precise runtime manipulates lós…
-
0
votes1
answer75
viewsCount the number of characters of a value within a column of a Datagridview [C#]
How to count the number of characters of a value within a column of a DataGridView? The goal is to add €0.02 for each letter in the column mensagem and then put the total in a Label.…
-
0
votes1
answer35
viewslist of tables in the database
I need to make two tables of products talk to each other in Mysql, being them produto (father) X insumo (daughter). Example: PRODUCT: LUNCH BISTECA INPUTS THAT MAKE UP THE DISH: rice; beans; steak;…
-
0
votes1
answer277
viewsRemove Mysql registry with PHP
I have a PHP page with Mysql connection. Everything works perfectly, however I have a DELETE button, which when clicking on it, takes the ID of that entry, goes to a page del.php and should remove…
-
0
votes1
answer310
viewsHow to convert time in string to time from Ionic to PHP with Mysql?
Good morning guys, I am passing to the server a string that would be for time: 23:45 is an example. In my $_GET I’m trying to convert this way: $prazo_entrega_min = time("hh:mm",…
-
0
votes2
answers210
viewsLogic for ABC curve
I am developing a project and I would like to make a page only for statistical data, one of these data is the ABC Curve of customers, I mean, I want to return the customers who buy the most. I’ve…
-
0
votes1
answer248
viewsPopular form already created with PHP(Mysql)
I need to populate a form with Mysql database information in the onChange event of a Select input. I know how to create a form from 0 by filling the values property, but filling a form already…
-
0
votes3
answers236
viewsJob scheduling and publishing
good afternoon! I’m trying to build a publishing scheduling system. I have a table where are stored the date/time that the post should be published, when the scheduled date is equal to the current…
-
0
votes3
answers304
viewsSQL hide query parameter in return
I have the following appointment: SELECT idProdutos, SUM(quantidade) as soma FROM pedidos GROUP BY idProdutos ORDER BY soma DESC That returns me the id and the aggregated sum of the products in the…
-
0
votes2
answers441
viewsUse the result of an array as value of an Insert - PHP
Good night, I’m having a doubt. I am uploading a file and extracting its contents and inserting in my database, but I have a question how to use the array like the value My file consists of a…
-
0
votes1
answer407
viewsSet a condition in order by mysql
I am having doubts about a subject related to order by. In my table you have the following information: ID | ORDEM | NOME 1 | 0 | NOME01 2 | 2 | NOME02 3 | 1 | NOME03 I want to give a select where…
-
0
votes2
answers41
viewsMysql not returning expected (using LIKE and EQUALITY)
Here is the example code: SELECT * FROM maq_dispo WHERE ativo = '1' AND titulo LIKE '%coladeira%' OR descricao LIKE '%coladeira%' OR valor LIKE '%coladeira%' The return shows all records…
-
0
votes2
answers511
viewsSave an array to Mysql
I’m trying to record some information on Mysql through a Array obitda of an external execution, below the code I am using: $licencas = exec(escapeshellcmd($comando), $output); reset($output); while…
-
0
votes1
answer3372
viewsError Call to a Member Function prepare
The connection to the bank is working perfectly, but the getList method returns me this error: Fatal error: Uncaught Error: Call to a member function prepare() on null in…
-
0
votes0
answers96
viewsRegistration problem using PDO
I am creating a simple PDO registration system (I am beginner in this), and, I am not having success in designing my connection string and adjusting INSERT to add data to the database. Gives the…
-
0
votes1
answer176
viewsHow to get data from Mysql Database?
I have this code snippet where it takes the information from a database field and goes to textBlock, but now I need to fill in some textblock. EX: In the database has name=maria Rg=123 Cpf=456 ai in…
-
0
votes0
answers164
viewsProblem with Composer when sending to a server
I am using Composer to create a site in php OO, however, when sending the files from the site to the server (which in case I am using the free service of atwebpages for external testing), the site…
-
0
votes0
answers96
viewsProblem uploading a photo to a web server
Hi! I’m having a problem uploading a photo taken from an android app to a web server. On the local server it usually sends the photo, already on the web server, it sends only one photo and only…
-
0
votes1
answer25
viewsHow do I migrate posts from a fully coded page to Wordpress?
Hi, I have a problem with a client of mine who’s stepping on my toes. I’ve migrated Wordpress sites to Wordpress, but I’m with a client who is wanting to migrate his site from code to Wordpress and…
-
0
votes1
answer26
viewsResult equal to the last two characters of the records
I tried to create an SQL for MYSQL to query only the records containing the last two characters, I did so: <?php $query = "SELECT * FROM `veiculos` WHERE `placa` LIKE '07%' ORDER BY `modelo` ASC;…
-
0
votes3
answers98
viewsHow to check if the record exists in the database and update if it exists
How to check if the record exists in the database and update if it exists I tried this way Select if((SELECT COUNT(*) FROM Pessoas WHERE id = 0) > 0, ( UPDATE Pessoas SET Name ="João" where id =…
-
0
votes3
answers1764
viewsPHP + Mysql - Quote syntax error in String
"Obs: when the string has no simple quotes, it works perfectly, my problem is when it has simple quotes" example with single quotes: $name = "Michael"; $store = "Mike's Store"; "INSERT INTO…
-
0
votes1
answer53
viewsDatabase update problems using PHP
I have a UPDATE problem with the database. I have a form that sends the data to a php file, which would update a table of the MYSQL database. However, update is not performing the insertion and…
-
0
votes1
answer30
viewsHow to Properly Organize Tables in a System
I am developing a system for a school where the teacher will create the proof by the system, I have 3 entities: Proof, Question, Alternative, I would like to know the best way (in the database) to…
-
0
votes1
answer405
viewsTransform string (date and time)
It’s an xml sitemap (google news) and I have to get it out like this: <news:publication_date>2019-02-19T18:57:26-03:00</news:publication_date> My fields are in the following format, both…
-
0
votes0
answers17
viewsError "PHP has not enabled Mysql support" in local host installation
I was trying to install the coppermine gallery on my localhost, I use XAMPP for this. Only in the middle of the installation I came across the following error: PHP has not enabled Mysql support.…
-
0
votes0
answers14
viewsHow to store and retrieve date in this format?
What is the best way to store and retrieve date in this format, in MYSQL? <news:publication_date>2019-02-19T18:57:26-03:00</news:publication_date>
-
0
votes1
answer40
viewshow to open only one field
I’m having the following problem when asking jquery to open the form it ends up opening all at once to send a reply in the comment, but I need it to open only what clickei as I do it. Follow the…
-
0
votes2
answers1609
viewsPython Mysql database connection
Trying to make the connection to my database, but is returning me the following error! Exception has occurred: Attributeerror 'Connection' Object has no attribute 'execute' Exception has occurred:…
-
0
votes2
answers73
viewsHow to insert data into Msqli database using current date
How I can enter the data into the database using the current date of Brazil and not the hour of USA? Code: $result_cad_user = "INSERT INTO adms_usuarios (nome, email, usuario, senha, $campo_foto…
-
0
votes1
answer89
viewsInteraction PHP and Mysql form does not work
Fellas, I’m doing a pro bono job for a public service, and I’ve been trying for days to figure out what’s wrong with my code. If anyone can help me, I really appreciate it. This is the form:…
-
0
votes1
answer74
viewsUpdate on some Laravel 4.2 fields
I have a table called People in Mysql with 40 fields and I want to update only 2 fields (latitude and longitude) but I don’t want to bring all 40 fields to change together. I just want to save the…
-
0
votes0
answers42
viewsMYSQL does not list when running the command 'netstat -ntlp'
Apparently my MYSQL is working normal, but when I run the command: netstat -ntlp The result is this: As if MYSQL is not running.…
-
0
votes1
answer92
viewsConcatenate Lines with the same User
I have the following consultation: SELECT e.id_taxe, u.nm_user, dt_taxe, SUM(e.vl_taxe) as vl_taxe FROM taxe as e INNER JOIN user as u ON u.id_user = e.id_user WHERE id_enterprise = 86 AND (dt_taxe…
-
0
votes0
answers248
viewsPHP display duplicate record
Recently I started developing in PHP+Mysql ,I’m doubtful about the query display, follow scenario. I’m making select with 3 tables mdl_logstore_standard, mdl_course and mdl_user, where on the table…
-
0
votes1
answer242
viewsQuery with array returning only first record
I have the following querys: <?php $VarMensagem = 1; $pdo = new PDO($dsn, $un, $pwd, $opt); $data = array(); $dataGeral = array(); try { $stmt = $pdo->query("SELECT * FROM mensagem WHERE…
-
0
votes2
answers43
viewsRefer to duplicate values in the same table
I’m having trouble making a query to display duplicate values in the same table. I have a record table of electrical measurements with the following fields: ID_EQUIPAMENTO, DATA, HORA, FASE_A,…
mysqlasked 5 years, 9 months ago Rodriggo Santana 9 -
0
votes0
answers32
views -
0
votes2
answers210
viewsSELECT calculating note average in Mysql
In a training system I have two tables: TABLE nota_local: id id_local nota TABLE local: id nome The table nota_local stores the notes that each user gives to the location where the training took…
mysqlasked 5 years, 9 months ago caiocafardo 1,897 -
0
votes1
answer79
viewsDoubt with Angularjs
What’s wrong with this code? I’m trying to run it, but no way it shows me the data coming from the bank! var app = angular.module('app', []); app.controller('clienteController', ['$scope', '$http',…
-
0
votes1
answer1050
viewsMysql Web related error
Hello, I am trying to connect a java class with a Mysql BD from the db4free.net host but is returning the error below: SQLException: java.sql.SQLException: java.lang.ClassCastException:…