Questions tagged as 'mysql'

1
answer

ASP.Net MVC application with Jquery Bootgrid does not load data

I created a very simple application (client registry) using ASP.Net MVC 5 + Entityframework 6 (codefirst) + MySql database. Using the JQuery Bootgrid component for data manipulation as the main component. It happens that locally applicati...
asked by 04.07.2017 / 14:46
1
answer

MySQL error connector / C

I have a problem in C, trying to include the MySQL bookstore gave some strange errors that I did not find anywhere. I downloaded the bookstore on the official site for Win32-x86 (ZIP) and installed it on MinGW (32-bit , latest version with...
asked by 29.06.2017 / 01:30
1
answer

Queries with multiple joins in ruby on rails

I want to do in ruby on rails, this: SELECT * FROM isolateds INNER JOIN genes ON geness.isolated_id = isolateds.id INNER JOIN stats ON stats.gene_id = genes.id INNER JOIN mutations ON stats.mutation_id = mutations.id When I do:...
asked by 17.04.2015 / 23:52
0
answers

How to synchronize SQLite with MySQL

I have an application in Ionic and Angular that receives information through a $http . I would like to know how to keep the updated offline information of the updated application with those of the MySQL database whenever a connection is...
asked by 22.04.2015 / 18:29
3
answers

Search the entire database

You can do a query or there is some phpmyadmin tool that does this: Query the entire database for example: I have the value 23600 and I want it to find this value in the whole bank regardless of the table or field it is in.     
asked by 27.03.2014 / 16:07
2
answers

How to do a double "Update" in MySQL

I'm developing software in PHP / HTML / MYSQL FRONT. I need to give a Update in a table but changing two columns at one time. Here comes my doubt in the variable $ gravaprat1, since it is not executing the second command (SEND = 1). Next: $sel...
asked by 13.07.2018 / 19:07
0
answers

Operation not applicable Delphi Clientdataset [closed]

Why am I getting the error Operation not applicable when I open a TClientDataset with master-detail data, but it is only a dataset and a detail . System Mode: DataSnap > on the qryPai / dspPai / dsPai Server. data...
asked by 02.06.2014 / 22:35
1
answer

How to pass data from one table to another in php?

I'm new to programming, and I'm developing an advertising site. And I have difficulties, in my the person has the option to publish a advertisement of it. It publishes and is sent to the database, and in the control panel I put it to show the ad...
asked by 16.01.2015 / 22:25
2
answers

Compare if there is already a record in BD MySql

I am creating a room reservation system, and I have the following columns in my table: agenda_id agenda_hora_inicial agenda_hora_final agenda_data_inicial agenda_data_final agenda_sala My question is how to make the client only be able to b...
asked by 22.05.2015 / 19:18
2
answers

View how many people have accessed pdf

I have a pdf on my server and I put it available through a link, is there a way to control how many people access the pdf?     
asked by 11.03.2015 / 17:55