Questions tagged as 'phpmyadmin'

Tagged questions
2
answers

Insert special characters into mysql and pull these identical values in the web application [duplicate]

Good evening, I need to add values to the database by mysql so that they have special characters. I can add, but I can not pull the values correctly, they end up coming with symbols in place of the special characters, for example ... Comput...
asked by 27.07.2017 / 05:09
2
answers

How to create a trigger to save updates of two tables?

I have two tables: table1 : with three columns product_id , product_name , product_price ; table2 : with four columns tag_name , product_id , tag_name , tag_name li> I've created a new table3 : with three columns product_id ,...
asked by 16.12.2016 / 12:46
1
answer

Error in mysql query

I'm on the clock without noticing what's wrong with my query. I would like you to give me some help SELECT 'recargas'.'valor_recarga' as saldo FROM 'contas_pessoais' INNER JOIN 'contas' ON 'contas'.'titular' = 'contas_pessoais'.'titular' INN...
asked by 26.08.2015 / 16:13
1
answer

Error to import mysql table in phpmyadmin

I'm having a problem importing a table into phpmyadmin. Table: CREATE TABLE ManterEmpresa ( IdEmpresa INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, CNPJ INTEGER UNSIGNED NOT NULL, NomeEmpresa VARCHAR(45) NOT NULL, Logo VARCHAR(45...
asked by 05.11.2015 / 15:28
1
answer

Table already exists when creating a new mysql table, even if it does not exist

I have a database that accidentally deletes a table and when I try to recreate it, it says the table already exists, but it does not appear. When executing the command: SELECT * FROM INFORMATION_SCHEMA.TABLES She does not show up! How can I...
asked by 03.01.2019 / 10:07
2
answers

How to organize DB information printed on the page

I created a panel, where I want to show the information that is in the db, these are printed on the screen through the code: <?php $servidor = "localhost"; $usuario = "root"; $senha = ""; $dbname = "id8146007_contasadm"; $conn = mysqli_con...
asked by 18.12.2018 / 03:58
1
answer

Error generating XML from a MySQL database

I need to generate XML from a MySQL database. I am using MySQL database with PHP (which makes it clear that I am new to PHP, what I did was with a YouTube video ( this ) and very little of what I know). <?php define('HOSTNAME', '127.0....
asked by 07.12.2018 / 20:07
1
answer

Convert all mysql bank to lowercase

Is it possible to convert all columns of tables in a mysql database to lowercase letters? I have several records and several tables, all of them are a miscellaneous case (and some with emphasis). Detail: the type is InnoDB ; collation...
asked by 04.10.2018 / 00:12
1
answer

Create slug across the MYSQL database

I have an older MYSQL database and it has a news table and I needed to create a "slug" column to save the news slug. So, I would like to create an automatic slug for all records that are registered in this table. Table: Columns Titulo --...
asked by 16.08.2018 / 15:57
1
answer

How do I put a .php pageing script on my website?

I've already built a website, but I'm having trouble with the paging system. I do not know how to mess with php, I found some videos on youtube and got a paging script in php. Now I need to put this script inside my site. I think for this I n...
asked by 05.08.2018 / 01:47