Questions tagged as 'mysql'

Tagged questions
0
answers

How to use an action of a form in html

What kind of guys do I have a problem with, I'm trying to make a server with a register and a login and I could connect the whole database perfectly but my problem is that I have a form where there are 4 fields of input text and a submit and I w...
asked by 11.11.2018 / 00:56
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 10.11.2018 / 23:34
1
answer

Problem with mysql query, filter where

Will it be mysql error? mysql > select user_ad, name, assignment from users where assignment = 'NULL'; Does anyone know why the last query MysQL does not show the NULL record of danielad ?, it is assumed that doing the NULL fil...
asked by 10.11.2018 / 21:43
0
answers

I want to fill my vector but with more than one data that helps give me

I want to fill a vector with data by keyboard but with the condition that a single text box is the one that passes me the data and enters it into the vector, can you give me some idea and / or solution, there is no error I just want It stores mo...
asked by 09.11.2018 / 17:50
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 / 18:20
1
answer

How to connect FTP and open .txt file?

I'm trying to connect to an FTP to open a .txt file I need to save it in a database I have the following code but it does not work for me: $archivo = fopen ("ftp://perez:[email protected]/u02/data/mensaje/SMS/SMS_WELCOME_CDR_20181108....
asked by 09.11.2018 / 17:21
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 07.11.2018 / 23:25
0
answers

Verify ID before registering it in BD

I need a little help :(, I am just practicing these queries and I have a problem when verifying the existence of an ID (rut) before registering it in my database ... but the filter does not work: [ This is my code: $votador = $_POST['rut'];...
asked by 08.11.2018 / 20:40
0
answers

Connect MySQL to express

I'm doing a server with MySQL and express but I can not connect to the server. Try the following: var mysql = require("mysql"); var connection=mysql.createConnection({ host:"localhost", user:"pedro", password:"cocoypaco2", database:"users",...
asked by 08.11.2018 / 20:30
2
answers

Error in query

Good day, I'm doing a query in PHP to get the data depending on the date of the records, the detail is that the query does not work, I'm not sure that the syntax of the query in the WHERE part this correct since I use an INNER JOIN to obtain inf...
asked by 08.11.2018 / 18:58