Questions tagged as 'mysql'

Tagged questions
2
answers

How to connect a MySql database with QT over a LAN?

Hello, at the moment I'm noob in handling servers with databases. I am using Qt Creator 5.3 to develop my project, and I decided to incorporate a Mysql 5.7 bank to it. I'm trying to establish a simple connection between my application and the My...
asked by 23.08.2016 / 22:30
1
answer

SQL, subquery if null

I'm doing a query, but I did not want it to return NULL. What I have is this: select ifnull(sum(job_withdraw_qty),0) as total, ( select IFNULL(sum(job_withdraw_qty),0) from job_positions where DATE_FORMAT(job_positions.created_...
asked by 14.11.2016 / 19:01
3
answers

Get data in Mysql DB using AJAX / PHP to create a badge containing the DB item count [closed]

I need to get a count of items in my Mysql DB using ajax and php. My ajax looks like this: <code> $(document).ready(function(){ $('#badgewel').empty(); //Limpa a tabela $.ajax({ type:'get', //método HTTP usado...
asked by 08.07.2016 / 05:43
1
answer

Php does not connect to the database (MySQL)

So I recently started with php and I tried to make a simple crud with php + mysql but I had a problem that I believe to be connecting to mysql. when loading the action in html, the page is left blank. It does not return error or insert into the d...
asked by 10.07.2016 / 05:48
1
answer

MYSQL primary key is it possible to create an AUTO_INCREMENT fill mask?

I wonder if it's possible to create a primary key, aaa-0000 as a mask, and still be auto_increment , example aaa-0000, aaaa-0001, and so on. If so, how? Thank you     
asked by 20.06.2016 / 21:22
1
answer

what is the procedure to insert 1 only 1 checkbox value in mysql with php?

In the search I've done about checkbox I've seen several alternatives for inserting checkbox values, using array methods and loops. But I want to insert only 1, it is still necessary to use array and loops. The following code is returning...
asked by 17.06.2016 / 23:55
1
answer

Query in three tables by a column with Foreign Key

This was the way I found to query my three tables: COUNTRY , CHILDREN and NETBLES using the > LIKE : SELECT 'PAIS'.nome, 'FILHOS'.nome, 'NETOS'.nome FROM 'PAIS', 'FILHOS', 'NETOS' WHERE 'PAIS'.nome LIKE '%MATILDE%' O...
asked by 17.06.2016 / 19:57
1
answer

recursive query in related tables using foreign keys

There is a database named Register and in this database there are three tables COUNTRY , CHILDREN and : IntheCOUNTRYtableIhavetwosignatures: TogetherwiththeCHILDRENtable: andtheNETOStable MytableNETOSisrelatedtothetableCHILDRENcolumnst...
asked by 14.06.2016 / 02:40
1
answer

Understanding HttpURLConnection, OutputStream, InputStream, and Buffered Writers requests for MySQL database usage

I'm developing an android application that will have access to a MySQL database using webservice . I saw some tutorials on the net and an English tutorial able to connect and insert data, thus creating a login and registration syste...
asked by 23.06.2016 / 14:49
1
answer

How to change an attribute in the bank via a button

I'm creating a small college project in Ruby on Rails and I came across a problem: I have a table called Person and another call Tools . People have many tools and each tool is owned by one person. I need to add a resource...
asked by 12.06.2016 / 01:36