Questions tagged as 'mysql'

Tagged questions
2
answers

Problem preventing registration of duplicate users PHP - MYSQL

I have an Android application where I access a MySql database by php. I am trying to make that when a user tries to register and already exists, he does not insert the data into the database. The problem is that by putting the if th...
asked by 07.09.2016 / 12:00
2
answers

Relate fields in SQL

I am creating a Database in MYSQL to use it in a Java program, I put you as I have created the first two tables for the moment: create table cliente( id_cliente int, Nombre varchar(255), Apellido varchar(255), DNI varchar(20), Calle varchar(25...
asked by 07.09.2016 / 19:24
1
answer

When deleting the record from a nested table, it is deleted from a list, but the main table leaves its data in it

I have a list of data showing the title of a project (project table) and the students (student table) that are registered in it, these being stored in a nested table called Proyecto_Alumno. I have the option of modifying and deleting the stud...
asked by 08.09.2016 / 18:36
1
answer

How to get the name of the database to which I am connected in MySQL with Java?

Hello innovative programmers, I would like to know if you can get the name of the schema or database to which I am connected when establishing the connection in MySQL with java, if you can, would you tell me how? I already tried with DataBase...
asked by 20.10.2016 / 10:50
4
answers

Error executing pip install mysql-python

I'm trying to execute the command in windows: pip install mysql-python to be able to work with mysql in Django but I get these errors: c:\users\fabia\appdata\local\programs\python\python35-32\include\pyconfig.h(243): fatal error C1083:...
asked by 19.10.2016 / 06:12
3
answers

insert data into MySQL database with bash

I have a script that converts me some files, I create the folders if they do not exist and move them to a desired path. echo "estacion: "$st; fcha=$year2"-"$month"-"$day; echo "fecha: "$fcha; echo $archivoF " =...
asked by 15.09.2016 / 22:01
1
answer

Save text string in MySQL

Good, I am trying to save the text that the user writes in a textarea, this text I show it later something like this:    Instructions:       Instruction 1.    Instruction 2.    Instruction 3.    What I do at the moment is to force the...
asked by 14.09.2016 / 17:07
3
answers

Paginacion en php

Good afternoon I am currently working on my project and I have run into an error in paging when consulting some data from a table with php. The point is that I can not detect the error because in the first query the information appears, but when...
asked by 19.06.2016 / 22:56
1
answer

I have this Error Code: 1241 Operand should contain 1 column (s)

I can fix this problem with some help, the error I get when executing the main stored procedure. Main procedure DELIMITER $$ USE 'dbinterfaces'$$ DROP PROCEDURE IF EXISTS 'SP_InsertarFactura'$$ CREATE DEFINER='root'@'localhost' PROCEDURE...
asked by 15.06.2016 / 03:31
1
answer

How to perform cleaning every first Monday of every month? [duplicate]

Hi, I've been working with the mysql event scheduler and everything is fine with the sentences but I really do not have a lot of time with the planner to do the basics and investigate how to do a function that runs only on the first Monday eve...
asked by 06.07.2017 / 22:46