Questions tagged as 'mysql'

Tagged questions
0
answers

Use json with PHP and MySql

Well, I'm trying to use Json to fill out a form with some data, the problem is that I have tried several forms and it still does not work and I already have it here is a big mess. / p> In First Needed Jquery, what is already added. Second...
asked by 23.06.2016 / 15:06
1
answer

Return Json using Mysql [closed]

I have 3 tables I do the inner join in them, but I need to return a json, I just got a simple select return: My Sql clause: SELECT publicacao.codPublicacao as codpublicacao, usuario.nome as nomeusuario, publicacao.categoria...
asked by 21.06.2016 / 15:53
0
answers

Error resolving JavaFX handler method inside classAdo and controler with MySQL database

I'm trying to create a simple cash system (cash entries minus cash outflows equal balance). And I made a method in the Expense class that goes into the bank with the custom query: (SELEC SUM(VALOR) FROM DESPESA WHERE VALOR IS NOT NULL AND DA...
asked by 26.06.2016 / 23:08
0
answers

Store array in the database and recover using one of the array information [closed]

I need to develop a system where I capture the selected data from a checkbox and insert everything into a array , I believe this is the most appropriate method to store, and then send it to the database, and time to retrieve the dat...
asked by 10.07.2016 / 03:18
1
answer

Query changing join - SequelizeJS

How could I do this query using Sequelize? SELECT t1.* FROM Table1 t1 inner join Table2 t2 on t1.id != t2.t1_id     
asked by 02.08.2016 / 02:27
3
answers

Connect MySql C #

I have a MYSQL database on a shared hosting UOLHOST, I can connect to the database through the Visual Studio Server Explorer normally: HoweverwhentryingtoconnectthroughasimpletestconsoleapplicationIgetaccessdenied: The clear difference I n...
asked by 02.08.2016 / 02:40
0
answers

Return json from a mysql blob

Good afternoon, I have a json returning data from a MySQL DB and one of the attributes is a BLOB. Here is the return to better understand what I would like to know. [ { "id": 1, "name": "Onix", "description": "Completo", "pr...
asked by 28.06.2016 / 19:17
1
answer

Problem with donation registration

I am doing a final project of the course of you, so I have a problem in the registration of the donations, when soon with admin the registration and done successfully, but when I soon donate not register, obs: when I try to put the value per ses...
asked by 27.06.2016 / 20:46
1
answer

Error executing trigger mysql

Good afternoon warriors, I'm having a problem implementing a trigger in mysql. It happens that I created a table called auditing with the same structure as the main attendance table, this audit table records all events, actions that are done in...
asked by 29.07.2016 / 19:33
1
answer

Create a database in android

Hello everyone, I'm learning php and mysql and I came up with the idea of hosting a question site on my cell phone and sharing wifi with my friends so they can access my website and respond to my quiz without needing internet, but I can not imag...
asked by 10.06.2016 / 04:42