Questions tagged as 'mysql'

Tagged questions
1
answer

Problems in mysql workbench "Error Code: 1005. (errno: 150" Foreign key constraint is incorrectly formed ")"

I have this problem in a database for a final school project    Error Code: 1005. Can not create table gymn-os . maestros (errno: 150 "Foreign key constraint is incorrectly formed") Here I leave the script of the database I h...
asked by 25.08.2017 / 23:22
2
answers

Help with this error SQLSTATE [23000]: Integrity constraint violation: 1452 Can not add or update to child row: a foreign key constraint fails

Good I am trying to fill two tables of related data bases in Laravel using ajax one of books use Illuminate\Database\Schema\Blueprint; use Illuminate\Database\Migrations\Migration; class CreateLibrosTable extends Migration { /** * Run th...
asked by 06.01.2017 / 00:44
1
answer

How to create relationships between SQL tables

There are different ways to create a relationship in the tables, which is to make use of the Foreign Key (FK), I have these understood ways of doing it: 1) In the case of the creation of FK by SQL code ... to create a serious FK: FOREI...
asked by 08.07.2017 / 06:37
1
answer

Transform Date to String and print it to a JDateChooser

I need your help, I have searched for different solutions on the internet but I have not found the correct one. My question is how can I transform from Date to String by obtaining the date from my MySQL database? The solution I...
asked by 05.07.2017 / 03:11
1
answer

Thousand separator in php or mysql

I have a query where it shows the numerical values with thousand separator (1,500) and I have two problems: When I open the modal window to edit the values it shows me the values with the thousand separator, but if I edit the value of one f...
asked by 10.07.2017 / 04:03
1
answer

Error: duplicate entry '0' for key 'primary' mysql

Good evening Update phpMyAdmin and when I export the database and import it into another server it sends me the following message:    duplicate entry '0' for key 'primary' mysql I know what it means and what causes it. But my questi...
asked by 21.11.2016 / 02:13
1
answer

Error filtering twice with combobox

I try to filter by race, shift and cycle, with a combobox I get out but when I try to insert another one and also filter the previous one they do not work anymore, I hope they help me. This is my code: <form action="busquedaadmin.php" me...
asked by 31.12.2016 / 15:29
1
answer

Error in MYSQL: syntax error missing 'semicolon' [closed]

I am making a query and the following error appears:    syntax error missing 'semicolon' Here's the question: delimiter && create procedure alumnos_pagos_deudas_a_fecha (in fecha_ahora date, in dni_alum int,OUT pagado FLOAT, OUT...
asked by 20.10.2016 / 01:52
1
answer

Turn MySQL server on and off

I want to turn on and off the mysql server through java, this is just an exercise, I used the org.apache.common.exec package to run the command, the only problem is that I can only do it through the daemon with sudo launchctl unload -F /Librar...
asked by 01.08.2016 / 04:35
2
answers

Return to Previous Page after updating

I am in an update form and have the link in the link to update, for example: view_fases.php?iddrs=2 I send it to update, and all good the problem comes when I want to finish making the changes I return to the same page with the id tha...
asked by 16.06.2016 / 20:16