Questions tagged as 'mysql'

Tagged questions
4
answers

Error of variables declared in a stored procedure

I have this procedure that I use to choose between one type of user or another for a login window, I get syntax error but I can not find the logic failure. SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE PROCEDURE Sp_Login -- Add the...
asked by 21.09.2017 / 11:14
2
answers

Mariadb: inner join of two queries

I have a table that relates reflections to categories to which it belongs. idReflexion | idCategoria --------------------------------- 1 | 2 1 | 3 1 | 5 2 | 3 2 |...
asked by 21.08.2017 / 13:22
2
answers

mailto body from php

I have this code <table width=100% border="5" align="center" cellpadding="0" cellspacing="1"> <tr> <th width=12% align="center" scope="col">nombre</th> </tr> <tr> <?php $customers = "select *...
asked by 24.08.2017 / 18:34
1
answer

Autollenado de html with PHP and MySQL

I need a page to be filled with the items saved in a database automatically as I mentioned in the header. When I generate the queries, it gives me an error that says:    "Warning   : mysqli_result :: fetch_assoc () expects exactly 0 parame...
asked by 10.08.2017 / 05:46
1
answer

How to insert a number N number of times in the same row? [closed]

I must insert the cost per fee according to the amount of fees that the EXAMPLE course has: SAY HOW MANY FEES YOU HAVE THE COURSE: 5 VALUE PER QUOTA: 22.000BS. This value must be saved 5 times in 5 different fields c1, c2, c3, c4, c5. And so kee...
asked by 07.08.2017 / 03:08
2
answers

Update all the columns that have the same name between two tables in MySQL

I have two tables with several column names that look alike and I would like to know how to do UPDATE from one table to another without having to specify all the column names. Let's suppose that I have between the two tables 50 names o...
asked by 27.09.2017 / 12:26
3
answers

how to transpose columns and hide row?

the code I'm using: select ccc.Descripcion AS Grado, p.CodPersona AS Codigo, p.NombreCompleto AS Nombre, cc.Detalle AS Detalle, SUM(cc.Valor) AS Valor from Cuenta cc inner join AlumnoDB.dbo.Alumno a on cc.IdAlumn...
asked by 25.09.2017 / 16:49
2
answers

Function group by on column type varchar does not work

I have a query in which I count the rows grouped by a type code varchar should count 1 but count the 3, you could see that it is wrong the grouped column is ID_CURSO_UNICO SELECT count(ID_CURSO_UNICO) as cantidad from encuesta_ap...
asked by 13.08.2017 / 20:01
2
answers

Insert data in several rows from a mysql php text file

What I'm trying to do is read a .txt file and save each of the rows and columns in their respective fields in MySQL. The problem is that it is not saved in the BD. So I have the text in the file: NOMBRE,EDAD,SEXO WALTHER,28,M MARTHE,26,F JULIO...
asked by 31.07.2017 / 04:55
2
answers

I have this error: error you have an error in your sql syntax check the

I was configuring one of my form where I was adding the button to find the one when I indicated an ID I would upload the patient data to all my texbox, when making the code and when executing it, everything was fine until the moment when I wante...
asked by 14.08.2017 / 23:18