Questions tagged as 'sql'

Tagged questions
0
answers

How to save records within a for?

I have the following records, as I need to save it in a record, I need to save all of them. The results of the data to be saved are the following: 13043:406090343,roam,56963757723,56963800030,324750007307002,0,0,0,0,1,0,0,4,2018/11/11 03:02:09...
asked by 12.11.2018 / 14:59
0
answers

How can I save this array in a database?

I need to store all the fields in this array in the database Array ( [0] => 13043:406090343 [1] => roamvtr [2] => 56963757723 [3] => 56963800030 [4] => 324750007307002 [5] => 0 [6] => 0 [7...
asked by 12.11.2018 / 15:52
0
answers

Security in database

In my work I manage a website in which clients can become members of a program and accumulate points with their purchases. The problem is that there is someone who is registering multiple times and thus earning points when creating an account...
asked by 12.11.2018 / 18:39
1
answer

Insert line break in SQL SERVER from PHP

I execute a SQL SERVER statement from PHP, and I need you to have a line break, since the SQL SERVER system requires them. PHP code: $QueryTable = "IF NOT EXISTS (SELECT * FROM sysobjects WHERE name='$NombreTabla' AND xtype='U') CREATE TAB...
asked by 12.11.2018 / 19:32
2
answers

Query SQLquery with Join and 3 tables

I have a problem that I do not know how to solve. I have 3 tables: table1 appointments: Date_ID, date, Patient_ID. Patient table2: name, Patient_ID, Department_ID, department2 table: Apartment_ID, department_name. I need to get the number of...
asked by 14.11.2018 / 20:00
1
answer

psqlexception syntax error near "="

I am creating a method to obtain the records of clients that have a certain userid , the client table contains the columns: clientid, name, userid strong> likewise the Client class contains the 3 parameters clientid, name, userid . But...
asked by 11.11.2018 / 16:42
1
answer

Get number of rows that contain a certain value, and that value put in another table

How about? After some search in stack overflow, I could not find the solution to the next problem. I have the following table, in which there is a column where the number of postings that person has to his name in another table will hurt....
asked by 11.11.2018 / 00:34
0
answers

Problems when inserting data from a json file to mysql DB

My problem is that I try to enter the data from a JSON file to my bd mysql but only certain records are added and there my doubt. Why are not all the records added? and I do not know how to find the error. I've done it before with many JSO...
asked by 14.11.2018 / 19:20
0
answers

How to add values and hide those that are repeated?

How can I do a mysql query to add the records in the column Amount in ML but I need to not add those that are repeated, for example:    -46005761       46005761       -34475735       34475735     
asked by 08.11.2018 / 00:25
0
answers

Doubt with stored procedure

Hi guys I have a question, I have a code in ASP in which a stored procedure calls this procedure what it does is update my data in my BD, but when trying to update it does not: <%@Language=VBScript%> <%option explicit%> <!--#i...
asked by 07.11.2018 / 21:17