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
votes1
answer244
viewsPHP codes register but do not log in
I have 6 pages in PHP, two of them present me problems: php entry. (where are the database connection data) php client. (is the login page, only html formatting) login.php (file that checks and logs…
-
1
votes0
answers490
viewsExport Mysql users and permissions to another server
I am making another server with the same databases as the previous server (I already migrated the databases) and would like to migrate the users and permissions from this previous server to the new…
-
1
votes1
answer320
viewsShopping Cart with Grouping by Seller
I wanted to group the products by sellers in my shopping cart. Currently it displays a single list without this separation. Example: Pedro and Maria advertise on my website and each one has their…
-
1
votes1
answer714
viewsError #1142 Mysql
Today in my system I came across this situation. I feed my SELECT with this code: "SELECT p.codigo,p.nome,p.fantasia FROM pessoas p LEFT OUTER JOIN pessoas_define pd ON pd.cod_pessoa = p.codigo…
-
1
votes1
answer58
viewsProblem with Function
Hello, I’m trying a problem with my query code in mysql, https://gist.github.com/Alkun/d2239eee1514a0dfc16a If the user enters some value the search in the database is done normally, but if he…
-
1
votes2
answers8654
viewsCompare Date within Mysql
I’m trying to select in the bank the date closest to the current date but I’m not getting a good result. The insertion is: $titulo = trim($_POST["titulo"]); $descricao = trim($_POST["descricao"]);…
-
1
votes0
answers44
viewsHow can I make an equal permission window from facebook!
I have a news site and I don’t know how to do this sisteminha! how to make that access window equal data access facebook.
-
1
votes1
answer182
viewsMysql insertion problem with Multi upload
I have a system that performs multi file upload, I am using the Codeigniter framework that extends to Class Upload CI. The files are being moved correctly to the desired folder, however when…
-
1
votes2
answers2351
viewsmysql file download
I have files in my database that I’d like to download. These files are of various extensions; . pdf, . txt, doc, . xlxs, etc; I looked in many places but found nothing detailed (for beginners). I…
-
1
votes1
answer36
viewsProblem listing all images
Good people and the following I have a photo upload that is working well, I’m just trying the problem in displaying all the photos through the for, an image always appears only needs your own to…
-
1
votes1
answer1409
viewsSQL syntax error
I come again with a similar error in my SQL syntax. I have tried a few times and so far nothing. If you could give me a hand, I’d appreciate it. Just follow my code: $sql="INSERT INTO processos (…
-
1
votes0
answers302
viewsRepeat template on multiple pages with Phpword
Friends, I would like to use Phpword to generate the company’s stitch sheets so that I manage a single docx with all stitch sheets to facilitate printing. I thought of using a template, where I…
-
1
votes1
answer601
viewsRelationship between tables in Mysql
I am creating a site and I have a problem in it, in this site I will display some characters of the game League of Legends and I will show which character is strong or weak in relation to others,…
-
1
votes1
answer45
viewsConcatenation of a Select field into the ADDTIME function
"SELECT at.codigoTurma, " "ADDTIME(t.horaInicioCurso, '00:01:00'), " "t.toleranciaCurso, " "t.horaFinalCurso " "FROM AlunosTurmas at " "INNER JOIN Turmas t " "ON t.codigoTurma = at.codigoTurma "…
-
1
votes1
answer53
viewsSelecting subcategory by category
Having the following tables in the category and subcategory bank: CREATE TABLE categories ( id INT AUTO_INCREMENT PRIMARY KEY, category_name VARCHAR(255) NOT NULL, created DATETIME, modified…
-
1
votes1
answer349
viewsChange table in mysql
I have the following situation. A table that displays the searched results in mysql, and within this table I have a column where the edit button is. How do I get this button to edit the content…
-
1
votes0
answers86
viewsProblem with Join query PHP
Good, And the next I have a query JOIN that makes me the query to 3 tables, that searches me in the bank all the existing notifications of the followers of the currently logged user. The problem is…
-
1
votes2
answers24015
viewsHow to write multiple records in a table at the same time Mysql
I need to record several records at once in Mysql for example. I own the tables PRODUTOS, CATEGORIAS and a third table that lists the two and also a form where I select the category and mark all the…
-
1
votes2
answers787
viewsHow to loop with input select PHP?
I have an array named $c that I made through a explode need to count with the for to see if it is Selected. The problem is that it echo option 2 or how many times there are records. Does anyone have…
-
1
votes1
answer154
viewsMysql with Entity framework Code First ID skipping 10
I’m setting up a Mysql in the Azure for an application I’m working on, however while saving my records to identity column is increasing by 10 by 10. This would be an Entity adjustable setting or an…
-
1
votes1
answer587
viewsClear json array after Ajax from a PHP file
Does anyone know how to clear a json array via ajax from a php file? I have a setInterval that checks every 2 seconds and receives data from a php file( this data is brought as json array, I can see…
-
1
votes2
answers156
viewsPerform 3 simultaneous searches in the same table
I wonder if it is possible to perform 3 simultaneous searches in the same table. The situation is as follows: I have a table that contains let’s say the columns: Car, Material, IP, date Then I have…
-
1
votes1
answer962
viewsQuery SQL returning duplicate records
I have two tables (adwords_performance and analytics_transaction) and I need to make a SELECT adding up the columns adwords_performance.clicks, adwords_performance.impressions and…
-
1
votes1
answer1252
viewsPOO PHP Function Insert into MYSQL
Hello, I’m wanting to do a function to insert the data in the table, is not returning me anything, look at the code: function insertInto ($tabela, $colunas=array(), $valores=array()) { foreach (…
-
1
votes1
answer891
viewsMake a select in a varchar column as if it were SQL datetime
The code is as follows:: SELECT data FROM lista WHERE data BETWEEN '01-08-2015' AND '05-08-2015'; The problem is that the date column is a varchar and I would like to use it as a date…
-
1
votes1
answer149
viewsLEFT JOIN mysql Filter non-existent records NOT IN
Good afternoon, what I’m trying to do is this: have two tables machines - stores copier location data ( address, zip code, etc ). readings - stores machine code, counters, datareading, etc I wanted…
-
1
votes2
answers1648
viewsMysql UPDATE multiple fields under the same condition (IF or CASE)
Friends, I need help. I have these two darlings: UPDATE leilaov SET seconds = CASE WHEN (mesini = MONTH(NOW()) AND diaini = DAYOFMONTH(NOW()) AND horaini = HOUR(NOW()) AND minutoini <=…
-
1
votes1
answer1124
views -
1
votes2
answers1461
viewsCheck last records per hour
I’m having doubts in extracting data from the last hour of the mysql database, the code below makes the sum of values in the table for the last day, more relating for the last hour I’m not able to…
-
1
votes1
answer478
viewsMaximum size of a Mysql column
Good afternoon, folks! I have a question... I want to get the maximum size of each column of a table, so I’m using SELECT MAX(LENGTH(nome_coluna_1)), MAX(LENGTH(nome_coluna_2)).... FROM nome_tabela;…
mysqlasked 9 years, 3 months ago Guilherme Cianfa 31 -
1
votes2
answers1247
viewsProblem inserting double value in Mysql
query += txtServidor.Text + "',";<br> query += double.Parse(txtVencimento.Text) + ",";<br> query += int.Parse(txtBanco.Text) + ",'";<br> INSERT INTO tbl_associados…
-
1
votes1
answer586
viewsPHP OO Problems with Classes
Good evening, I am trying to implement a method that registers the user comment in the database in the comment table that has the foreign key id_usuario. How do I get access to this id_usuario? I…
-
1
votes0
answers178
viewsHow to get modeling result
I have a modeling and I’m trying to get information about it, but I’m not getting it, I need to show the user tasks separated by Tipo de Atividade, the user is in the table WFPessoaTarefa field…
-
1
votes0
answers557
viewsHow to do PHP and MYSQL accreditation
I’m developing an event system that will consist of a web system and a mobile app. One of the main points will be the accreditation (check-in and check-out) of the users in the lectures. After a…
-
1
votes0
answers573
viewsCombobox + UF + City + Mysql + Javascript
I have the following question: I have a project in Java JSP and do not know how to select the UF and City combo update as selected before. below I have an example with fixed data, but I want to do…
-
1
votes1
answer941
viewsHow to integrate a Mysql database with a C#application?
I’m a beginner in database and I have a simple C# application and I want to use the Mysql database to store the data. I have Mysql Server installed and usually use the "command-line client" where I…
-
1
votes1
answer2560
viewsUpdate multiple Ids at the same time
How to update multiple records at the same time with just one click php/mysql? Example:…
-
1
votes1
answer491
viewsphpMyAdmin with slow Xdebug on Windows 8.1 with Xampp
Boas, A while ago I noticed that my phpMyAdmin was stupidly slow (more than half a minute in a simple consultation)... After researching about this, I came to the conclusion that Xdebug should be…
-
1
votes2
answers753
viewsPut date in file generated by mysqldump
Hello, I want to date the file generated by mysqldump, I have a shell script that generates the dump, however I need to put the date that was generated in the file name Ex: //have this command…
-
1
votes0
answers63
viewsupdate mysql error
I’m getting this error when I try to update with mysql in Asp. Microsoft VBScript compilation error '800a03ee' Expected ')' /postos/reg.asp, line 525 set ins_regenf1 = conn.Execute("UPDATE reg SET…
-
1
votes1
answer74
viewsInserting data into SQL
Hello would like to know how I can change code of area 1 of insert using the foreach($nome as $cod => $value) other than the code of area 2 I’m unable to make an adaptation by changing the mode…
-
1
votes1
answer1094
viewsCapture data from email
Good night. I need some help, I’ll try to be as clear as possible. I am developing an application of calls, I want to let the staff open called by email, as I can capture this data from the body of…
-
1
votes1
answer81
viewsError Mysql syntax
Good morning, I have an error in my upload system. The error is the following: You have an error in your SQL syntax; check the manual that Corresponds to your Mysql server version for the right…
-
1
votes1
answer74
viewsHow to count equal items from 5 different columns?
I have a table thus. The table keeps the attendance record ( P) and fouls ( F). I need to count, for example, how many presences and how many missing a certain code has.…
mysqlasked 9 years, 2 months ago Tomas Edson 11 -
1
votes3
answers16929
viewsMultiple foreign keys from the same table. Is it possible?
I am studying Mysql using Mysql Workbrench to create a diagram of my database and the following situation arose: Imagine that I have the table_A and the table_intensity, where : Structure of table:…
-
1
votes1
answer162
viewsPHP-Mysql-Dialog
I’m making a page, where I have a mysql database connecting with PHP. What I wanted is this, I have a form with: pais(combo); nome(text);empresa(text), and I want you to: When you fail to complete…
-
1
votes0
answers131
viewsRecover Database in Mysql
It had a server with several databases, but an error occurred and the server had to be formatted and I was able to recover the data through the backup which is done daily by the company. I managed…
mysqlasked 9 years, 2 months ago DiegoAugusto 8,694 -
1
votes1
answer5793
viewsHow to close all active connections?
I have 8 open connections in the database and would like to close all of them, is possible? What is the Mysql command that does this?
-
1
votes1
answer148
viewsCondition in Mysql for data query
Is there any way to make a condition to demonstrate data only if the status be as aprovado in the database? Mysql: Nome ProdValor Data Status Goku 250,00 15/04/2015 Aprovado Goku 250,00 15/04/2015…
-
1
votes1
answer181
viewsHow do I popular an arraylist<Type> with a result brought from the mysql database, using Hibernate?
On many topics I see an excerpt of code that I can’t reproduce: Query query = session.createQuery() I cannot create this Session object using the createQuery() method. Can someone show me an example…