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
votes0
answers122
viewsData is not inserted from android to mysql using Volley
I asked this question from link and the problem I was having was solved. But I still can’t enter data into the database. Connection.php <?php $mysql_hostname = "localhost"; $mysql_user = "root";…
-
1
votes1
answer300
viewsAngular and mysql paging logic
I would like to know how to implement a database paging logic using mysql and angular on the front end with ui-bootstrap or dirPagination. For example, taking 10 out of 10 in the bank using LIMIT…
-
1
votes3
answers182
viewsShow Quantity of items per category in virtual store?
I’m having a doubt: I have several categories on my site and would like you to show the amount of items you have in each category. Example: It’s like this: Accessories Toys Games Informatics I want…
-
1
votes2
answers128
viewsJava: Connection Class Error
How to fix this error ? This is preventing you from connecting to the bank.... private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) { // Eventoos do Botao inserir try { //Registra…
-
1
votes1
answer229
viewsHow to insert data into the database (mysql) received from an HTML form separated by commas?
Good evening, I will receive information coming from a TEXTAREA html, and I need to receive this in PHP and insert this information into the database, how can I do this? The information comes from…
-
1
votes1
answer178
viewsHow to convert date at select time and return via Json
In my form I am using the Bootstrap-Datepicker so that the user can inform the desired date at the time of registration, works correctly, but at the time of making a change I am trying to bring the…
-
1
votes1
answer46
viewsCreating EF Designer from a database
By clicking NEXT it closes, when I use a bank sqlserver it works normally, but in this case I’m trying to mysql and I’m having this problem, I’ve made several modifications to plugins, reference and…
-
1
votes1
answer764
viewsSELECT inside INSERT PHP Mysql
I have the following code: $sql = mysql_query("INSERT INTO TB004_PRODUTO_FORNECEDOR ( TB002_CODIGO, TB003_CODIGO ) SELECT TB003_CODIGO, 1 AS Codigo FROM TB003_PRODUTO WHERE TB003_DESCRICAO =…
-
1
votes1
answer5456
viewsConnection of the Database to the 000webhost
I’m having a problem connecting to 000webhost The code I have is: I think I’m fine because I just changed the values you matched to the localhost <?php ob_start(); $link =…
-
1
votes1
answer451
viewsSort result of a JOIN query based on the number of records in one of the tables
Assuming I have two tables in my database (pedidos and pedidos_itens) how I can obtain data from requests ordered by orders containing more items? I’ve tried to make a Right Join, but I don’t know…
-
1
votes1
answer1040
viewshow to take data from one mysql table and insert it into another :?
I’m trying to do brush validator (serial), but I don’t know how to do it. I have two tables: "validation" and "maturity". In the "validation" table, you have the following fields: id(int),…
-
1
votes0
answers31
viewsFrequency System | Convert to PDO or MYSQLI
Do you have how to convert these mysql codes to PDO or MYSQLI, Please Help Me :( <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"…
-
1
votes1
answer248
viewsSort While by insertion into MYSQL Database
I’m wanting my while instead of creating the block "element-item" down, create the block up, ie He orders from the youngest to the oldest and not from the oldest to the youngest EXAMPLE: What is he…
-
1
votes1
answer91
viewsList records without reference in another table
I have three tables: -customers -plans -services On the table services have servico_A, servico_B and servico_C that are related in the table plans. I need to list all customers who do not have a…
-
1
votes2
answers718
views -
1
votes0
answers45
viewsNumber of Mysql lines
I wonder if it is possible to show the total number of rows in a table by giving a SELECT in Mysql Workbench (I’m using version 5.2.33), because it only shows the first 1000 rows of my table, so…
-
1
votes1
answer1867
viewsexplode() right on Mysql
I have a column called relacionados on the table produtos and there are some ID’s of some table items produtos. I needed to make a explode() or something like that on the table produtos and selects…
-
1
votes1
answer330
viewsView with store Procedure, mysql
I have a procedure correct and a view which uses the Procedure parameter, only the view does not see the Procedure parameter, how to do to solve this problem? Create a store So that from the…
-
1
votes2
answers209
viewsRelate and compare Mysql and VB6
They gave me a system of a company to update, they have 3 tables Mysql 'vendaesc, sale, venda_forma_pagamento'. From what I understand the vendaesc table serves to store the items of sale. I need to…
-
1
votes1
answer65
viewsProgrammatically change the date displayed in a "Datepicker" control?
I’m trying to display data from a table field MySQL in a control DatePicker. The code is as follows:: if (dataGridProdutos.SelectedIndex != -1) { DateTime selectedDate; DataRowView selectedRecord =…
-
1
votes1
answer37
views -
1
votes2
answers1862
viewsHow to count the time the user takes on the page?
I am making a program in PHP, Javascript and Mysql about questions and answers. Well, in this code I need to count the time it takes the user to answer the question and store it in a variable to use…
-
1
votes0
answers46
viewsAndroid app gives error when trying to login
System application log in to Android Studio. I can register in the application but when I try to log in I can’t Love a message "login failed" here is the login code.php <?php…
-
1
votes0
answers55
viewsFormat Mysql data
I have a problem when passing a date to a select. Using the form below, select me returns the data normally: SELECT H.* FROM HORARIOS H WHERE NOT EXISTS ( SELECT * FROM RESERVAS R WHERE H.COD…
-
1
votes1
answer5997
viewsCurrency format
To be complete I could not enter a FORMAT(Value,2) including in CONCAT? SELECT * , CONCAT('de ', Valor, ' por ', desconto) AS promocao FROM (SELECT Valor, Valor - Valor * 20/100 AS desconto FROM…
-
1
votes1
answer58
viewsProblems with WCF + Mysql
I want to use this method, locally it works and returns what I want, when I command IIS simply returns me on the last screen shows the error: Within the Service1.svc.Cs have this method: public…
-
1
votes1
answer944
viewsPlace SELECT Mysql Items Side by Side with Bootstrap
Good afternoon, I am making a consultation in a bank, for a real estate site. I would like this query to generate the properties side by side, and not one below the other. Is there a way to do this…
-
1
votes1
answer131
viewsHow to average in SQL?
I have a job to do where I insert name and two notes into a database using Voicexml. I have two tables, one with nome, notaum, notadois and another with nome, media. How do I calculate the average…
-
1
votes1
answer37
viewscreate a mysql triggers that reorganize the numbering of a field when one of those fields is deleted
I have a table users containing the following column: note that the position numbering is in order, what I want is when deleting some user to trigger reorganize the numbering, that is to exclude…
-
1
votes1
answer66
viewsLoad Marker G Maps from While php
Opa, I have a file . php with a while, where I return several records with addresses, this file is being called in a include in my index. while prints multiple Ivs where inside each has another div…
-
1
votes1
answer58
viewsHow to remove HTML and Scripts in user-written messages?
I created a messenger, and after the user writes the message it is saved in the database in format sweep, when the recipient sees the message, if it has been written with tags HTML, and tags of…
-
1
votes2
answers99
viewsWhat is the correct way to choose column types?
I always see tables as follows. Ex: CREATE TABLE posts ( id int(11) NOT NULL, titulo varchar(255) NOT NULL, autor varchar(255) NOT NULL, conteudo text NOT NULL, data varchar(11) NULL, )…
-
1
votes1
answer44
viewsSELECT user by Date
I have a Select mysql searching my clients by taking the name, email by date of day... I need to get the results that are from today (WHERE data_cad='$dataHoje') and I need to select one by one to…
-
1
votes1
answer63
viewsHow to make modification records in a Mysql Table (without using triggers )?
I wonder if there is another technique to make records of modifications in the tables without going through triggers ?
-
1
votes1
answer110
viewsSelect in Mysql and Insert in Firebird
How to make a "select" in the Mysql/Mariadb and "Insert" database of the data collected in Firebird().
-
1
votes1
answer46
viewsPDO does not return Count
I need to store the result count, but apparently with PDO I can’t store the value. I’ve already select on the outside and the result comes, because I can’t store in the variable $flag the result?…
-
1
votes1
answer104
viewsHow to fetch messages from A to B and from B to A in the same query?
I have a SELECT which does almost exactly what I need, is a chat system (Inbox) similar to facebook. Then he shows me with all the contacts that I have a conversation, but brings me the last message…
-
1
votes1
answer1791
viewsDecode Base64 mysql
I have a mysql database that some columns of it is encoded in Base64. I’m not familiar with programming to develop a script in another language that decodes. You can create a select in sql that…
-
1
votes1
answer59
viewsDatabase + java
How do I check for a database in java ? Example: If you do, create a new.
-
1
votes1
answer171
viewsWhat constant to declare in PDO::PARAM_ to insert date (yyyy-mm-dd h::m:s) in mysql?
I need to pass a date to the database. I will use the PDO class, but I have the following question. When creating "bindValue()" what kind of constant should I declare in PDO::PARAM_ ?
-
1
votes1
answer426
viewsHow to convert varchar to datetime?
How to convert a date into varchar for datetime in the mysql? For example: 04-12-2016 for 2016-12-04 16:00:00 04/12/2016 for 2016-12-04 16:00:00…
mysqlasked 7 years, 10 months ago Paulo Costa 3,976 -
1
votes0
answers77
viewsMysql 5.6 and Ubuntu 15.10 Remote Connection
I have a Droplet on Digitalocean with Mysql 5.6 on Ubuntu 15.10. Normally for remote connection I change the file /etc/mysql/my.cnf in the parameter bind-address = 0.0.0.0. It turns out that in this…
-
1
votes3
answers1239
viewsSELECT with 2 tables and same field in both
Good afternoon! In my database, I have two tables: imoveisvenda and imoveislocacao The two have the field "dormitory", which tells how many dormitories have the house or apartment, be it for sale or…
-
1
votes1
answer44
viewsWhat is the correct form in the return of treatment
Good afternoon friend, I am with a wrong treatment and I would like to solve. I am not being able to see the information. Code line <option value="<?php echo $results[0]['id_vendedor'];…
-
1
votes1
answer62
viewsAdd item with different array
I have the following array() Array ( [nome_responsavel] => [telefone] => [email] => [dependentenome] => Array ( [0] => qqq [1] => qqq [2] => qqqq ) [dependentedata] => Array…
-
1
votes2
answers1153
viewsLeft Join with multiple fields from the same table
To build a lease, I have two tables. The first is the contract, has some relationship fields as id_locador, id_locatario, id_fiador1, id_fiador2, among others. These fields are related to a table of…
-
1
votes1
answer1281
viewsVarious products within an order
I am with the following problem, I have a sales registration system, and in these sales I can add a product for each order, but as I would add several products to 1 order ? Registration code of the…
-
1
votes2
answers71
viewsProblems in an SQL query
Hello, in the following query, an error is shown in the: select fto.id_taxon, fto.cd_sexo as fto_cd_sexo, fto.cd_idade as fto_idade, x.ftv_cd_sexo, x.ftv_cd_idade, x.id_fv from tb_foto_ocorrencia…
-
1
votes2
answers1361
viewsDisplay only one record with foreach
I need help to display only one database record, follow code: <?php $posts = DBRead( 'posts', "WHERE categoria = 3 AND status = 1 ORDER BY data_numero ASC" ); if( !$posts ) echo…
-
1
votes1
answer384
viewsPhpmyadmin Import file size
I’m having trouble importing a 600mb . sql file. My PHP is already authorized to receive files of this size: memory_limit =1000M post_max_size = 1000M upload_max_filesize = 1000M max_execution_time…