Questions tagged as 'mysql'

1
answer

MYSQL (People would like an example of how to list the services used for a client any x that has a dog with any name and)

look I can not do I needed an example. I just can not do this query. List the services used for any x client that has a dog with any name and. create database pet; use pet; CREATE TABLE CLIENTE( cod_cliente int primary key auto_increment, nom...
asked by 04.07.2017 / 05:25
1
answer

How to connect a Java application to the Mysql-in App on Azure? [closed]

How to connect an application via url to Mysql bank (Myslq-inApp) within azure? String urlLOCAL = "jdbc:mysql://localhost:3306/crudjsp"; String urlAzure = "jdbc:"; Class.forName("com.mysql.jdbc.Driver"); Con...
asked by 17.06.2017 / 02:15
1
answer

Mysql JDBC Connection Error in Eclipse

I am trying to connect the mysql database from my JAVA application. But I get this message:    org.apache.jasper.JasperException: An exception occurred processing JSP page /index.jsp at line 31 28: String action=""; 29: 30:...
asked by 16.06.2017 / 20:41
1
answer

How do I pass a database variable that is in php to javascript?

I have a program that has coordinates in the database, is taking these coordinates I would pass to another page (javascript) that would calculate the route and show a map in the screen of the users (by ip) to an establishment (coordinates) . But...
asked by 01.11.2016 / 17:24
1
answer

Help with MySQL connection

I am creating a CRUD system for practices, and my code is giving error in my prepare() . Index.php <?php require_once 'core/init.php'; // Abre a conexao com o banco de dados $pdo = db_connect(); // SQL para contar o total de reg...
asked by 27.12.2016 / 22:53
1
answer

How to do this insertion dynamically?

   How to do this insertion dynamically knowing the total amount of columns? mysql_query("INSERT INTO VOT_PART_MUN_ZONA VALUES ( '$dados[0]', '$dados[1]', '$dados[2]', '$dados[4]', '$dados[...]', '$dados[19]' )");     
asked by 23.02.2015 / 19:24
1
answer

How to build a simple APNS server with PHP?

I'm creating a small notification firing service. I made this code, to make several shots of pushs, where devicetokens comes from a server.  But I'm encountering the following problem: When I directly assign a token in the $deviceToken...
asked by 15.11.2014 / 03:27
2
answers

Decrease a Mysql value [closed]

There is some MySQL attribute to Decrement day, month, year or time in the same database that would automatically be. Ex: column-> Initial value = 15, after one day it would be 14 Does the mysql database do this?     
asked by 26.08.2017 / 18:08
1
answer

Insert problem: String sql is correct, but not inserted by Java, only manually by Mysql! Procedures datetime attributes

Good evening everyone! I'm using java and Mysql. At the moment I'm using Procedure for insertion everything happens in a perfect way the String goes to the bank with all the correct parameters, but something happens that it hits the bank, burns...
asked by 30.11.2018 / 03:52
1
answer

Continue to search MySQL after a particular ID

Good evening, I would like to know how I can continue a MySQL query through PHP ( query () ), example I did a search and found a user ID 1584, and I want to search for another, but starting of ID 1584. I tried with LIMIT, but I did not get th...
asked by 09.12.2018 / 01:29