Questions tagged as 'sql'

Tagged questions
0
answers

AJAX How to make a call to load more commets

I want you to upload the comments two by two with an ajax call using a button -- phpMyAdmin SQL Dump -- version 4.8.1 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Aug 03, 2018 at 05:05 AM -- Server versi...
asked by 03.08.2018 / 05:09
0
answers

How can I find the tables that would cause an integrity error?

I find the following problem that makes me curious, since I could not find an answer looking: I have some tables that resemble the following scheme Suppose that table A has records with id 1 and I want to execute the next sql DELET...
asked by 06.08.2018 / 22:34
1
answer

Exists == or === in MYSQL

I have looked for the question, to see if something appears about it, but I think I have not seen it, if so, I apologize in advance. The point is the following, I have a query in mysql where in theory I should show 2 values, otherwise, do not...
asked by 31.07.2018 / 20:08
1
answer

Hibernate sqlRestriction query

Good morning I have a problem when making a query with Hibernate, the thing is that I would like to join two consultations in one and I have looked to try it with joins and others but no idea. Let the queries have if you can guide me please, wha...
asked by 01.08.2018 / 11:00
1
answer

Count total equal records in two different tables with Group By among 3 related tables

I have tried to perform a query that extracts the information from a table where certain information is stored    This table contains comments Additionally I have two other tables that are related to this, such as the table of likes and r...
asked by 01.08.2018 / 05:28
1
answer

Table relationships of the EF error model

Good morning, I'm new to ASP.NET MVC and I'm trying to make a simple application where I only have two tables, the first table is the author and the second is the table books. When I give you an author, it saves it in the database, but when I wa...
asked by 01.08.2018 / 01:48
0
answers

SQL Server Agent 2012 starts and stops

I'm having this problem that I can not start SQL server agent 2012, I leave the details of my version of SQL: Microsoft SQL Server 2012 - 11.0.2100.60 (X64) Feb 10 2012 19:39:15 Copyright (c) Microsoft Corporation Enterprise Edition (64-...
asked by 01.08.2018 / 04:40
1
answer

how to make bulk insert with hibernate and Java?

I have a problem, I need to insert thousands of records that are read from a file.properties, the idea is to make bulk insert but when I execute the batch it asks me that the ID of the table is not NULL, I do not understand why it asks for it, H...
asked by 31.07.2018 / 02:13
1
answer

Know if a table exists or not in postgres

What happens is that I am trying to see if a table exists in postgres or not, I managed to make the query, the problem is that it is consulting if it exists in the whole postgres scheme and not in the base on which I am executing the query and...
asked by 30.07.2018 / 18:27
3
answers

Problem when printing data

I want to print texts in bootstrap alert mode, but I get the error:    Notice: Array to string conversion in   D: \ xampp \ htdocs \ Projects \ ProyectoDriversParadeClub \ DriversParadeClub \ view \ reportses_de_usuarios.view.php   on line 12...
asked by 30.07.2018 / 21:23