Questions tagged as 'mysql'

Tagged questions
0
answers

Group repeated data of a given column

I need to do a select and group the items, but as I have researched, my query will come from a database selected by a variable via post, and I will list the columns that are in a while coming via post from a variable as well. The problem is t...
asked by 09.06.2018 / 03:20
0
answers

MySQL-workbench giving dump error

I'm working with MySQL-workbench, but when I go to give a dump (import / export), He gives a mistake, looks at the image below, knows how to solve?        
asked by 09.06.2018 / 06:24
1
answer

MySQL - Best Selling Cars Report Using View

An idea of how I can create a View by creating a report in decreasing order with the most rented cars in a certain period of time . Showing in this report, the vehicle license plate, the total mileage rounded during the reported period of tim...
asked by 06.06.2018 / 02:25
0
answers

Node Error: ER_PARSE_ERROR when trying to insert into mysql

I have a NodeJs application and I am trying to insert some records in a MySql form, but when I run the code below I get the following message. Code: CadastroModel.prototype.cadastrarEstudio = function(estudio, callback) { var sql = 'INS...
asked by 10.06.2018 / 08:06
0
answers

I open the products table of localhost / phpmyadmin and it already comes with a definite Select

When I open my phpmyadmin products table it was for vim SELECT * FROM produtos ! That is the standard of all tables. However, the products table every time I refresh the page to see if new products have been registered comes the following:...
asked by 10.06.2018 / 02:12
1
answer

Difficulty in printing rows from a table using PHP and MYSQL

Hello, I'm doing a CRUD with PHP and MYSQL and I split the page into several blocks of code, each with a CRUD of each table in my DB, all working perfectly except that of the code below: <div class="container"> <div style="height:50px;...
asked by 12.06.2018 / 14:10
1
answer

Search by Range

I'm programming a website and in Advanced Search you have the option of the user doing a search to find places near the city that he is. I have all the states and cities registered in the bank. But I have no idea how to make the system kno...
asked by 12.06.2018 / 04:42
0
answers

ReportViewer - Error, how to fix?

I would like to know what the solution to this problem is, I'm breaking my head about reportviewer    Error - Schema information could not be retrieved for the table or   the sam exhibition. What could it be?     
asked by 03.06.2018 / 18:59
0
answers

Array sent via Json to Javascript gets null in it

I have an application in which, a Javascript I have a function that performs an Ajax call to the .php file to handle. The .php handles the SearchContact (p) function like this: it does a SELECT on the MySql database (managed via XAMPP and phpM...
asked by 03.06.2018 / 21:30
0
answers

Select in two different tables

Good Night; I have two tables created in the same database. For both tables, I have two selects. The return of a select would like to concatenate the second select to bring the desired result and save to a variable via PHP. First select:...
asked by 02.06.2018 / 03:29