Questions tagged as 'sql'

Tagged questions
1
answer

NOT IN SQL (I want to select pilots who have never made a certain route) how? [duplicate]

I want to select the pilots (in this case commanders or co-pilots) who have never made flights with route 12345. At the moment SQL is returning all the pilots and I want it to return only the 18200 the 25100 and the 25169. Does anyone know wha...
asked by 26.11.2015 / 16:19
4
answers

Creating base date using StringBuilder

I'm creating my database with class sqliteOpenHelper , passing DB creation by String through StringBuilder . The problem is that you are only creating the first table, and then you do not create the next table, in which case I...
asked by 10.11.2015 / 23:27
0
answers

Help with PHP and SQL Error [closed]

Well, I'm doing a project from a rental company, but the data is not being sent, this is the code: <?php $host = "localhost"; $user = "root"; $pass = ""; $banco = "locadora"; $conexao = mysql_connect($host,$user,$pass) or die(mysql_error())...
asked by 25.11.2015 / 15:47
0
answers

Receiving API POST

I'm having trouble receiving data via POST from Cielo API. I've already talked to King Host and everything is okay with certificates and so on. I've been browsing GitHub and found a similar topic: link I followed the recommendations but...
asked by 14.11.2015 / 05:26
1
answer

PHP script script from MS Sql for My Sql

Good afternoon. How can I make a query in MS Sql and insert the values into a My Sql table through PHP? Looking at this data, can you do this insertion? #--> conexao mysql require_once("mysql.php"); #--> conexao mssql...
asked by 23.10.2015 / 18:42
2
answers

Date string-to-date procedure

I'm creating a procedure, which receives a string '2015-09-11', verifies that it is indeed a Monday, if not, it picks up that date and plays Monday of the week itself. But my concept with sql is pretty weak, my base is this way. DROP PROCE...
asked by 11.09.2015 / 15:39
1
answer

Doubt on mySQL - Write, Update and Show Data

Talk the guys! I have a doubt. I've created a static page that will show some data. For example, I want to show the live score of a specific football game. I thought about creating a static page with: "Championship Name" "Team A Nam...
asked by 28.09.2015 / 16:28
2
answers

hierarchyid, remove children from one node and assign to another node

I have a user table, with the use of hierarchyid, I need to remove all subordinate Users from User 1 and assign them to User 2. SELECT US.cd_usuario ,(SELECT cd_usuario FROM USUARIO USR WHERE USR.NODE = US.NODE.GetAncestor(1))...
asked by 02.10.2015 / 22:22
1
answer

Select dynamic query button submit and input

How to do a dynamic select in JSTL by a JSP? For example, I fill CNPJ in a input id="cnpj" and when I click the submit button it takes this value from input , plays SQL in the QUERY as a parameter and executes on the same page, retu...
asked by 25.08.2015 / 21:07
0
answers

Making MySQL UPDATE in database DB according to MySQL SELECT in DB2 database

I need to do UPDATE in an (office) field of a database (investor) database (b2c) on my site. However, this UPDATE will depend on a SELECT query that is made in another database from another site (both sites belong to the same company). The two b...
asked by 26.08.2015 / 20:47