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
answer144
viewsTotal records per day in the last 30 days
Galley, I just made this consultation, works very well until today(day 20) minus 19, only I need to show the last 30 days. That’s how it works SELECT ID, DAY( created_at ) AS DIA, SUM( 1 ) AS HORAS…
-
0
votes0
answers156
viewsMysqltuner Help with analysis
I have no knowledge in mysql, and it was very difficult to understand the diagnosis of Tuner. My problem is that when the site gets too many visits, the connection to the bank drops. I’m using a…
-
0
votes1
answer272
viewsUnable to build Entity manager Factory
<persistence xmlns="http://java.sun.com/xml/ns/persistence" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/persistence…
-
0
votes2
answers170
viewsAre there limits to the use of logical operators in the Mysql query?
Well, I wonder if there are limits on how many logical operators I can use in a Mysql query, for example: $sql = "SELECT * FROM usuarios WHERE nome = 'Fulano' OR email = '[email protected]' AND id…
-
0
votes1
answer35
viewsBringing together records from another table in a new query
I have a table "tbA" where the primary column "a1" needs to be referenced by the table "tbB" by the column "fk_a1" tbA id | nome | ---+------+-- 1, 'aaaa' 2, 'bbbbb' 3, 'cccc' 4, 'ddddd' tbB id |…
mysqlasked 8 years, 7 months ago Vinicios Yals 327 -
0
votes2
answers105
viewsProblem entering data into database
I am trying to insert a mass of data into the Mysql database using Hibernate. However I have the following error: 18:15:30,221 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread…
-
0
votes1
answer19
viewsStart the bank service with a function
I would like to know how I can do a function that once I start the software, I can start the database service if it is turned off. to using java with swing, netbeans and Mysql thanks in advance.…
-
0
votes1
answer110
viewsI need an if that changes the mask of an input
Hello, I have a mysql php code, and I need help, the code is already ready just lack the option to edit the data, this is what I need help with, I will explain what is happening, I have my code it…
-
0
votes1
answer307
viewsProblem with WHERE and BETWEEN two Mysql tables
I’m making a select based on a filter I receive from a form, but it falls into a problem I don’t know how to solve. I have two tables, the user table and the user_aula table. I need to count the…
-
0
votes0
answers38
viewsQuery Mysql comparing to PHP array
I need to mount an SQL query to search for more than one value. Type: SELECT * FROM tabela WHERE id = 10 OR id = 20 ..... But I found this option: SELECT * FROM tabela WHERE id IN (' . implode(',',…
-
0
votes2
answers55
viewsseat stress problem
Friends, I’m having trouble recording accentuated in the database as soon as I changed the version to PHP 5.6 I know you have several questions on this subject, but I’ve tested several of them and…
-
0
votes1
answer900
viewsSecurity in PHP BD Access
I’m setting up a website, and I’m not sure how to secure my database. I currently have a "Security" folder with the file connection.php who connects with the comic book. I give a include in this…
-
0
votes1
answer66
viewsUnwanted loop behavior mysql_fetch_assoc
I’m having problems in a while loop where it has a function mysql_fetch_assoc that redeems a value from a column in a table called orders in the delivered column. I made a if to see if there’s a…
-
0
votes1
answer37
viewsif to show button or text
<?php echo ' <table border=1> <tr> <th>ID Pergunta</th> <th>Pergunta</th> <th>Responder</th> </tr> ' ; include ("ligabd.php");//CONECTAR A BD…
-
0
votes1
answer924
viewsSelect field fill according to code entered in another field
Based on the image below, I would like when the person swiped their card, a select was made in mysql and where the store is written to appear the store where the person is registered. How could I…
-
0
votes3
answers61
viewsHow to save date in mysql table
I am trying to insert the current date into a table, I am using the following code: insert into testar (data,nome) VALUES (date("Y-m-d H:i:s"),'pedro'); yet of error: Column 'data' cannot be null.…
-
0
votes1
answer785
viewsConsult bank on another server
I have a Mysql database and need to consult it from another server using PHP. What’s the best way to do this? It is possible to activate a function on the database server and make it return the…
-
0
votes0
answers127
viewsSelect in two fields of a table
Hello, I’m going through a problem and I would like to ask for your help. Here’s the thing: I am integrating a PHP system to the Wordpress Woocommerce plugin and I need to order some products from…
-
0
votes2
answers416
viewsComparison of two dates using Mysql varchar type
I have a question regarding the preparation of an SQL query in which I pass a registration date and check if it is bigger than the current date, but I have a problem the registration date is varchar…
-
0
votes1
answer52
viewsAPI error published in Azure
I have an error in an ASP.Net API with Entity Framework and Mysql, on my machine the application runs smoothly access the database and shows the results, however when I publish in Azure the…
mysql entity-framework windows-azure publishasked 8 years, 7 months ago Eduardo Barbosa Oliveira da Si 45 -
0
votes1
answer35
viewsQuery revision
I have this query in order to list users with more comments, however, it cannot display users with the banned column=true. SELECT * FROM usuarios a INNER JOIN topicos_comentarios b ON a.usuario =…
-
0
votes1
answer49
viewsInsertion problems in two Mysql PHP tables
I am trying to make an INSERT in two tables, first I need to insert the information of the vehicle in Tablea 'vehicle_registered' and I need to insert the images in the table 'imagens_vehicle'.…
-
0
votes0
answers551
viewsLogin and password verification
I need help checking a login and password. If the login and password I type in JTextField are the same as I have in the bank, can not allow registration, what I am looking for is not a validation…
-
0
votes1
answer310
viewsHibernate does not generate the database and tables in mysql
I’m having problems with my project, tables. jul 06, 2017 7:19:21 PM org.hibernate.Version logVersion INFO: HHH000412: Hibernate Core {5.2.10.Final} jul 06, 2017 7:19:21 PM…
-
0
votes1
answer57
viewsSelect extreme values from a certain range in Mysql
I need to collect only the extreme values of 'id' for each given time slot. According to the data below, I need to collect the id’s 63 and 67 for the time of 00:45:22, 80 and 84 for the time of…
mysqlasked 7 years, 4 months ago Frank Queiroz 17 -
0
votes1
answer758
viewsInsert date and currency data of a maskedTextBox into Mysql
When trying to enter the typed data of an object maskedTextBox, one of the date type and another of the currency type, in the Mysql database, where I have a table called test, created as command…
-
0
votes0
answers97
viewsSort Secondary Table Column
Categoria Segmento 1 Atendimento 1 Tempo de espera pela peça 1 Preço 2 Atendimento 2 Negociação 2 Tempo de entrega do veículo 3 Atendimento 3 Preço 3 Serviço I have a table where I save some data in…
mysqlasked 8 years, 7 months ago Diego Souza 16,524 -
0
votes1
answer322
viewsMysql Time Count
I have a table where you count the time of client connections on freeradios, every time the customer enters or leaves the network he logs. I would like your help to know how long each user has…
-
0
votes1
answer6085
viewsRename entire Mysql Database
I wonder if it is possible to rename a whole Mysql database I have the Database Register with the people table I would like to rename registration to CAD_CRS It is possible?…
-
0
votes0
answers154
viewsError while doing Insert in database
I am getting error trying to make an insert in the database. Below. <?php define("CMD_CRIAR_POST", 0); define("CMD_BUSCAR_POSTS", 1); define("CMD_EDITAR_POST", 2); define("CMD_EXCLUIR_POST", 3);…
-
0
votes1
answer1222
viewsQuery in two tables with Count
I have a table in mysql that has a number of contracted items. Table itens_contratados id_hired Item Qty contract Table servico, in this I inform the service I performed in the contract id_hired I…
-
0
votes1
answer503
viewsPerform condition on Trigger
I have a Rigger that updates my table. I wanted to know how to make Trigger only run if the status column is different from the one already in my table, if it is the same nothing happens. DELIMITER…
-
0
votes1
answer276
viewsProblems with insert INSERT mysql
I am trying to insert data into my mysql database but the values do not appear in the table TABELA "users": id `int`,`11`, `notnull`,`primarykey`,`auto increment` email `varchar`,`11`, `notnull`…
-
0
votes0
answers370
viewsCRUD Mysql , I need a button that fills inputs
Good morning, I have a question about how to make the above inputs receive data from my database, for example: let’s assume that I will change something, but I just want to change a value the…
-
0
votes1
answer104
viewsHow to order a Mysql search with date in date format to get only the month
I have a field date, would like to make a query to take only the month of this field. How can I do that?
mysqlasked 7 years, 4 months ago Diogo Silva 3 -
0
votes1
answer2299
viewsStorage capacity Mysql
I have a table in Mysql that I backup daily, I have 552 records in it today, but the last two times I backed up realized that they were only saving 487 records. How do I increase the storage…
-
0
votes0
answers46
viewsWordpress does not find Mysql Host
I’m trying to run Worpress locally on MAC, this to work the site and after ready to go up to the server. Mysql is installed on the MAC on /usr/local/mysql-5.7.17-macos10.12-x86_64/ is accessed via…
-
0
votes0
answers33
viewsError while fetching data in MYSQL
I’m using PHP + MYSQL to make some queries in my database, this page in php is the same one I use on another host, there works normal though, when using on a different host it just doesn’t work.…
-
0
votes4
answers1877
viewsExport MYSQL information to JSON
Sorry for the ignorance, I don’t know anything about JSON. I have a MYSQL database site that the client needs to export to JSON to integrate with an app. Can you give me a light where to start? Ex:…
-
0
votes1
answer35
viewsDoubt about PHP or HTML Categories/Pages!
Hello, I am creating a site and I am not using Wordpress because it is not a blog, and I would like a help, actually take a doubt, has how to make categories without being by folders? type you…
-
0
votes1
answer295
viewsProblem with ajax and Curl to receive the mysql value and return to html
I’m having a problem using html, ajax, Curl and mysql. the function is simple an html page where it will receive a name and will send by ajax to the Curl that will access the php that connects to…
-
0
votes1
answer770
viewsAccess database via Mysql Workbench
I cannot access a database from Mysql Workbench. The following message appears: However, through PHPMYADMIN, I can. How do I access via Mysql Workbench?…
-
0
votes1
answer288
viewsBETWEEN with DATETIME field
Using the BETWEEN with DATETIME database fields the same does not return the records with date equal to datai and dataf. Using DATE_FORMAT to search for date by bypassing TIME Considering the search…
-
0
votes1
answer49
viewsRetrieve a general rating and display in a list
Good evening guys, I’m in the following situation, I have a table called cars, and each car can be evaluated by different users, so far so good, I created a secondary table called reviews and each…
-
0
votes0
answers105
viewsinsert custom text into Mysql
I have a textarea that the user can set font size, the text font itself and insert images. My question and how to pass this custom text to Mysql.
-
0
votes1
answer800
viewsGrab the last ID when inserting into Mysql database
How to get the last ID when inserting into BD Mysql, using PHP and Mysqli. $inserir = $conexao->query("INSERT INTO cadastro (nome, sobrenome) VALUE ( 'Fulano', 'De tall' "); echo $id =…
-
0
votes1
answer326
viewsPHP error when displaying search result with select
Error while selecting database data. $rs = $conexao->query("SELECT FROM cadastro WHERE ID_Cliente = '83'"); $row = $rs->fetch_assoc(); echo $row['nome']; Fatal error: Uncaught Error: Call to a…
-
0
votes0
answers22
viewsCharset error in Mysql
Follows line of code in php with example: If you do it like this, record it with those strange characters: INSERT INTO cliente (nome, endereco) VALUES ('ççoas sadoçççç','email'); If you do that, you…
-
0
votes0
answers160
views -
0
votes2
answers301
viewsConsultation in bank with accentuation in the table
I know it’s kind of absurd, but unfortunately I came across a situation I don’t know how to get around The company has a system that records in Adobe ACCSSES and some tables theme accentuation and…