Questions tagged as 'phpmyadmin'

1
answer

Separate data in table

I'd like to make a separate table for "seasons". Example: Tabela estatisticas: Temporada 1: ID | JOGADOR | PTS | AST | 0 | Leonard | 12 | 7 | 1 | Pedro | 10 | 5 | Temporada 2: ID | JOGADOR | PTS | AST | 0 | L...
asked by 10.06.2017 / 23:23
1
answer

Coloring a field in a column according to parameters

I have a table with 5 columns and 2 records. One of the fields in the record is a number (noteQualif), I need the field in which it is inserted to be painted green if it is larger than 75 and painted red if it is smaller than 75. All data is...
asked by 09.02.2017 / 16:54
1
answer

IF MariaDB phpmyadmin

I'm trying to create a trigger using phpmyadmin with bank MariaDB but when it arrives in the if line it gives a message:    unrecognized statement type. (near IF) The trigger is this: SET @TOTAL = (SELECT COUNT(*) FROM cliente C WHERE C...
asked by 19.03.2017 / 19:24
1
answer

How to create a Trigger for a specific column of a table?

I created a trigger for my X table, for the purpose of making a update record that runs on this table. For each update in the X table, modified (old) values are stored in the Z table. PROBLEMATIC : The X table has several...
asked by 20.12.2016 / 12:36
1
answer

Doubt with this query [closed]

My teacher did the following query to show the total quantity of stock of each product, however I did not quite understand how it does to generate the total inventory quantity of each product, follows the query: SELECT SUM (ret.quantidade) A...
asked by 02.12.2016 / 16:32
3
answers

How do you configure phpmyadmin on linux?

I gave apt-get install phpmyadmin and linux installed it in the etc folder; I ran in the browser http://localhost/phpmyadmin and gave 404 error. I changed and threw the phpmyadmin folder into the www directory, but it...
asked by 21.01.2016 / 16:10
1
answer

MySQL does not connect to server

Hello, I went into phpmyadmin and it appeared, where is that supposed to be the problem ?? Code$coneccao=mysqli_connect("localhost", "root", "MINHASENHA"); mysqli_select_db($coneccao, "luppbox"); The server is hosted in a VPS, instead of l...
asked by 14.05.2015 / 18:14
1
answer

Package duplicity error while updating ubuntu 14.04 [closed]

In ubuntu 14.04, I am trying to update the repositories with apt-get update. However, for the error of duplicity below. I'm doing the procedure to install phpmyadmin. Thanks in advance for your help. # apt-get update Ign http://br.archive.ubun...
asked by 04.07.2014 / 01:09
1
answer

How to create the mysql.socket file

I am using phpmyadmin because it is returning me an error that refers to the lack of mysql.sock , is there a possibility of installing this file? Error reported below:    error 2002: file not found     
asked by 03.07.2014 / 16:19
2
answers

activating phpmyadmin [closed]

I'm running XAMPP, however my phpmyadmin is disabled I've done everything to activate, there is some other option, follow below the error.    # 2002 - File or directory not found       The server is not responding (or the local server socket...
asked by 02.07.2014 / 21:58