Questions tagged as 'phpmyadmin'

Tagged questions
4
answers

Column 'idusuario' in where clause is ambiguous

I'm trying to make a select with inner join . Running the select in phpmyadmin the ERR that returns is this:    Column 'idusuario' in where clause is ambiguous <?php $idusuario = $_GET['idusuario']; $getCli=...
asked by 12.09.2017 / 16:43
1
answer

How do I change MySQL database insertion order?

I want to insert something into my MySQL (PhpMyAdmin) it inserts and above the last post. Example: Yesterday I inserted Nome: Pedro | Idade: 20 Anos and it was at the top because it was the first one to be inserted into the database...
asked by 27.10.2018 / 15:11
2
answers

Replace contents of one table with another?

My case is as follows: I have two tables TAB1 and TAB2 ; the two tables have the same structure: (id, name, nickname). I would like to replace the contents of TAB1 with TAB2 . Everything in TAB2 must be del...
asked by 02.11.2016 / 10:44
2
answers

Return record with the highest number of appearances

Well, I would like to know how to return the record with the field with the highest number of occurrences in a phpMyAdmin database table. See the following image: Iwouldliketoget" Joao ". I tried using mysql_num_rows , but I was n...
asked by 27.08.2016 / 20:02
1
answer

Access Denied phpMyadmin error 2002

I need to use phpmyadmin in xampp, but this is returning me this error    # 2002 - File or directory not found The server is not responding (or the local server socket is not configured   correctly). The connection to the user control, as def...
asked by 08.07.2014 / 18:41
1
answer

Access by ip Phpmyadmin

Inside the folder c: \ wamp \ alias \ phpmyadmin.conf there is the line below to release phpmyadmin access to all machines on the network: <IfDefine APACHE24> Require all granted I would like to know if you can change to relea...
asked by 06.01.2016 / 14:15
1
answer

MyISAM is the default storage engine on this MySQL server? [closed]

I saw this message today:    MyIsam is the storage engine by default in this MySQL server As so " by default "? What fault is that? I use InnoDB, and even then this message appears. Is there any problem in leaving like this? So far...
asked by 16.10.2017 / 22:00
1
answer

Delete select value comparing to another table

Good morning, I'm developing a scheduling website, however, I'm having a hard time trying to display only the times that are available. Explaining: There is a schedule Agendamento´, onde fica registrado o horário de inicio horainicia...
asked by 19.11.2016 / 14:45
1
answer

Bring results from two tables (INNER JOIN error)

I have the secretaries table with the following structure: Andtheworkertablewiththefollowingstructure: Ilinkedtheworkertabletothesecretariestablethroughthefollowingrelation: That is, I'm relating the Foreign key to the 'worker' table's pri...
asked by 25.06.2017 / 20:55
2
answers

Nginx does not import database in phpmyadmin: "413 Request Entity Too Large"

I have a database of 1.31MB which I'm trying to import into my phpmyadmin, which indicates that it supports importing databases of maximum size: 2,048KB. But, I'm not getting it ... every time I try to import it gives this message: "413 R...
asked by 25.09.2015 / 06:48