Questions tagged as 'mysql'

Tagged questions
1
answer

Insert data from one table into another comparing ID

In my system I have two tables, one with user registries, of course, each one has its ID. And another table where the sending data is placed from one user to another, but only the IDs of the sender and receiver are shown. I added two more...
asked by 21.01.2018 / 21:13
1
answer

My codeigniter is using another database instead of the one I selected

I have 2 projects, one is the copy of the other, one I want to leave online and the other one to test the program, so I copied the database and copied the project, changed the name, changed the directory, and 2 on the same server, but my test pr...
asked by 15.01.2018 / 19:15
1
answer

Put Variable within FormData

How can I put a jquery variable inside FormData? Example: I have a CKEDITOR, however I am not able to save in the database, but I am using the ajax send format, which I found on a website, to upload images, and this way, uses FormData, how...
asked by 13.01.2018 / 22:47
3
answers

How to use MySQL on Android

After some research, I saw that the only database that Android can use is SQLite, is that correct? Because I have an application that connects to an online database (MySQL) and would like to create an Android application that uses the same da...
asked by 28.02.2014 / 14:44
0
answers

Modify database access data in the app.config file after running the project "publish"

Hello, I created an application in C # and for access to the database I did the following: In the app.config file I have created the following: <add name="MyDatabase" connectionString="server=192.168.10.100;user id=usuario;password=senh...
asked by 10.01.2018 / 22:45
1
answer

Laravel, problem with Float fields

Hello, I'm using Laravel and I need to do a select in a table, I also create a field that brings the result of a function. My select looks like this: return \DB::table("view_pins_ocorrencias") ->select("*", "round(geo({$d...
asked by 17.01.2018 / 17:03
0
answers

Select 6 teams classified per year for a competition

Good evening, guys, with a doubt maybe a beast, but it came in a job test. For the following two issues, consider the following database:    TIME (id, name, state)       CHAMPIONSHIP (id, name, year_performance)       RESULT (id_time, id...
asked by 18.01.2018 / 00:43
0
answers

Generate random number with repeat rule

I need an SQL command that generates a random number between 1 and 11, and for number 1 to be generated more frequently than the others. I currently use the following command: FLOOR(1 + (RAND() * 11)) It is in a SQL WHERE command, exampl...
asked by 11.01.2018 / 17:10
1
answer

Duplicate result in MySQL no while

The table has two columns, one of user data and another of user points, user points works like the bank statement scheme, however I need to return only the last value, and I did so SELECT 'usuario'.*, 'pontos'.'ponto_valor' FROM 'usuario' INNE...
asked by 16.01.2018 / 19:39
0
answers

Doubts about the data type sql [duplicate]

What is the best type of sql data I should use for values in case of inclusion of product notes? The grades range from: 1.0, 1.5, ... to 10.0. I've been thinking about using Double, but I do not know if it would be ideal. For monetary values I...
asked by 16.01.2018 / 21:04