Questions tagged as 'sql'

Tagged questions
1
answer

Databases, intermediate table relations

First of all I do not have much knowledge about MySQL, nor databases in general, so I regret the inconvenience that may cause. I have a database with two tables, registered, and product, registered has attributes such as ID (primary key), the...
asked by 29.04.2018 / 19:43
0
answers

java.sql.SQLException: Connections could not be acquired from the underlying database!

Holas I am working with hibernate and I have a problem with my application, it does not connect me to the database (sql). When I look at the tomcat log, I find this:    (e-deas LTDA / CFC) [2018-04-27 10: 05: 40,830] | WARN | com.mcha...
asked by 27.04.2018 / 18:29
0
answers

Import an XML to two tables in SQL Server

I have a XML that exports two tables, now that XML I want to import it to another table with the same fields, they are too much data that is why I exported it, I hope you can help me thanks. This is my query SELECT * FRO...
asked by 27.04.2018 / 19:52
0
answers

how can I configure this php correctly for its installation?

The code is: <?php /* */ error_reporting(0); require("app/config.php"); $db_server = ""; $db_user = ""; $db_password = ""; $db_name = ""; $server_addr = ""; $folder = ""; $adm_login = "use...
asked by 26.04.2018 / 23:45
1
answer

Problem when making a query with the MATCH and AGAINTS in mysql

I have the following problem is that I want to perform a user search, with the use of match againts and it is the next fragment of code. SELECT pur.url_product, us.Name,us.LastName, pur.fecha_compra, count.Name_country, ci.Name_city...
asked by 26.04.2018 / 21:52
1
answer

Number of times of a character in an SQL statement

Hi, I have a problem with a sql statement, I want you to show me the number of times a letter is repeated in this case H in a table SELECT SUBSTR(TRIM(CURP),11,1) AS GENERO FROM * 'tbl_name' there is only the letter H or M shown fo...
asked by 27.04.2018 / 00:01
1
answer

ora-01830: the date format mask ends

Good I have a problem when launching the following query. I want to bring all the receipts issued in the date range. SELECT COUNT(FCHA_EMSION) AS TotalMesFebrero FROM PREDIAL.DOCUMENTOS WHERE FCHA_EMSION BETWEEN '01/02/2017' AND '30/02/2017';...
asked by 03.05.2018 / 20:53
0
answers

Mail by mailgun sql server

Good, I wish you could help me. I am creating my domain by mailgun but I want to configure the domain but when configuring and sending a test email, do not send I would like you to help me     
asked by 25.04.2018 / 00:46
1
answer

Error using STUFF in SQL Server

I have a query and I want to group data from one column in a row, separated by a comma, through examples I could put together the following query, but when I run it I get The multi-part identifier "arr_inventario_sal.ains_folio" could not be bo...
asked by 25.04.2018 / 01:23
0
answers

Fast Report with sql server, Loan Voucher

I am preparing a report of a vehicle loan voucher. It is for a module of vehicles in pool, in that module you generate the corresponding Folios for the loan of the vehicle to some employee. My job is to create a loan voucher where the data of...
asked by 24.04.2018 / 21:31