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
answers10224
viewsUpdating multiple records to the same ID
Consider the following scenario for controlling license information in a database Products 1 - Solução x 2 - Solução y 3 - Solução z Suppose the Customer has the 3 solutions Licence table | ID |…
-
1
votes1
answer614
viewsjson_encode Empty
Below my PHP code. It takes the data from the database, puts it in an array and then goes through a json_encode. However, it does not print anything, how to solve? Note: Using print_r in the array…
-
1
votes1
answer37
viewsDate insertion problem in php mysql
I have a table of loan with the fields loan date and dateline, I want to be able to insert the current date in the table loan date and a time limit in the table dateline adding 7 days of loan date.…
-
1
votes1
answer342
viewsMYSQL - Code error 1644
I have two database, when a Trigger is fired it generates an Insert in another database is a trick to generate log : The scheme is this: local name database has a table called tab_manifesto and an…
mysqlasked 8 years, 10 months ago SneepS NinjA 7,691 -
1
votes1
answer599
viewsValue tuple using mysql Procedure
I have a form where there are two fields, a service and another value, for each service the user has to put a value, after the user chooses, I check in the bank how many lines will return me with…
-
1
votes2
answers1020
viewsProblem to join two Selects in one instruction
I need help with an SQL statement for the Mysql database. The select below returns me data coming from two tables. I use for a search system that I am developing. SELECT…
mysqlasked 8 years, 9 months ago Diego Ferreira Simão 31 -
1
votes0
answers136
viewsWordpress error with apply_filters() in load.php
Guys, I have this mistake: Fatal error: Call to Undefined Function apply_filters() in /var/www/html/lojadec.com.br/web/blog/wp-includes/load.php on line 316. I don’t know what to do!…
-
1
votes1
answer159
viewsProblem with Mysql Text field
I am having a hard time storing a simple text field in my BD. I have the following textarea: <textarea class="txtarea" rows="4" cols="50" name="Text" id="txt_area_post" value=""…
mysqlasked 7 years, 8 months ago Fábio Monteiro 45 -
1
votes2
answers701
viewsIn Netbeans it works, not in Jar
I know you have some similar topics, but none of them answer my question. I created a program to insert information into the database and it works perfectly when I have netbeans compile. I made the…
-
1
votes1
answer123
viewsSystem to identify the user owns the PHP + Mysql topic
GOOD AFTERNOON. I’m doing a help forum on my website, and I came across a question. I tried to make sure that when the topic owner had the question answered, he himself could close the topic.…
-
1
votes0
answers390
viewsMysql - Table is full
When I try to upload a file to a table of my mysql database the system returns the Table is Full error. However, I have other larger and heavier tables than this table that do not present this…
-
1
votes0
answers148
viewsHow to convert a string from a spreadsheet to date format for mysql?
I’m taking a spreadsheet excel in date format but in the database inserts as string in text format in excel despite this in date try to convert by mysql however in Insert appears the following…
-
1
votes2
answers2773
viewsconsult record between two dates in mysql
I am trying to make a query in Mysql as follows: SELECT * FROM `tabela` WHERE `data` >= '2017-03-01' AND `data` <='2017-03-05') The issue is that even having several records of the day…
-
1
votes0
answers86
viewshave to request only when there is a change in the database? instead of checking every second
<script type="text/javascript"> function atualizarTarefas() { …
-
1
votes2
answers454
viewsSearch for birthdays of the month varchar
Staff a customer has a field datnasc of the kind varchar in his database and now he wants to fetch the birthday of the month. How can I do this when the values entered in this field are in this…
-
1
votes1
answer55
viewsIs there a way to use a Mysql table when developing an app with Ionic and Cordova?
I wonder if there is a way, because I am developing a simple project that uses only a database.
-
1
votes1
answer666
viewsHow to reduce the INSERT script in the BD with PDO -> bindValue?
Some way to shorten that script?? Or every time I go INSERT in the data set using PDO and the function bindValue, will I have to write line by line?? Or da para utilizar um array ou algo fácil e…
-
1
votes1
answer468
viewsSelect Comparing Periods
I need to make one select comparing two periods of sales, totalling by product. Today I have this select that does this, but only for a period (01/09/2014 to 30/09/2014) SELECT ACC.PRODUTODESC…
-
1
votes2
answers160
viewstool or technology to assist in controlling database data
I have a web application, that constantly the database receives data, the application is all tied to the database. if a change is made can compromise the whole system, I wish I could return a point…
-
1
votes1
answer621
viewsHow to compare the structure of two tables and update the other?
The question is the same as the title: How to compare the structure of two tables and update the other? I have an online database, which I intend to update its structure. I also have some customers…
-
1
votes1
answer357
viewsRequest by date
How can I order a query by date? SELECT * FROM agenda ORDER BY evento ASC Thus it is appearing as follows: 30/03/2017, 31/05/2016 (the date with the year 2016 should appear first).…
-
1
votes2
answers167
viewsHow do I get the autoincrement id without being registered?
Hello, How do I get the id that is autoincrement without the item being registered in the database? Or I’ll have to do 2 process, register the post first, then register the post in the category ? I…
-
1
votes2
answers111
viewsINSERT duplicate with mysql ::PDO
Can anyone explain why when I run this code it INSERTS twice the same value in the table? I believe it is that this problem happens when I do a validation to check if the values were entered:…
-
1
votes0
answers646
viewsHeritage - Database Database?
I started to implement a bank, and I’m doubtful about the following: I have 4 tables Person Client Functionary Administrator. Cliente and Funcionario inherit from Pessoa and Administrador inherits…
mysqlasked 7 years, 8 months ago Nicolas Guilherme Matheus 502 -
1
votes2
answers1403
viewsCompare data sql
I need to compare date in a certain time interval. I need to pick up the field DAT_REPOT_REALZ and check the dates between TODAY and seven days ago. I also need to count the number of V (visitor)…
-
1
votes1
answer110
viewsHow to check if something has been passed to the php page?
It is even difficult to ask because I do not know if this is right, but I will try to explain it in the best way possible. I have a page where I will use the php case switch to decide the action…
-
1
votes1
answer288
viewstable always active with Ajax and php
I’m studying I’m novice, and I’m making a site with php, jquery and ajax, all blz, I need to load the database data and put it in a table, only the data has to be in real time, that if you have an…
-
1
votes1
answer211
viewsError check existing Pdo record
I have the following PDO class : <?php abstract class database{ /*Método construtor do banco de dados*/ private function __construct(){} /*Evita que a classe seja clonada*/ private function…
-
1
votes1
answer82
viewsSearch records for a given day of the week
Staff I have the following select set temp = Conn.Execute("SELECT * FROM tbl_estacionamento ORDER by id asc") I have a table called date where I record the day of registration of information, I…
-
1
votes1
answer1111
viewsSave object with uppercase vs lowercase letter
I think I had posted a question previously equal to this, but I did not find. I have a Manufacturer entity where I want to persist, to avoid differentiating between upper and lower case letters, can…
-
1
votes2
answers73
viewsCreating a Mysql default date string from a Java Date
I need to pass a string in this format: "yyyy-mm-dd+HH:mm:ss" (where "+" should be a space) to a webservice from a Java Date object. How can I do that?
-
1
votes1
answer31
viewsError collecting va_list value in C
Good afternoon. I came across a problem at the time of preparing the va_list in c. of two similar codes, one works and the other persists in error. extern bool _sqlite3_insert(const char *table,…
-
1
votes1
answer69
viewsGroup content per month and day
Good afternoon Guys, I’m having trouble grouping content in the following structure: Mes Day In the query I have two tables, "agenda" and "user". In the agenda table I have a field of type "date"…
-
1
votes1
answer113
viewsI’m using a mysql database where I store map markers
I’m using a mysql database where I store bookmarks from a map (in the table store the latitude and longitude of these bookmarks) my question is, I want to make a select by picking all bookmarks that…
-
1
votes1
answer469
viewsSend id to an Hidden field by clicking on an item in the.js autocomplete
I need to send the client id to an Hidden field by clicking on its name that is brought by the jquery autocomplete. The autocomplete is already working ok.. what I really need is to click send the…
-
1
votes1
answer35
viewsParameter’s passage
I have the following code that dates the Mysql database to textblock: textBlock8.Text = (reader.GetString("Data")); What happens is that it is passing the date and time. I would like to pass only…
-
1
votes2
answers196
viewsField 'Hash' doesn’t have a default value
When I try to insert into a table this error appears Field 'Hash' doesn't have a default value mysqli_query($conn, "SET SQL_MODE = ''; INSERT INTO ".SQL_TABELA."(`Chave`, `Nome`, `Categoria`,…
-
1
votes0
answers300
viewsTruncate numbers in a Mysql column
I want to leave all numbers that are entered in my bank with a maximum of 1 decimal place after the comma without rounding Ex: 3.2567 = 3.2 I want to know if I can truncate all the column of the…
-
1
votes1
answer106
viewsDynamic graphical user interface after Mysql request
People are the following, I’m wanting to upload all this data in my graphical interface, the idea is that the user type the Cpf(Primary key) of it and after that is loaded all this data for it to…
-
1
votes1
answer73
viewsMysql GROUP BY - PHP error
I have a query in Mysql that, in the command line and in Mysql Workbench, is bringing the correct values, but when running it in PHP, the function GROUP BY is grouping more than it should! Here is…
-
1
votes2
answers1820
viewsColumn count does not match the value count on row 1
I need guidance on how to identify the error in this received message after importing text file: 1136 - Column count does not match the value count on row 1 The table columns are 10 and the data…
-
1
votes1
answer52
viewsError declaring variable in login system
I am making a login system and now I come across a "Notice" that indicates that my Variable is not defined. This variable is not informed by the form. It is defined by a function that will generate…
-
1
votes1
answer985
viewsupdate multiple records with php mysql checkbox
I need to update a mysql table with data coming from a/two checkbox where checked is 2 and unchecked is 1. It turns out that if you check the id6 of the col1 it will update the id4. What will be…
-
1
votes2
answers513
viewsAutocomplete with jquery and mysql does not list the options when starting to type
I have the following form: <?php //CHAMA A CONEXÃO COM O BANCO DE DADOS require('../db/conexao.php'); ?> <!DOCTYPE html> <html lang="en"> <head> <meta charset="utf-8">…
-
1
votes1
answer1322
viewsHow to create a tree menu (multilevel) with PHP+ Mysql?
I’m trying to make a tree menu with PHP+MySQL, but something is wrong with the code. And, the same table was used in ASP with SQLServer to make a menu: First I press one array, my database: $menu[]…
-
1
votes1
answer158
viewsDoubt Mysql Insert
Good morning, I’m trying to make an Insert,plus this giving error and seems to be in the hour field,could help me identify what is wrong: Follows the Insert and the error. INSERT INTO senhas…
-
1
votes1
answer598
viewsImport csv without duplicating records
I have a spreadsheet with 32000 records, and I need to play for a table in the database. The problem is that in this spreadsheet I don’t have the ID of the records and I can’t let it duplicate when…
-
1
votes0
answers25
viewsCompare number of columns between tables?
I have an online system and I’m always updating it on my local machine, and I always make changes to the table columns. I wonder if there is a script where I can compare the number of columns in…
-
1
votes2
answers87
viewsMysql PDO array with Json error in view
I’m having a hard time with json_encode echo json_encode($autocomplete -> fetchAll(PDO :: FETCH_ASSOC)); i am doing a database select so far so all right, but when it transfers the data to this…
-
1
votes1
answer2857
viewsHow to add column in Mysql using SUM leaving column available for display
I need to add some columns in Mysql, use the sum to make an average and make the columns available for display in a report, I tried to make the sum in the query in Mysql but it did not work, I will…
mysqlasked 8 years, 8 months ago adventistapr 5,498