Questions tagged as 'phpmyadmin'

Tagged questions
1
answer

# 1064 MySQL Error

I'm trying to import a .sql file into HeidiSQL. When I try to execute the file to fill in a table already created, I am disabled by the following error:    SQL Error (1064): You have an error in your SQL syntax; check the   manual that corres...
asked by 27.12.2018 / 11:15
1
answer

How to use trigger in mysql so that when you delete a record change the value of a column of the other records?

Well, what I'm trying to do is a query so that when a record is deleted from the "class" table, the value of the "counter" column of the other records is subtracted 1 as long as the id of the records is greater than the id of the record that I d...
asked by 04.04.2018 / 19:54
2
answers

Conditional on SUM (mysql)

I have the table factura_habitaciones , where you enter the room reservations that I will later invoice. I want to calculate the total of all the records in the table with a single sentence in MySQL considering that the days multipl...
asked by 28.10.2018 / 13:32
2
answers

How to avoid the foreign key constraint error in phpmyadmin and in php?

Very good! I am doing a small practice to remember after having been studying again the php and in knowledge of the MySqli (style procedure), when creating the database and the corresponding tables. I have never seen this error after making the...
asked by 02.06.2017 / 19:30
2
answers

I need help with a sql statement

You see, I am carrying out a project little by little and I have found a doubt that requires knowledge of sql and the truth is that I know the basics ... I need an ajax request to make me a select that returns the fields of 2 tables, but one...
asked by 29.04.2018 / 14:34
1
answer

Problem in mysql count php, it works in phpmyadmin and not in php

I have this function that should bring me the account of the records in my database on my page: function cuentaticketspendienteempleado($conexion,$id){ $pendientes = mysqli_query($conexion, "SELECT COUNT(t.id) as contador_tickets, t.id as...
asked by 25.04.2018 / 17:35
3
answers

phpMyAdmin does not work on Ubuntu 16.04.1

Install Ubuntu 16.04.1 on a computer and I'm trying to install a local server, and install Apache2, php, MySQL and Phpmyadmin. When you open the browser and enter the address localhost/phpmyadmin you can not find the page. Now l...
asked by 14.10.2016 / 07:04
1
answer

Problem with foreign keys in hosting with php

Hi, I would like you to help me, someone knows why: create a database with powerdesigner for Mysql. When I upload it locally, phpmyadmin with xammp works, all the foreign keys are created. But when I upload it to phpmyadmin of a hostgat...
asked by 07.03.2018 / 19:11
2
answers

MySQL query repeated data

I'm doing a query on phpMyadmin, everything worked fine, but I was taking data from other tables, however, when I added the LEFT JOIN, everything was still working perfectly. The problem is when in the SELECT I put the name of the column to be d...
asked by 08.10.2018 / 22:14
1
answer

As an addition to a 2 foreign key that are both primary?

My problem is as follows, I have 2 COORDINATION and NACCLE_ACADEMIC tables, the relationship between them is N: M (many to many), the structure of the table COORDINATION and NACCLEO_ACADÉMICO the table is as follows: CREATE TABLE coord...
asked by 19.09.2018 / 04:09