Questions tagged as 'sql'

Tagged questions
1
answer

INSERT, DELETE AND UPDATE in Crud does not help me

Good morning I'm doing an exercise in which they ask me to make an ABM form and I did it in the following way this would be the file edit.php where is the update button that leads to another page to edit the data and then update them in the i...
asked by 16.10.2017 / 05:53
2
answers

Query count the INSERT of a month

I want to count the INSERTs made in a month, for that at INSERT I have a field called date $fecha=date("n/Y"); but I want to count how many INSERT I made on that date, and then show it on a graph with Morris.JS X seria la el mes y año...
asked by 11.10.2017 / 16:42
0
answers

Someone to clarify a doubt about the triggers in sql?

I want to know if when creating an insert trigger you have to keep track of all the fields in the table or only certain fields in the table for example I have the students table and have the fields ID, name, surname, telephone, address, idcarrer...
asked by 10.10.2017 / 03:23
1
answer

Retrieve data from SQL tables [closed]

I am developing an application for the management of shifts of a medical office, when I register a new shift I keep the id of it (autoincremental) and I keep a id of the patient, one of the doctor, and one of the state of the shift. But when...
asked by 10.10.2017 / 18:52
1
answer

Problem Validation Login PHP AJAX JS

I am developing a system to practice but I got a problem with the Login, since using a validation script through AJAX sending through the GET method a variale to a Switch and a conditional does not achieve the desired effect since when you click...
asked by 09.10.2017 / 02:46
2
answers

problem with a query

I have a kind of invoice in which a calculation is made of the user that loguea of how much should be paid in that month of invoice (is condominium) in the query where the calculation is done I add that you make insert data in a table to save th...
asked by 07.10.2017 / 01:20
0
answers

Get a report of where the QUERY falls exactly - Transact SQL

I have a query that throws me an error because it returns more than 1 value "Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression."...
asked by 13.10.2017 / 20:25
2
answers

Date by rank

How can I make a query of dates by rank if the date is 2017-09-04 - 2017-10-03 ----- > This is how the daterangepicker throws it at me. and since I do not have them separated I can not do a BETWEEN.     
asked by 03.10.2017 / 21:36
0
answers

How can I get an int to use with the store procedure?

The method to insert has as parameters a String and an int, I want to take the data that is obtained from the txtField but I can not find the way that I do not pull error and let me get it .. In sql server I have declared them exactly the same...
asked by 30.09.2017 / 17:51
1
answer

Messages in MySQL

In PostgresSQL I could raise exceptions from a triguer with the Raise Exception, so I ask how can I display a message from a trigger as it did in postgres with the Raise Exception in MySQL?     
asked by 01.10.2017 / 22:06