Questions tagged as 'mysql'

Tagged questions
1
answer

Code First Migrations MySQL - Specify the '-Verbose' flag to view the SQL statements being applied to the target database

I'm creating a Web application in C # and for the sake of the hosting server, the database is in MySql. So I installed MySql.Data.Entity, EF6, I activated Migrations, added the class Migrations, but at the time of giving Update-database -Verb...
asked by 03.07.2015 / 07:42
2
answers

Remove messages from one party without affecting the other

I am implementing a messaging system and need to make a way to remove the messages from one caller without affecting the other. Fulano and Sicrano exchange messages: At one point, So-and-so removes the conversation, but Sicrano continues...
asked by 23.06.2015 / 01:13
2
answers

Limit number of occurrences of Group By

I have to search in a data table of an advertiser, I need to group by advertiser according to the most viewed, separated by date. I wanted to limit group by , how? Example table: id visualizacoes data 485 19...
asked by 28.05.2015 / 14:44
1
answer

Get the ID of the last line entered in the database

I'm doing a project that is in the following form: First the person will upload the photo of her in the bd (Table: registered, field: photo) But in this table there are other fields, so I created a form that will change the last line and add...
asked by 01.10.2015 / 01:31
1
answer

How to present the error coming from MySQL?

I made the code below, and it works perfectly, but if MySQL returns an error, how will I know? I have no idea, can anyone help me? The message should return in alert , however I was able to create alert of Sucesso , howe...
asked by 30.07.2015 / 03:21
1
answer

Charset Mysql and PHP

My table in mysql has UTF-8 formatting and all accents appear correctly, but when I make the request with PHP and display the data they do not appear in UTF-8 format. p.s: My page already has the goal for utf-8. Do you know what might be c...
asked by 05.08.2015 / 16:25
1
answer

Using ElasticSearch to perform complex queries and then retrieve the IDs for MySQL queries

I'm thinking of the following idea: Use the ElasticSearch features to do complex searches instead of directly querying MySQL using many where . If I were to use MYSQL I would have to create many indexes. So when I give insert to m...
asked by 30.07.2015 / 22:46
2
answers

Storing unit of measure in MySQL table

In one of my forms it will be necessary to collect the height of the user in meters. However, this form may be in English or Portuguese. If it is in English this height will be in feet. If it is in Portuguese, the height will be in meters. Th...
asked by 16.04.2015 / 17:54
2
answers

Check tab type in a CSV file

I've set up a script to import CSV with PHP but I'm having difficulty checking the type of CSV formatting. I need to check if it is separated by , or ; or \t or : or | , but I can not....
asked by 16.06.2015 / 19:04
1
answer

How to recognize MySQL instances using Java and allow the user to choose the database?

I'm developing a project that is required to be able to access different banks from MySQL that are allocated on machines as well as on servers. In order to allow the selection of a bank by the user that will execute the routines in t...
asked by 11.04.2014 / 21:05